Beispiel #1
0
        private int AddData(DataTable dt)
        {
            int       rs = 0;
            Hashtable ht = new Hashtable();

            foreach (DataRow row in dt.Rows)
            {
                ht.Clear();
                ht["SHIP_ID"]      = row["SHIP_ID"].ToString();
                ht["VOYAGE_NO"]    = row["VOYAGE_NO"].ToString();
                ht["BILL_NO"]      = row["BILL_NO"].ToString();
                ht["I_E_FLAG"]     = row["I_E_FLAG"].ToString();
                ht["I_E_PORT"]     = row["I_E_PORT"].ToString();
                ht["L_D_PORT"]     = row["L_D_PORT"].ToString();
                ht["TRAF_NAME"]    = row["TRAF_NAME"].ToString();
                ht["SEND_NAME"]    = row["SEND_NAME"].ToString();
                ht["OWNER_NAME"]   = row["OWNER_NAME"].ToString();
                ht["SEND_COUNTRY"] = row["SEND_COUNTRY"].ToString();
                ht["SEND_CITY"]    = row["SEND_CITY"].ToString();
                //  ht["SEND_ID"] = row["SEND_ID"].ToString();
                ht["TRADE_CODE"]  = row["TRADE_CO"].ToString();
                ht["TRADE_NAME"]  = row["TRADE_NAME"].ToString();
                ht["MAIN_G_NAME"] = row["MAIN_G_NAME"].ToString();
                ht["PACK_NO"]     = ConvertHelper.ToSafeNullabledecimal(row["PACK_NO"]);
                ht["GROSS_WT"]    = ConvertHelper.ToSafeNullabledecimal(row["GROSS_WT"]);
                ht["TOTAL_VALUE"] = ConvertHelper.ToSafeNullabledecimal(row["TOTAL_VALUE"]);
                ht["CURR_CODE"]   = row["CURR_CODE"].ToString();
                ht["I_E_DATE"]    = ConvertHelper.ToSafeNullableDateTime(row["I_E_DATE"]);
                ht["D_DATE"]      = ConvertHelper.ToSafeNullableDateTime(row["D_DATE"]);
                ht["ENTRY_TYPE"]  = row["ENTRY_TYPE"].ToString();
                ht["DEC_TYPE"]    = row["DEC_TYPE"].ToString();
                ht["DEC_ER"]      = row["DEC_ER"].ToString();
                ht["DEC_DATE"]    = ConvertHelper.ToSafeNullableDateTime(row["DEC_DATE"]);
                ht["READ_DATE"]   = ConvertHelper.ToSafeNullableDateTime(row["READ_DATE"]);
                //   ht["READ_FLAG"] = row["READ_FLAG"].ToString();
                // ht["NOTE"] = row["NOTE"].ToString();
                //   ht["M_CHECKH"] = row["M_CHECKH"].ToString();
                int result = db.SaveHead(ht);
                rs += result;
            }
            return(rs);
        }