asp.net - 是否可以在列中说明某个值是借方还是贷方？

Question

我正在编写一个 ASP.NET 程序，它将数据从 Excel 文件导入数据库。该 Excel 文件有一个列“欧元值”（它是葡萄牙语所以..“Valor em EUR”），我希望在导入文件期间，代码在 SQL Server 中创建一个名为“借方/贷方”的列。该列将定义“欧元价值”中的值是借方（负数）还是贷方（正数）。

例如：导入前的表：

Date of mov. Value in Euro 
12-09-2010   -5000
 3-19-2010   1928

导入后的表格：

Date of mov. Value in Euro  Debit/Credit 
12-09-2010   -5000            Debit
 3-19-2010   1928             Credit

我在 asp.net 中的代码：

protected void Upload_Click(object sender, EventArgs e)
{
    string excelPath = Server.MapPath("~/Nova pasta/") + Path.GetFileName(FileUpload1.PostedFile.FileName);

    string filepath = Server.MapPath("~/Nova pasta/") + Path.GetFileName(FileUpload1.FileName);
    string filename = Path.GetFileName(filepath);

    FileUpload1.SaveAs(excelPath);
    string ext = Path.GetExtension(filename);

    String strConnection = @"Data Source=PEDRO-PC\SQLEXPRESS;Initial Catalog=costumizado;Persist Security Info=True;User ID=sa;Password=1234";
    string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=\"Excel 12.0 Xml;HRD=YES;IMEX=1;\"";

    OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);

    OleDbCommand cmd = new OleDbCommand("Select * from [rptListaMovs_4$]", excelConnection);

    excelConnection.Open();
    cmd.ExecuteNonQuery();

    DataSet ds = new DataSet();

    SqlDataAdapter da = new SqlDataAdapter("Select * from [rptListaMovs_4$]", strConnection);

    OleDbDataReader dReader;
    dReader = cmd.ExecuteReader();

    using (SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection))
    {
        sqlBulk.DestinationTableName = "Dados";
        sqlBulk.ColumnMappings.Add("Data Mov", "Data Mov.");
        sqlBulk.ColumnMappings.Add("Data Valor", "Data Valor");
        sqlBulk.ColumnMappings.Add("Descrição do Movimento" , "Descrição do Movimento");
        sqlBulk.ColumnMappings.Add("Valor em EUR", "Valor em EUR");

        sqlBulk.WriteToServer(dReader);
    }

    excelConnection.Close();
}

希望你们明白我的意思......我没有找到任何关于这个

标签： asp.netsql-serverdatabase