private void gridView1_DoubleClick(object sender, EventArgs e)
{
if (gridView1.FocusedRowHandle < -1)
return;
PJ_anqgjcrkd rowdata = gridView1.GetFocusedRow() as PJ_anqgjcrkd;
rowdata = ClientHelper.PlatformSqlMap.GetOneByKey<PJ_anqgjcrkd>(rowdata.ID);
frmAQGJSCKSingleXZ frm = new frmAQGJSCKSingleXZ();
frm.RowData = new PJ_anqgjcrkd();
ConvertHelper.CopyTo<PJ_anqgjcrkd>(rowdata, (PJ_anqgjcrkd)frm.RowData);
((PJ_anqgjcrkd)frm.RowData).Remark = "";
IList<PJ_anqgjcrkd> pnumli = Client.ClientHelper.PlatformSqlMap.GetListByWhere
<PJ_anqgjcrkd>(" where id like '" + DateTime.Now.ToString("yyyyMMdd") + "%' and type='" + comboBoxEdit6.Text + "' order by id desc ");
if (pnumli.Count == 0)
((PJ_anqgjcrkd)frm.RowData).num = "SAQGJCK" + DateTime.Now.ToString("yyyyMMdd") + string.Format("{0:D4}", 1);
else
{
((PJ_anqgjcrkd)frm.RowData).num = "SAQGJCK" + (Convert.ToDecimal(pnumli[0].num.Replace("SAQGJCK", "")) + 1);
}
((PJ_anqgjcrkd)frm.RowData).ckdate = DateTime.Now;
double i = 0;
if (frm.ShowDialog() == DialogResult.OK)
{
PJ_anqgjcrkd ckd = new PJ_anqgjcrkd();
ConvertHelper.CopyTo<PJ_anqgjcrkd>(rowdata, ckd);
ckd.ID = ckd.CreateID();
System.Collections.IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneInt",
"select sum(cast(kcsl as float) ) from PJ_anqgjcrkd where (type = '所安全工器具入库单' or type = '所安全工器具入库单原始库存' and orgname='" + ckd.OrgName + "')"
+ " and wpmc='" + rowdata.wpmc + "' "
+ " and wpgg='" + rowdata.wpgg + "' ");
if (mclist[0] != null) i = Convert.ToDouble(mclist[0].ToString());
double cktemp = Convert.ToDouble(frm.ReturnData.cksl);
double zkc = Convert.ToDouble(i);
// i = Client.ClientHelper.PlatformSqlMap.GetRowCount
//<PJ_anqgjcrkd>(" where id like '" + DateTime.Now.ToString("yyyyMMdd") + "%' and type='" + comboBoxEdit6.Text + "' ");
ckd.num = frm.ReturnData.num;
ckd.type = comboBoxEdit6.Text;
ckd.Remark = frm.ReturnData.Remark;
ckd.OrgName = frm.ReturnData.OrgName;
ckd.OrgCode = frm.ReturnData.OrgCode;
ckd.lqdw = frm.ReturnData.lqdw;
ckd.ckdate = DateTime.Now;
ckd.lasttime = DateTime.Now;
if (cktemp >= Convert.ToDouble(rowdata.kcsl))
{
ckd.cksl = rowdata.kcsl;
ckd.zkcsl = (zkc - Convert.ToDouble(rowdata.kcsl)).ToString();
cktemp = cktemp - Convert.ToDouble(rowdata.kcsl);
ckd.kcsl = "0";
rowdata.kcsl = "0";
ClientHelper.PlatformSqlMap.Update<PJ_anqgjcrkd>(rowdata);
}
else
{
ckd.cksl = cktemp.ToString();
ckd.zkcsl = (zkc - cktemp).ToString();
rowdata.kcsl = (Convert.ToDouble(rowdata.kcsl) - cktemp).ToString();
ckd.kcsl = rowdata.kcsl;
cktemp = 0;
ClientHelper.PlatformSqlMap.Update<PJ_anqgjcrkd>(rowdata);
}
ckd.lyparent = rowdata.ID;
zkc = Convert.ToDouble(ckd.zkcsl);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
if (isWorkflowCall)
{
MainHelper.PlatformSqlMap.DeleteByWhere<WF_ModleRecordWorkTaskIns>(" where ModleRecordID='" + ckd.ID + "' and RecordID='" + currRecord.ID + "'"
+ " and WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "'"
+ " and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "'"
+ " and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'"
+ " and WorkTaskInsId='" + WorkFlowData.Rows[0]["WorkTaskInsId"].ToString() + "'");
}
ClientHelper.PlatformSqlMap.Create<PJ_anqgjcrkd>(ckd);
if (isWorkflowCall)
{
WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns();
mrwt.ModleRecordID = ckd.ID;
mrwt.RecordID = currRecord.ID;
mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
mrwt.ModleTableName = ckd.GetType().ToString();
mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
mrwt.CreatTime = DateTime.Now;
MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt);
}
ucclck1.inidata();
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
frmAQGJSCKXZ frm = new frmAQGJSCKXZ();
frm.strType = comboBoxEdit5.Text;
if (clccktemp == null) clccktemp = new PJ_anqgjcrkd();
//int i = Client.ClientHelper.PlatformSqlMap.GetRowCount
// <PJ_anqgjcrkd>(" where id like '" + DateTime.Now.ToString("yyyyMMdd") + "%' and type='" + comboBoxEdit6.Text + "' order by id desc ");
//frm.strNum = DateTime.Now.ToString("yyyyMMdd") + string.Format("{0:D4}", i + 1);
IList<PJ_anqgjcrkd> pnumli = Client.ClientHelper.PlatformSqlMap.GetListByWhere
<PJ_anqgjcrkd>(" where id like '" + DateTime.Now.ToString("yyyyMMdd") + "%' and type='" + comboBoxEdit6.Text + "' order by id desc ");
if (clccktemp.num == "")
{
if (pnumli.Count == 0)
clccktemp.num = "SAQGJCK" + DateTime.Now.ToString("yyyyMMdd") + string.Format("{0:D4}", 1);
else
{
clccktemp.num = "SAQGJCK" + (Convert.ToDecimal(pnumli[0].num.Replace("SAQGJCK", "")) + 1);
}
}
else
{
if (pnumli.Count > 0)
{
if ((Convert.ToDecimal(clccktemp.num.Replace("SAQGJCK", ""))) - (Convert.ToDecimal(pnumli[0].num.Replace("SAQGJCK", ""))) > 1)
{
clccktemp.num = "SAQGJCK" + (Convert.ToDecimal(pnumli[0].num.Replace("SAQGJCK", "") + 1));
}
}
}
frm.strNum = clccktemp.num;
//frm.RowData = new PJ_anqgjcrkd();
frm.RowData = clccktemp;
((PJ_anqgjcrkd)frm.RowData).ckdate = DateTime.Now;
((PJ_anqgjcrkd)frm.RowData).OrgName = comboBoxEdit1.Text;
mOrg org = ClientHelper.PlatformSqlMap.GetOne<mOrg>(" where orgname = '" + comboBoxEdit1.Text + "' ");
if (org != null)
{
((PJ_anqgjcrkd)frm.RowData).OrgCode = org.OrgCode;
}
if (frm.ShowDialog() == DialogResult.OK)
{
string ssgc = " and 1=1 ", wpgg = " and 1=1 ", wpmc = " and 1=1 ";
double isum = 0;
wpmc = " and wpmc='" + frm.ReturnData.wpmc + "' ";
wpgg = " and wpgg='" + frm.ReturnData.wpgg + "' ";
isum =Convert.ToDouble( frm.ReturnData.cksl);
string strsql = " where (type = '" + comboBoxEdit5.Text
+ "' or type = '" + comboBoxEdit5.Text + "原始库存') "
+ ssgc + wpmc + wpgg + " and cast(kcsl as float)>0 order by cast( indate as datetime) ";
IList<PJ_anqgjcrkd> datalist = ClientHelper.PlatformSqlMap.GetListByWhere<PJ_anqgjcrkd>
(strsql);
double cktemp = isum;
double zkc = Convert.ToDouble(frm.ReturnData.zkcsl);
double szkc = 0;
IList<PJ_anqgjcrkd> ckdatalist = new List<PJ_anqgjcrkd>();
decimal num = 0;
pnumli = Client.ClientHelper.PlatformSqlMap.GetListByWhere
<PJ_anqgjcrkd>(" where id like '" + DateTime.Now.ToString("yyyyMMdd") + "%' and type='" + comboBoxEdit6.Text + "' order by id desc ");
if (pnumli.Count == 0)
num = Convert.ToDecimal(DateTime.Now.ToString("yyyyMMdd") + string.Format("{0:D4}", 0));
else
{
num = (Convert.ToDecimal(pnumli[0].num.Replace("SAQGJCK", "")));
}
foreach (PJ_anqgjcrkd pc in datalist)
{
PJ_anqgjcrkd ckd =new PJ_anqgjcrkd() ;
ConvertHelper.CopyTo<PJ_anqgjcrkd>(pc, ckd);
ckd.ID = ckd.CreateID();
//int i = Client.ClientHelper.PlatformSqlMap.GetRowCount
// <PJ_anqgjcrkd>(" where id like '" + DateTime.Now.ToString("yyyyMMdd") + "%' and type='" + comboBoxEdit6.Text + "' order by id desc ");
//frm.strNum = DateTime.Now.ToString("yyyyMMdd") + string.Format("{0:D4}", i + 1);
//ckd.num = "SAQGJCK" + (num + 1);
ckd.num = clccktemp.num;
ckd.type = comboBoxEdit6.Text;
ckd.Remark = frm.ReturnData.Remark;
ckd.OrgName = frm.ReturnData.OrgName;
ckd.OrgCode = frm.ReturnData.OrgCode;
ckd.ckdate = DateTime.Now;
ckd.lqdw = frm.ReturnData.lqdw;
if (cktemp >= Convert.ToDouble(pc.kcsl))
{
ckd.cksl = pc.kcsl;
ckd.zkcsl = (zkc - Convert.ToDouble(pc.kcsl)).ToString();
cktemp = cktemp - Convert.ToDouble(pc.kcsl);
pc.kcsl = "0";
//ClientHelper.PlatformSqlMap.Update<PJ_anqgjcrkd>(pc);
}
else
{
ckd.cksl = cktemp.ToString();
ckd.zkcsl = (zkc - cktemp).ToString();
pc.kcsl = (Convert.ToDouble(pc.kcsl) - cktemp).ToString();
cktemp = 0;
//ClientHelper.PlatformSqlMap.Update<PJ_anqgjcrkd>(pc);
}
ckd.lyparent = pc.ID;
zkc = Convert.ToDouble(ckd.zkcsl);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
//ClientHelper.PlatformSqlMap.Create<PJ_anqgjcrkd>(ckd);
ckdatalist.Add(ckd);
if (cktemp<1) break;
//num=(num + 1);
}
frmAQGJSCKXZShow frmshow = new frmAQGJSCKXZShow();
frmshow.DataList = ckdatalist;
if (frmshow.ShowDialog() == DialogResult.OK)
{
cktemp = isum;
zkc = Convert.ToDouble(frm.ReturnData.zkcsl);
pnumli = Client.ClientHelper.PlatformSqlMap.GetListByWhere
<PJ_anqgjcrkd>(" where id like '" + DateTime.Now.ToString("yyyyMMdd") + "%' and type='" + comboBoxEdit6.Text + "' ");
if (pnumli.Count == 0)
num = Convert.ToDecimal(DateTime.Now.ToString("yyyyMMdd") + string.Format("{0:D4}", 0));
else
{
num = (Convert.ToDecimal(pnumli[0].num.Replace("SAQGJCK", "")) );
}
datalist = ClientHelper.PlatformSqlMap.GetListByWhere<PJ_anqgjcrkd>
(strsql);
foreach (PJ_anqgjcrkd pc in datalist)
{
PJ_anqgjcrkd ckd = new PJ_anqgjcrkd();
ConvertHelper.CopyTo<PJ_anqgjcrkd>(pc, ckd);
ckd.ID = ckd.CreateID();
//ckd.num = "SAQGJCK" + (num + 1);
ckd.num = clccktemp.num;
ckd.type = comboBoxEdit6.Text;
ckd.Remark = frm.ReturnData.Remark;
ckd.OrgName = frm.ReturnData.OrgName;
ckd.OrgCode = frm.ReturnData.OrgCode;
ckd.lqdw = frm.ReturnData.lqdw;
ckd.ckdate = DateTime.Now;
ckd.lasttime = DateTime.Now;
if (cktemp >= Convert.ToDouble(pc.kcsl))
{
ckd.cksl = pc.kcsl;
ckd.zkcsl = (zkc - Convert.ToDouble(pc.kcsl)).ToString();
cktemp = cktemp - Convert.ToDouble(pc.kcsl);
pc.kcsl = "0";
ClientHelper.PlatformSqlMap.Update<PJ_anqgjcrkd>(pc);
}
else
{
ckd.cksl = cktemp.ToString();
ckd.zkcsl = (zkc - cktemp).ToString();
pc.kcsl = (Convert.ToDouble(pc.kcsl) - cktemp).ToString();
cktemp = 0;
ClientHelper.PlatformSqlMap.Update<PJ_anqgjcrkd>(pc);
}
ckd.lyparent = pc.ID;
zkc = Convert.ToDouble(ckd.zkcsl);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
if (isWorkflowCall)
{
MainHelper.PlatformSqlMap.DeleteByWhere<WF_ModleRecordWorkTaskIns>(" where ModleRecordID='" + ckd.ID + "' and RecordID='" + currRecord.ID + "'"
+ " and WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "'"
+ " and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "'"
+ " and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'"
+ " and WorkTaskInsId='" + WorkFlowData.Rows[0]["WorkTaskInsId"].ToString() + "'");
}
ClientHelper.PlatformSqlMap.Create<PJ_anqgjcrkd>(ckd);
if (isWorkflowCall)
{
WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns();
mrwt.ModleRecordID = ckd.ID;
mrwt.RecordID = currRecord.ID;
mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
mrwt.ModleTableName = ckd.GetType().ToString();
mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
mrwt.CreatTime = DateTime.Now;
MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt);
}
if (cktemp < 1) break;
//num = (num + 1);
}
ucclck1.inidata();
simpleButton1_Click(sender, e);
}
}
}