private void newButton_Click(object sender, EventArgs e) { clsOrderinfo item = new clsOrderinfo(); item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); item.xinzeng = "true"; this.bindingSource1.Add(item); this.dataGridView1.Refresh(); }
private clsOrderinfo GetSelectedSchedule() { clsOrderinfo schedule = null; var row = this.dataGridView1.CurrentRow; if (row != null) { schedule = row.DataBoundItem as clsOrderinfo; } return schedule; }
private void read() { userlist_Server = new List <clsOrderinfo>(); clsOrderinfo item = new clsOrderinfo(); item.hetongbianhao = this.txname.Text; if (item.hetongbianhao == null || item.hetongbianhao == "") { errorProvider1.SetError(txname, "不能为空"); return; } else { errorProvider1.SetError(txname, String.Empty); } item.kehuxingming = this.txadress.Text; item.kehudizhi = this.tshuihao.Text; item.lianxidianhua = this.txbank.Text; item.hetongdaoqishijian = txaccount.Text; item.hetongshichang = txphone.Text; item.shishou = txcontact.Text; item.yuejia = txyuejia.Text; item.mianji = txmianji.Text; item.tixingshoufeishijian = txtixingshoufeishijian.Text; item.meiyuanci = txmeiyueci.Text; item.zongcishu = txzongcishu.Text; item.shengyushu = txshengyushuBOX.Text; item.chaboli = txchaboli.Text; item.kehuyaoqiu = txkehuyaoqiu.Text; item.beizhu = txbeizhu.Text; item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); userlist_Server.Add(item); }
public List <clsOrderinfo> findOrder(string findtext) { MySql.Data.MySqlClient.MySqlDataReader reader = MySqlHelper.ExecuteReader(findtext); List <clsOrderinfo> ClaimReport_Server = new List <clsOrderinfo>(); while (reader.Read()) { clsOrderinfo item = new clsOrderinfo(); item.order_id = reader.GetInt32(0); if (reader.GetValue(1) != null && Convert.ToString(reader.GetValue(1)) != "") { item.customer_name = reader.GetString(1); } if (reader.GetValue(2) != null && Convert.ToString(reader.GetValue(2)) != "") { item.dinghuoshijian = Convert.ToDateTime(reader.GetString(2)); } if (reader.GetValue(3) != null && Convert.ToString(reader.GetValue(3)) != "") { item.order_no = reader.GetString(3); } if (reader.GetValue(4) != null && Convert.ToString(reader.GetValue(4)) != "") { item.Product_no = reader.GetString(4); } if (reader.GetValue(5) != null && Convert.ToString(reader.GetValue(5)) != "") { item.Product_name = reader.GetString(5); } if (reader.GetValue(6) != null && Convert.ToString(reader.GetValue(6)) != "") { item.shuliang = reader.GetString(6); } if (reader.GetValue(7) != null && Convert.ToString(reader.GetValue(7)) != "") { item.Product_salse = reader.GetString(7); } if (reader.GetValue(8) != null && Convert.ToString(reader.GetValue(8)) != "") { item.jine = reader.GetString(8); } if (reader.GetValue(9) != null && Convert.ToString(reader.GetValue(9)) != "") { item.yujijiaohuoshijian = Convert.ToDateTime(reader.GetString(9)); } //if (reader.GetString(10) != null && reader.GetString(10) != "") if (reader.GetValue(10) != null && Convert.ToString(reader.GetValue(10)) != "") { item.jianhuoshijian2 = Convert.ToDateTime(reader.GetString(10)); } if (reader.GetValue(11) != null && Convert.ToString(reader.GetValue(11)) != "") { item.dingdanguanliyuan = reader.GetString(11); } if (reader.GetValue(12) != null && Convert.ToString(reader.GetValue(12)) != "") { item.kaipiao = reader.GetString(12); } if (reader.GetValue(13) != null && Convert.ToString(reader.GetValue(13)) != "") { item.shifoujiaohuo = reader.GetString(13); } if (reader.GetString(14) != null && reader.GetString(14) != "") { item.fukuanriqi = Convert.ToDateTime(reader.GetString(14)); } if (reader.GetValue(15) != null && Convert.ToString(reader.GetValue(15)) != "") { item.beizhu = reader.GetString(15); } //if (reader.GetString(16) != null && reader.GetString(16) != "") if (reader.GetValue(16) != null && Convert.ToString(reader.GetValue(16)) != "") { item.Input_Date = Convert.ToDateTime(reader.GetString(16)); } ClaimReport_Server.Add(item); //这里做数据处理.... } return(ClaimReport_Server); }
private string sql_yuju(DoWorkEventArgs e, clsOrderinfo item, string conditions) { string unsal = conditions; if (item.hetongbianhao != null) { conditions += " hetongbianhao ='" + item.hetongbianhao + "'"; } if (item.kehuxingming != null) { conditions += " ,kehuxingming ='" + item.kehuxingming + "'"; } if (item.kehudizhi != null) { conditions += " ,kehudizhi ='" + item.kehudizhi + "'"; } if (item.lianxidianhua != null) { conditions += " ,lianxidianhua ='" + item.lianxidianhua + "'"; } if (item.hetongdaoqishijian != null) { conditions += " ,hetongdaoqishijian ='" + item.hetongdaoqishijian + "'"; } if (item.hetongshichang != null) { conditions += " ,hetongshichang ='" + item.hetongshichang + "'"; } if (item.shishou != null) { conditions += " ,shishou ='" + item.shishou + "'"; } if (item.yuejia != null) { conditions += " ,yuejia ='" + item.yuejia + "'"; } if (item.mianji != null) { conditions += " ,mianji ='" + item.mianji + "'"; } if (item.tixingshoufeishijian != null) { conditions += " ,tixingshoufeishijian ='" + item.tixingshoufeishijian + "'"; } if (item.meiyuanci != null) { conditions += " ,meiyuanci ='" + item.meiyuanci + "'"; } if (item.zongcishu != null) { conditions += " ,zongcishu ='" + item.zongcishu + "'"; } if (item.shengyushu != null) { conditions += " ,shengyushu ='" + item.shengyushu + "'"; } if (item.chaboli != null) { conditions += " ,chaboli ='" + item.chaboli + "'"; } if (item.kehuyaoqiu != null) { conditions += " ,kehuyaoqiu ='" + item.kehuyaoqiu + "'"; } if (item.beizhu != null) { conditions += " ,beizhu ='" + item.beizhu + "'"; } //if (item.xinzeng != null) //{ // conditions += " ,xinzeng ='" + item.xinzeng + "'"; //} if (item.Message != null) { conditions += " ,Message ='" + item.Message + "'"; } if (item.Input_Date != null) { conditions += " ,Input_Date ='" + item.Input_Date.ToString("yyyy/MM/dd") + "'"; } if (item.xinzeng == "true") { conditions = "insert into GZCleaning_Order(hetongbianhao,kehuxingming,kehudizhi,lianxidianhua,hetongdaoqishijian,hetongshichang,shishou,yuejia,mianji,tixingshoufeishijian,meiyuanci,zongcishu,shengyushu,chaboli,kehuyaoqiu,beizhu,Input_Date,Message) values ('" + item.hetongbianhao + "','" + item.kehuxingming + "','" + item.kehudizhi + "','" + item.lianxidianhua + "','" + item.hetongdaoqishijian + "','" + item.hetongshichang + "','" + item.shishou + "','" + item.yuejia + "','" + item.mianji + "','" + item.tixingshoufeishijian + "','" + item.meiyuanci + "','" + item.zongcishu + "','" + item.shengyushu + "','" + item.chaboli + "','" + item.kehuyaoqiu + "','" + item.beizhu + "','" + item.Input_Date.ToString("yyyy/MM/dd") + "','" + item.Message + "')"; } else if (is_AdminIS == true) { conditions = "update GZCleaning_Order set " + conditions + " where order_id = " + item.order_id + " "; } else if (is_AdminIS == false) { if (item.shengyushu != null) { unsal += "shengyushu ='" + item.shengyushu + "'"; } unsal = "update GZCleaning_Order set " + unsal + " where order_id = " + item.order_id + " "; return(unsal); //e.Result = "[" + item.kehuxingming + "]普通用户无权修改单据,如需修改请联系管理员"; //throw new Exception("[" + item.kehuxingming + "]普通用户 无权修改单据,如需修改请联系管理员"); } return(conditions); }
private bool dailysaveList(BackgroundWorker worker, DoWorkEventArgs e) { WorkerArgument arg = e.Argument as WorkerArgument; clsAllnew BusinessHelp = new clsAllnew(); bool success = true; try { int rowCount = changeindex.Count; arg.OrderCount = rowCount; int j = 1; int progress = 0; #region MyRegion for (int ik = 0; ik < changeindex.Count; ik++) { j = ik; arg.CurrentIndex = j + 1; progress = Convert.ToInt16(((j + 1) * 1.0 / rowCount) * 100); int i = changeindex[ik]; var row = dataGridView1.Rows[i]; var model = row.DataBoundItem as clsOrderinfo; clsOrderinfo item = new clsOrderinfo(); item.hetongbianhao = Convert.ToString(dataGridView1.Rows[i].Cells["hetongbianhao"].EditedFormattedValue.ToString()); item.kehuxingming = Convert.ToString(dataGridView1.Rows[i].Cells["kehuxingming"].EditedFormattedValue.ToString()); item.kehudizhi = Convert.ToString(dataGridView1.Rows[i].Cells["kehudizhi"].EditedFormattedValue.ToString()); item.lianxidianhua = Convert.ToString(dataGridView1.Rows[i].Cells["lianxidianhua"].EditedFormattedValue.ToString()); item.hetongdaoqishijian = Convert.ToString(dataGridView1.Rows[i].Cells["hetongdaoqishijian"].EditedFormattedValue.ToString()); item.hetongshichang = Convert.ToString(dataGridView1.Rows[i].Cells["hetongshichang"].EditedFormattedValue.ToString()); item.shishou = Convert.ToString(dataGridView1.Rows[i].Cells["shishou"].EditedFormattedValue.ToString()); item.yuejia = Convert.ToString(dataGridView1.Rows[i].Cells["yuejia"].EditedFormattedValue.ToString()); item.mianji = Convert.ToString(dataGridView1.Rows[i].Cells["mianji"].EditedFormattedValue.ToString()); item.tixingshoufeishijian = Convert.ToString(dataGridView1.Rows[i].Cells["tixingshoufeishijian"].EditedFormattedValue.ToString()); item.meiyuanci = Convert.ToString(dataGridView1.Rows[i].Cells["meiyuanci"].EditedFormattedValue.ToString()); item.zongcishu = Convert.ToString(dataGridView1.Rows[i].Cells["zongcishu"].EditedFormattedValue.ToString()); item.shengyushu = Convert.ToString(dataGridView1.Rows[i].Cells["shengyushu"].EditedFormattedValue.ToString()); item.chaboli = Convert.ToString(dataGridView1.Rows[i].Cells["chaboli"].EditedFormattedValue.ToString()); item.kehuyaoqiu = Convert.ToString(dataGridView1.Rows[i].Cells["kehuyaoqiu"].EditedFormattedValue.ToString()); item.beizhu = Convert.ToString(dataGridView1.Rows[i].Cells["beizhu"].EditedFormattedValue.ToString()); item.xinzeng = Convert.ToString(dataGridView1.Rows[i].Cells["xinzeng"].EditedFormattedValue.ToString()); item.Message = Convert.ToString(dataGridView1.Rows[i].Cells["Message"].EditedFormattedValue.ToString()); item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); item.order_id = model.order_id; #endregion #region MyRegion var startAt = this.stockOutDateTimePicker.Value.AddDays(0).Date; #region 构造查询条件 string conditions = ""; conditions = sql_yuju(e, item, conditions); // conditions += " order by Id desc"; #endregion #endregion int isrun = BusinessHelp.updatecustomer_Server(conditions); if (item.xinzeng == "true" && isrun == 1) { item.xinzeng = ""; } if (arg.CurrentIndex % 5 == 0) { backgroundWorker2.ReportProgress(progress, arg); } } backgroundWorker2.ReportProgress(100, arg); e.Result = string.Format("{0} 已保存 !", changeindex.Count); } catch (Exception ex) { if (!e.Cancel) { e.Result = ex.Message + ""; } success = false; } return(success); }
private bool dailysaveList(BackgroundWorker worker, DoWorkEventArgs e) { WorkerArgument arg = e.Argument as WorkerArgument; clsAllnew BusinessHelp = new clsAllnew(); bool success = true; try { int rowCount = changeindex.Count; arg.OrderCount = rowCount; int j = 1; int progress = 0; #region MyRegion for (int ik = 0; ik < changeindex.Count; ik++) { j = ik; arg.CurrentIndex = j + 1; progress = Convert.ToInt16(((j + 1) * 1.0 / rowCount) * 100); int i = changeindex[ik]; var row = dataGridView1.Rows[i]; var model = row.DataBoundItem as clsOrderinfo; clsOrderinfo item = new clsOrderinfo(); item.customer_name = Convert.ToString(dataGridView1.Rows[i].Cells["customer_name"].EditedFormattedValue.ToString()); if (dataGridView1.Rows[i].Cells["dinghuoshijian"].EditedFormattedValue.ToString() != "") item.dinghuoshijian = Convert.ToDateTime(dataGridView1.Rows[i].Cells["dinghuoshijian"].EditedFormattedValue.ToString()); item.order_no = Convert.ToString(dataGridView1.Rows[i].Cells["order_no"].EditedFormattedValue.ToString()); item.Product_no = Convert.ToString(dataGridView1.Rows[i].Cells["Product_no"].EditedFormattedValue.ToString()); item.Product_name = Convert.ToString(dataGridView1.Rows[i].Cells["Product_name"].EditedFormattedValue.ToString()); item.shuliang = Convert.ToString(dataGridView1.Rows[i].Cells["shuliang"].EditedFormattedValue.ToString()); item.Product_salse = Convert.ToString(dataGridView1.Rows[i].Cells["Product_salse"].EditedFormattedValue.ToString()); item.jine = Convert.ToString(dataGridView1.Rows[i].Cells["jine"].EditedFormattedValue.ToString()); if (dataGridView1.Rows[i].Cells["yujijiaohuoshijian"].EditedFormattedValue.ToString() != null && dataGridView1.Rows[i].Cells["yujijiaohuoshijian"].EditedFormattedValue.ToString() != "") item.yujijiaohuoshijian = Convert.ToDateTime(dataGridView1.Rows[i].Cells["yujijiaohuoshijian"].EditedFormattedValue.ToString()); if (dataGridView1.Rows[i].Cells["jianhuoshijian2"].EditedFormattedValue.ToString() != null && dataGridView1.Rows[i].Cells["jianhuoshijian2"].EditedFormattedValue.ToString() != "") item.jianhuoshijian2 = Convert.ToDateTime(dataGridView1.Rows[i].Cells["jianhuoshijian2"].EditedFormattedValue.ToString()); item.dingdanguanliyuan = Convert.ToString(dataGridView1.Rows[i].Cells["dingdanguanliyuan"].EditedFormattedValue.ToString()); item.kaipiao = Convert.ToString(dataGridView1.Rows[i].Cells["kaipiao"].EditedFormattedValue.ToString()); item.shifoujiaohuo = Convert.ToString(dataGridView1.Rows[i].Cells["shifoujiaohuo"].EditedFormattedValue.ToString()); if (dataGridView1.Rows[i].Cells["fukuanriqi"].EditedFormattedValue.ToString() != null && dataGridView1.Rows[i].Cells["fukuanriqi"].EditedFormattedValue.ToString() != "") item.fukuanriqi = Convert.ToDateTime(dataGridView1.Rows[i].Cells["fukuanriqi"].EditedFormattedValue.ToString()); item.beizhu = Convert.ToString(dataGridView1.Rows[i].Cells["beizhu"].EditedFormattedValue.ToString()); item.xinzeng = Convert.ToString(dataGridView1.Rows[i].Cells["xinzeng"].EditedFormattedValue.ToString()); item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); item.order_id = model.order_id; #endregion #region MyRegion var startAt = this.stockOutDateTimePicker.Value.AddDays(0).Date; string conditions = ""; #region 构造查询条件 if (item.customer_name != null) { conditions += " customer_name ='" + item.customer_name + "'"; } if (item.dinghuoshijian != null) { conditions += " ,dinghuoshijian ='" + item.dinghuoshijian.ToString("yyyy/MM/dd") + "'"; } if (item.order_no != null) { conditions += " ,order_no ='" + item.order_no + "'"; } if (item.Product_no != null) { conditions += " ,Product_no ='" + item.Product_no + "'"; } if (item.Product_name != null) { conditions += " ,Product_name ='" + item.Product_name + "'"; } if (item.shuliang != null) { conditions += " ,shuliang ='" + item.shuliang + "'"; } if (item.Product_salse != null) { conditions += " ,Product_salse ='" + item.Product_salse + "'"; } if (item.jine != null) { conditions += " ,jine ='" + item.jine + "'"; } if (item.yujijiaohuoshijian != null && item.yujijiaohuoshijian != Convert.ToDateTime("01/01/0001 00:00:00")) { conditions += " ,yujijiaohuoshijian ='" + item.yujijiaohuoshijian.ToString("yyyy/MM/dd") + "'"; } if (item.jianhuoshijian2 != null && item.jianhuoshijian2 != Convert.ToDateTime("01/01/0001 00:00:00")) { conditions += " ,jianhuoshijian2 ='" + item.jianhuoshijian2.ToString("yyyy/MM/dd") + "'"; } if (item.dingdanguanliyuan != null) { conditions += " ,dingdanguanliyuan ='" + item.dingdanguanliyuan + "'"; } if (item.kaipiao != null) { conditions += " ,kaipiao ='" + item.kaipiao + "'"; } if (item.shifoujiaohuo != null) { conditions += " ,shifoujiaohuo ='" + item.shifoujiaohuo + "'"; } if (item.fukuanriqi != null && item.fukuanriqi != Convert.ToDateTime("01/01/0001 00:00:00")) { conditions += " ,fukuanriqi ='" + item.fukuanriqi.ToString("yyyy/MM/dd") + "'"; } if (item.beizhu != null) { conditions += " ,beizhu ='" + item.beizhu + "'"; } if (item.Input_Date != null) { conditions += " ,Input_Date ='" + item.Input_Date.ToString("yyyy/MM/dd") + "'"; } if (item.xinzeng == "true") conditions = "insert into JNOrder_order(customer_name,dinghuoshijian,order_no,Product_no,Product_name,shuliang,Product_salse,jine,yujijiaohuoshijian,jianhuoshijian2,dingdanguanliyuan,kaipiao,shifoujiaohuo,fukuanriqi,beizhu,Input_Date) values ('" + item.customer_name + "','" + item.dinghuoshijian.ToString("yyyy/MM/dd") + "','" + item.order_no + "','" + item.Product_no + "','" + item.Product_name + "','" + item.shuliang + "','" + item.Product_salse + "','" + item.jine + "','" + item.yujijiaohuoshijian.ToString("yyyy/MM/dd") + "','" + item.jianhuoshijian2.ToString("yyyy/MM/dd") + "','" + item.dingdanguanliyuan + "','" + item.kaipiao + "','" + item.shifoujiaohuo + "','" + item.fukuanriqi.ToString("yyyy/MM/dd") + "','" + item.beizhu + "','" + item.Input_Date.ToString("yyyy/MM/dd") + "')"; else conditions = "update JNOrder_order set " + conditions + " where order_id = " + item.order_id + " "; // conditions += " order by Id desc"; #endregion #endregion int isrun = BusinessHelp.updateProduct_Server(conditions); if (item.xinzeng == "true" && isrun == 1) item.xinzeng = ""; if (arg.CurrentIndex % 5 == 0) { backgroundWorker2.ReportProgress(progress, arg); } } backgroundWorker2.ReportProgress(100, arg); e.Result = string.Format("{0} 已保存 !", changeindex.Count); } catch (Exception ex) { if (!e.Cancel) { e.Result = ex.Message + ""; } success = false; } return success; }
public List <clsOrderinfo> Read_Excel(string Alist) { List <clsOrderinfo> MAPPINGResult = new List <clsOrderinfo>(); try { System.Globalization.CultureInfo CurrentCI = System.Threading.Thread.CurrentThread.CurrentCulture; System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); Microsoft.Office.Interop.Excel.Application excelApp; { string path = Alist; excelApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook analyWK = excelApp.Workbooks.Open(path, Type.Missing, Type.Missing, Type.Missing, "htc", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); Microsoft.Office.Interop.Excel.Worksheet WS = (Microsoft.Office.Interop.Excel.Worksheet)analyWK.Worksheets["总表"]; Microsoft.Office.Interop.Excel.Range rng; rng = WS.Range[WS.Cells[1, 1], WS.Cells[WS.UsedRange.Rows.Count, 26]]; int rowCount = WS.UsedRange.Rows.Count - 1; object[,] o = new object[1, 1]; o = (object[, ])rng.Value2; int wscount = analyWK.Worksheets.Count; clsCommHelp.CloseExcel(excelApp, analyWK); for (int i = 5; i <= rowCount; i++) { clsOrderinfo temp = new clsOrderinfo(); #region 基础信息 temp.hetongbianhao = ""; if (o[i, 1] != null) { temp.hetongbianhao = o[i, 1].ToString().Trim(); } temp.kehuxingming = ""; if (o[i, 2] != null) { temp.kehuxingming = o[i, 2].ToString().Trim(); } if (temp.kehuxingming == null || temp.kehuxingming == "") { break; } temp.kehudizhi = ""; if (o[i, 3] != null) { temp.kehudizhi = o[i, 3].ToString().Trim(); } temp.lianxidianhua = ""; if (o[i, 4] != null) { temp.lianxidianhua = o[i, 4].ToString().Trim(); } temp.hetongdaoqishijian = ""; if (o[i, 5] != null) { temp.hetongdaoqishijian = o[i, 5].ToString().Trim(); } temp.hetongshichang = ""; if (o[i, 6] != null) { temp.hetongshichang = o[i, 6].ToString().Trim(); } temp.shishou = ""; if (o[i, 7] != null) { temp.shishou = o[i, 7].ToString().Trim(); } temp.yuejia = ""; if (o[i, 8] != null) { temp.yuejia = o[i, 8].ToString().Trim(); } temp.mianji = ""; if (o[i, 9] != null) { temp.mianji = o[i, 9].ToString().Trim(); } temp.tixingshoufeishijian = ""; if (o[i, 10] != null) { temp.tixingshoufeishijian = o[i, 10].ToString().Trim(); } temp.meiyuanci = ""; if (o[i, 11] != null) { temp.meiyuanci = o[i, 11].ToString().Trim(); } temp.zongcishu = ""; if (o[i, 12] != null) { temp.zongcishu = o[i, 12].ToString().Trim(); } temp.shengyushu = ""; if (o[i, 13] != null) { temp.shengyushu = o[i, 13].ToString().Trim(); } temp.chaboli = ""; if (o[i, 14] != null) { temp.chaboli = o[i, 14].ToString().Trim(); } temp.kehuyaoqiu = ""; if (o[i, 15] != null) { temp.kehuyaoqiu = o[i, 15].ToString().Trim(); } temp.beizhu = ""; if (o[i, 16] != null) { temp.beizhu = o[i, 16].ToString().Trim(); } // temp.Input_Date = DateTime.Now; #endregion MAPPINGResult.Add(temp); } } } catch (Exception ex) { MessageBox.Show("Error: 01032 表格维护有误,请重新检查格式及命名!"); return(null); throw; } return(MAPPINGResult); }
public List <clsOrderinfo> findOrder(string findtext) { SQLiteConnection dbConn = new SQLiteConnection("Data Source=" + dataSource); dbConn.Open(); SQLiteCommand dbCmd = dbConn.CreateCommand(); dbCmd.CommandText = findtext; DbDataReader reader = SQLiteHelper.ExecuteReader("Data Source=" + newsth, dbCmd); List <clsOrderinfo> ClaimReport_Server = new List <clsOrderinfo>(); while (reader.Read()) { clsOrderinfo item = new clsOrderinfo(); item.order_id = reader.GetInt32(0); if (reader.GetValue(1) != null && Convert.ToString(reader.GetValue(1)) != "") { item.hetongbianhao = reader.GetString(1); } if (reader.GetValue(2) != null && Convert.ToString(reader.GetValue(2)) != "") { item.kehuxingming = Convert.ToString(reader.GetString(2)); } if (reader.GetValue(3) != null && Convert.ToString(reader.GetValue(3)) != "") { item.kehudizhi = reader.GetString(3); } if (reader.GetValue(4) != null && Convert.ToString(reader.GetValue(4)) != "") { item.lianxidianhua = reader.GetString(4); } if (reader.GetValue(5) != null && Convert.ToString(reader.GetValue(5)) != "") { item.hetongdaoqishijian = reader.GetString(5); } if (reader.GetValue(6) != null && Convert.ToString(reader.GetValue(6)) != "") { item.hetongshichang = reader.GetString(6); } if (reader.GetValue(7) != null && Convert.ToString(reader.GetValue(7)) != "") { item.shishou = reader.GetString(7); } if (reader.GetValue(8) != null && Convert.ToString(reader.GetValue(8)) != "") { item.yuejia = reader.GetString(8); } if (reader.GetValue(9) != null && Convert.ToString(reader.GetValue(9)) != "") { item.mianji = Convert.ToString(reader.GetString(9)); } if (reader.GetValue(10) != null && Convert.ToString(reader.GetValue(10)) != "") { item.tixingshoufeishijian = Convert.ToString(reader.GetString(10)); } if (reader.GetValue(11) != null && Convert.ToString(reader.GetValue(11)) != "") { item.meiyuanci = reader.GetString(11); } if (reader.GetValue(12) != null && Convert.ToString(reader.GetValue(12)) != "") { item.zongcishu = reader.GetString(12); } if (reader.GetValue(13) != null && Convert.ToString(reader.GetValue(13)) != "") { item.shengyushu = reader.GetString(13); } if (reader.GetString(14) != null && reader.GetString(14) != "") { item.chaboli = Convert.ToString(reader.GetString(14)); } if (reader.GetValue(15) != null && Convert.ToString(reader.GetValue(15)) != "") { item.kehuyaoqiu = reader.GetString(15); } if (reader.GetValue(16) != null && Convert.ToString(reader.GetValue(16)) != "") { item.beizhu = Convert.ToString(reader.GetString(16)); } if (reader.GetValue(17) != null && Convert.ToString(reader.GetValue(17)) != "") { item.Input_Date = Convert.ToDateTime(reader.GetString(17)); } if (reader.GetValue(18) != null && Convert.ToString(reader.GetValue(18)) != "") { item.xinzeng = Convert.ToString(reader.GetString(18)); } if (reader.GetValue(19) != null && Convert.ToString(reader.GetValue(19)) != "") { item.Message = Convert.ToString(reader.GetString(19)); } ClaimReport_Server.Add(item); } return(ClaimReport_Server); }