void gridViewOperation_AfterAdd(PJ_anqgjcrkd newobj)
{
if (isWorkflowCall)
{
WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns();
mrwt.ModleRecordID = newobj.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 = newobj.GetType().ToString();
mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
mrwt.CreatTime = DateTime.Now;
MainHelper.PlatformSqlMap.Create<WF_ModleRecordWorkTaskIns>(mrwt);
}
}
/// <summary>
/// 新建对象设置Key值
/// </summary>
/// <param name="newobj"></param>
void gridViewOperation_CreatingObjectEvent(PJ_anqgjcrkd newobj)
{
if (parentID == null) return;
newobj.OrgCode = parentID;
newobj.OrgName = parentObj.OrgName;
newobj.indate = DateTime.Now;
try { frmLP.ReadTaskData(newobj, RecordWorkFlowData, ParentTemple, CurrRecord); } catch { }
}
void gridViewOperation_AfterDelete(PJ_anqgjcrkd obj)
{
if (isWorkflowCall)
{
MainHelper.PlatformSqlMap.DeleteByWhere<WF_ModleRecordWorkTaskIns>(" where ModleRecordID='" + obj.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() + "'");
}
long i = 0;
PJ_anqgjcrkd pc = ClientHelper.PlatformSqlMap.GetOneByKey<PJ_anqgjcrkd>(obj.lyparent);
pc.kcsl = (Convert.ToDouble(pc.kcsl) + Convert.ToDouble(obj.cksl)).ToString();
ClientHelper.PlatformSqlMap.Update<PJ_anqgjcrkd>(pc);
//IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneInt",
// "select sum(cast(kcsl as float) ) from PJ_anqgjcrkd where (type = '安全工器具入库单' or type = '安全工器具入库单原始库存')"
// + " and wpmc='" + obj.wpmc + "' " + " and ssgc='" + obj.ssgc + "' "
// + " and wpgg='" + obj.wpgg + "' ");
//IList<PJ_anqgjcrkd> datalist = ClientHelper.PlatformSqlMap.GetListByWhere<PJ_anqgjcrkd>
// ("where (type = '所安全工器具出库单')"
// + " and wpmc='" + obj.wpmc + "' " + " and ssgc='" + obj.ssgc + "' "
// + " and wpgg='" + obj.wpgg + "' order by id desc ");
//if (datalist.Count > 0)
//{
// if (mclist[0] != null) i = Convert.ToInt64(mclist[0].ToString());
// datalist[0].zkcsl = i.ToString();
// ClientHelper.PlatformSqlMap.Update<PJ_anqgjcrkd>(datalist[0]);
//}
RefreshData(" where type = '所安全工器具出库单' ");
}
void gridViewOperation_AfterEdit(PJ_anqgjcrkd newobj)
{
}
private void barExplorYear_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
IList<PJ_anqgjcrkd> datalist = new List<PJ_anqgjcrkd>();
foreach (DataRow dr in gridtable.Rows)
{
PJ_anqgjcrkd pc = new PJ_anqgjcrkd();
foreach (DataColumn dc in gridtable.Columns)
{
if (dc.ColumnName.IndexOf("wpjz") < 0 && dc.ColumnName.IndexOf("xh") < 0 && dr[dc.ColumnName].ToString()!=string.Empty)
pc.GetType().GetProperty(dc.ColumnName).SetValue(pc, dr[dc.ColumnName], null);
}
datalist.Add(pc);
}
//frmProjectSelect fys = new frmProjectSelect();
//fys.strType = " and (type = '局安全工器具入库单' or type = '局安全工器具入库单原始库存') ";
//fys.StrSQL = "select distinct ssgc from PJ_anqgjcrkd where (type = '局安全工器具入库单' or type = '局安全工器具入库单原始库存') ";
//if (fys.ShowDialog() == DialogResult.OK)
//{
ExportAQGJTZEdit etdjh = new ExportAQGJTZEdit();
etdjh.ExportExcel(datalist);
//}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (comboBoxEdit3.Text == "0"||spinEdit2.Value==0 )
{
MsgBox.ShowTipMessageBox("物品无库存或出库数量为空！");
return;
}
this.DialogResult = DialogResult.OK;
rowData.zkcsl = spinEdit2.Properties.MaxValue.ToString();
if (returnData == null) returnData = new PJ_anqgjcrkd();
ConvertHelper.CopyTo<PJ_anqgjcrkd>(rowData, returnData);
}
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();
}
}
void gridViewOperation_AfterDelete(PJ_anqgjcrkd obj)
{
if (isWorkflowCall)
{
MainHelper.PlatformSqlMap.DeleteByWhere<WF_ModleRecordWorkTaskIns>(" where ModleRecordID='" + obj.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() + "'");
}
RefreshData(" where OrgCode='" + parentID + "' ");
}
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);
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (returnData == null) returnData = new PJ_anqgjcrkd();
ConvertHelper.CopyTo<PJ_anqgjcrkd>(rowData, returnData);
}
private void btAddKuCun_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
PJ_anqgjcrkd cl = new PJ_anqgjcrkd();
bool isadd = false;
cl = gridView1.GetFocusedRow() as PJ_anqgjcrkd;
if (cl == null || cl.type != "局安全工器具入库单原始库存")
{
cl = new PJ_anqgjcrkd();
//cl.OrgCode = parentObj.OrgCode;
//cl.OrgName = parentObj.OrgName;
cl.type = "局安全工器具入库单原始库存";
cl.Remark = "局安全工器具入库单原始库存";
isadd = true;
}
if (cl.type == "局安全工器具入库单原始库存")
{
frmAQGJRKEdit frm = new frmAQGJRKEdit();
frm.RowData = cl;
if (frm.ShowDialog() == DialogResult.OK)
{
if (isadd)
{
MainHelper.PlatformSqlMap.Create<PJ_anqgjcrkd>(cl);
}
else
{
MainHelper.PlatformSqlMap.Update<PJ_anqgjcrkd>(cl);
}
RefreshData(" where (type = '局安全工器具入库单' or type = '局安全工器具入库单原始库存') ");
}
}
else
return;
}
void gridViewOperation_AfterDelete(PJ_anqgjcrkd obj)
{
if (isWorkflowCall)
{
MainHelper.PlatformSqlMap.DeleteByWhere<WF_ModleRecordWorkTaskIns>(" where ModleRecordID='" + obj.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() + "'");
}
long i = 0;
System.Collections.IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneInt",
"select sum(cast(kcsl as float) ) from PJ_anqgjcrkd where (type = '局安全工器具入库单' or type = '局安全工器具入库单原始库存')"
+ " and wpmc='" + obj.wpmc + "' "
+ " and wpgg='" + obj.wpgg + "' and id!='" + obj.ID + "' ");
IList<PJ_anqgjcrkd> datalist = ClientHelper.PlatformSqlMap.GetListByWhere<PJ_anqgjcrkd>
("where (type = '局安全工器具入库单' or type = '局安全工器具入库单原始库存')"
+ " and wpmc='" + obj.wpmc + "' "
+ " and wpgg='" + obj.wpgg + "' and id!='" + obj.ID + "' order by id desc ");
if (datalist.Count > 0)
{
if (mclist[0] != null) i = Convert.ToInt64(mclist[0].ToString());
datalist[0].zkcsl = i.ToString();
ClientHelper.PlatformSqlMap.Update<PJ_anqgjcrkd>(datalist[0]);
}
RefreshData(" where OrgCode='" + parentID + "' and (type = '局安全工器具入库单' or type = '局安全工器具入库单原始库存') ");
}
void gridViewOperation_AfterEdit(PJ_anqgjcrkd obj)
{
RefreshData(" where (type = '局安全工器具入库单' or type = '局安全工器具入库单原始库存') ");
}