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);
}
