private void newButton_Click(object sender, EventArgs e)
{
cls_kehucishufashengshijian_info item = new cls_kehucishufashengshijian_info();
item.Input_Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd"));
item.xinzeng = "true";
item.kehuxingming = b_kehuxingming;
this.bindingSource1.Add(item);
this.dataGridView1.Refresh();
}
private cls_kehucishufashengshijian_info GetSelectedSchedule()
{
cls_kehucishufashengshijian_info schedule = null;
var row = this.dataGridView1.CurrentRow;
if (row != null)
{
schedule = row.DataBoundItem as cls_kehucishufashengshijian_info;
}
return(schedule);
}
private string sql_yuju(DoWorkEventArgs e, cls_kehucishufashengshijian_info item, string conditions)
{
string unsal = conditions;
if (item.kehuxingming != null)
{
conditions += " kehuxingming ='" + item.kehuxingming + "'";
}
if (item.shangcichugongshijian != null)
{
conditions += " ,shangcichugongshijian ='" + item.shangcichugongshijian + "'";
}
if (item.shangcichugongbaojie != null)
{
conditions += " ,shangcichugongbaojie ='" + item.shangcichugongbaojie + "'";
}
if (item.kehupingjia != null)
{
conditions += " ,kehupingjia ='" + item.kehupingjia + "'";
}
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 GZCleaning_Status(kehuxingming,shangcichugongshijian,shangcichugongbaojie,kehupingjia,beizhu,Input_Date) values ('" + item.kehuxingming + "','" + item.shangcichugongshijian + "','" + item.shangcichugongbaojie + "','" + item.kehupingjia + "','" + item.beizhu + "','" + item.Input_Date.ToString("yyyy/MM/dd") + "')";
}
else if (is_AdminIS == true)
{
conditions = "update GZCleaning_Status set " + conditions + " where status_id = " + item.status_id + " ";
}
else if (is_AdminIS == false)
{
if (item.shangcichugongshijian != null)
{
unsal += "shangcichugongshijian ='" + item.shangcichugongshijian + "'";
}
unsal = "update GZCleaning_Status set " + unsal + " where status_id = " + item.status_id + " ";
return(unsal);
// e.Result = "[" + item.kehuxingming + "]普通用户无权修改单据，如需修改请联系管理员";
// throw new Exception("[" + item.kehuxingming + "]普通用户 无权修改单据，如需修改请联系管理员");
}
return(conditions);
}
public List <cls_kehucishufashengshijian_info> findStatus(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 <cls_kehucishufashengshijian_info> ClaimReport_Server = new List <cls_kehucishufashengshijian_info>();
while (reader.Read())
{
cls_kehucishufashengshijian_info item = new cls_kehucishufashengshijian_info();
item.status_id = reader.GetInt32(0);
if (reader.GetValue(1) != null && Convert.ToString(reader.GetValue(1)) != "")
{
item.kehuxingming = reader.GetString(1);
}
if (reader.GetValue(2) != null && Convert.ToString(reader.GetValue(2)) != "")
{
item.shangcichugongshijian = Convert.ToString(reader.GetString(2));
}
if (reader.GetValue(3) != null && Convert.ToString(reader.GetValue(3)) != "")
{
item.shangcichugongbaojie = reader.GetString(3);
}
if (reader.GetValue(4) != null && Convert.ToString(reader.GetValue(4)) != "")
{
item.kehupingjia = reader.GetString(4);
}
if (reader.GetValue(5) != null && Convert.ToString(reader.GetValue(5)) != "")
{
item.beizhu = reader.GetString(5);
}
if (reader.GetValue(6) != null && Convert.ToString(reader.GetValue(6)) != "")
{
item.Input_Date = Convert.ToDateTime(reader.GetString(6));
}
ClaimReport_Server.Add(item);
}
return(ClaimReport_Server);
}
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 cls_kehucishufashengshijian_info;
cls_kehucishufashengshijian_info item = new cls_kehucishufashengshijian_info();
item.kehuxingming = Convert.ToString(dataGridView1.Rows[i].Cells["kehuxingming"].EditedFormattedValue.ToString());
item.shangcichugongshijian = Convert.ToString(dataGridView1.Rows[i].Cells["shangcichugongshijian"].EditedFormattedValue.ToString());
item.shangcichugongbaojie = Convert.ToString(dataGridView1.Rows[i].Cells["shangcichugongbaojie"].EditedFormattedValue.ToString());
item.kehupingjia = Convert.ToString(dataGridView1.Rows[i].Cells["kehupingjia"].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.status_id = model.status_id;
#endregion
#region MyRegion
#region 构造查询条件
string conditions = "";
conditions = sql_yuju(e, item, conditions);
#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);
}
