void gridViewOperation_AfterDelete(PJ_wgclcrkd 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_wgclcrkd pc = ClientHelper.PlatformSqlMap.GetOneByKey<PJ_wgclcrkd>(obj.lyparent); pc.kcsl = (Convert.ToDouble(pc.kcsl) + Convert.ToDouble(obj.cksl)).ToString(); ClientHelper.PlatformSqlMap.Update<PJ_wgclcrkd>(pc); //IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneInt", // "select sum(cast(kcsl as float) ) from PJ_wgclcrkd where (type = '工程材料入库单' or type = '工程材料入库单原始库存')" // + " and wpmc='" + obj.wpmc + "' " + " and ssgc='" + obj.ssgc + "' " // + " and wpgg='" + obj.wpgg + "' "); //IList<PJ_wgclcrkd> datalist = ClientHelper.PlatformSqlMap.GetListByWhere<PJ_wgclcrkd> // ("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_wgclcrkd>(datalist[0]); //} RefreshData(" where type = '工程材料出库单' "); }
void gridViewOperation_AfterEdit(PJ_wgclcrkd newobj) { }
private void gridView1_DoubleClick(object sender, EventArgs e) { if (gridView1.FocusedRowHandle < -1) return; PJ_wgclcrkd rowdata = gridView1.GetFocusedRow() as PJ_wgclcrkd; rowdata = ClientHelper.PlatformSqlMap.GetOneByKey<PJ_wgclcrkd>(rowdata.ID); frmWGCJGCCLDSingleXZ frm = new frmWGCJGCCLDSingleXZ(); frm.RowData = new PJ_wgclcrkd(); ConvertHelper.CopyTo<PJ_wgclcrkd>(rowdata, (PJ_wgclcrkd)frm.RowData); ((PJ_wgclcrkd)frm.RowData).Remark = ""; ((PJ_wgclcrkd)frm.RowData).yt = "工程"; IList<PJ_wgclcrkd> pnumli = Client.ClientHelper.PlatformSqlMap.GetListByWhere <PJ_wgclcrkd>(" where id like '" + DateTime.Now.ToString("yyyyMMdd") + "%' and type='" + comboBoxEdit6.Text + "' order by id desc "); if (pnumli.Count == 0) ((PJ_wgclcrkd)frm.RowData).num = "CJCLDCK" + DateTime.Now.ToString("yyyyMMdd") + string.Format("{0:D4}", 1); else { ((PJ_wgclcrkd)frm.RowData).num = "CJCLDCK" + (Convert.ToDecimal(pnumli[0].num.Replace("CJCLDCK","")) + 1); } ((PJ_wgclcrkd)frm.RowData).ckdate = DateTime.Now; double i = 0; if (frm.ShowDialog() == DialogResult.OK) { PJ_wgclcrkd ckd = new PJ_wgclcrkd(); ConvertHelper.CopyTo<PJ_wgclcrkd>(rowdata, ckd); ckd.ID = ckd.CreateID(); System.Collections.IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneInt", "select sum(cast(kcsl as float) ) from PJ_wgclcrkd where (type = '撤旧材料入库单' or type = '撤旧材料入库单原始库存')" + " and wpmc='" + rowdata.wpmc + "' " + " and ssgc='" + rowdata.ssgc + "' " + " 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_wgclcrkd>(" 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.yt = frm.ReturnData.yt; ckd.ssxm = frm.ReturnData.ssxm; ckd.lqdw = frm.ReturnData.lqdw; ckd.ghdw = frm.ReturnData.ghdw; ckd.ckdate = frm.ReturnData.ckdate; 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_wgclcrkd>(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_wgclcrkd>(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_wgclcrkd>(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); } ucgccld1.inidata(); } }
private void btnOK_Click(object sender, EventArgs e) { if (returnData == null) returnData = new PJ_wgclcrkd(); ConvertHelper.CopyTo<PJ_wgclcrkd>(rowData, returnData); }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(PJ_wgclcrkd newobj) { }
private void simpleButton1_Click(object sender, EventArgs e) { frmWGCJCLCKXZ frm = new frmWGCJCLCKXZ(); frm.strType = comboBoxEdit5.Text; if (clccktemp == null) clccktemp = new PJ_wgclcrkd(); clccktemp.cksl = "0"; clccktemp.yt = "工程"; clccktemp.wpgg = ""; //int i = Client.ClientHelper.PlatformSqlMap.GetRowCount // <PJ_wgclcrkd>(" 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_wgclcrkd> pnumli = Client.ClientHelper.PlatformSqlMap.GetListByWhere <PJ_wgclcrkd>(" where id like '" + DateTime.Now.ToString("yyyyMMdd") + "%' and type='" + comboBoxEdit6.Text + "' order by id desc "); if (clccktemp.num == "") { if (pnumli.Count == 0) clccktemp.num = "CJCLDCK" + DateTime.Now.ToString("yyyyMMdd") + string.Format("{0:D4}", 1); else { clccktemp.num = "CJCLDCK" + (Convert.ToDecimal(pnumli[0].num.Replace("CJCLDCK", "")) + 1); } } else { if (pnumli.Count > 0) { if ((Convert.ToDecimal(clccktemp.num.Replace("CJCLDCK", ""))) - (Convert.ToDecimal(pnumli[0].num.Replace("CJCLDCK", ""))) > 1) { clccktemp.num = "CJCLDCK" + (Convert.ToDecimal(pnumli[0].num.Replace("CJCLDCK", "") + 1)); } } } frm.strNum = clccktemp.num; frm.RowData = new PJ_wgclcrkd(); ((PJ_wgclcrkd)frm.RowData).ckdate = DateTime.Now; if (frm.ShowDialog() == DialogResult.OK) { string ssgc = " and 1=1 ", wpgg = " and 1=1 ", wpmc = " and 1=1 "; double isum = 0; ssgc = " and ssgc='" + frm.ReturnData.ssgc + "' "; 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_wgclcrkd> datalist = ClientHelper.PlatformSqlMap.GetListByWhere<PJ_wgclcrkd> (strsql); double cktemp = isum; double zkc = Convert.ToDouble(frm.ReturnData.zkcsl); IList<PJ_wgclcrkd> ckdatalist = new List<PJ_wgclcrkd>(); decimal num = 0; pnumli = Client.ClientHelper.PlatformSqlMap.GetListByWhere <PJ_wgclcrkd>(" 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("CJCLDCK", ""))); } foreach (PJ_wgclcrkd pc in datalist) { PJ_wgclcrkd ckd = new PJ_wgclcrkd(); ConvertHelper.CopyTo<PJ_wgclcrkd>(pc, ckd); ckd.ID = ckd.CreateID(); //int i = Client.ClientHelper.PlatformSqlMap.GetRowCount // <PJ_wgclcrkd>(" 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 = "CJCLDCK" + (num + 1); ckd.num = clccktemp.num; ckd.type = comboBoxEdit6.Text; ckd.Remark = frm.ReturnData.Remark; ckd.yt = frm.ReturnData.yt; ckd.ssxm = pc.ssxm; ckd.lqdw = frm.ReturnData.lqdw; ckd.ghdw= frm.ReturnData.ghdw; ckd.ckdate = frm.ReturnData.ckdate; 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_wgclcrkd>(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_wgclcrkd>(pc); } ckd.lyparent = pc.ID; zkc = Convert.ToDouble(ckd.zkcsl); Thread.Sleep(new TimeSpan(100000));//0.1毫秒 //ClientHelper.PlatformSqlMap.Create<PJ_wgclcrkd>(CLDCKd); ckdatalist.Add(ckd); if (cktemp<1) break; //num=(num + 1); } frmWGCJGCCLDShow frmshow = new frmWGCJGCCLDShow(); frmshow.DataList = ckdatalist; if (frmshow.ShowDialog() == DialogResult.OK) { cktemp = isum; zkc = Convert.ToDouble(frm.ReturnData.zkcsl); pnumli = Client.ClientHelper.PlatformSqlMap.GetListByWhere <PJ_wgclcrkd>(" 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("CJCLDCK", ""))); } datalist = ClientHelper.PlatformSqlMap.GetListByWhere<PJ_wgclcrkd> (strsql); foreach (PJ_wgclcrkd pc in datalist) { PJ_wgclcrkd ckd = new PJ_wgclcrkd(); ConvertHelper.CopyTo<PJ_wgclcrkd>(pc, ckd); ckd.ID = ckd.CreateID(); //ckd.num = "CJCLDCK" + (num + 1); ckd.num = clccktemp.num; ckd.type = comboBoxEdit6.Text; ckd.Remark = frm.ReturnData.Remark; ckd.lqdw = frm.ReturnData.lqdw; ckd.ghdw = frm.ReturnData.ghdw; ckd.yt = frm.ReturnData.yt; ckd.ssxm = frm.ReturnData.ssxm; ckd.ckdate = frm.ReturnData.ckdate; 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_wgclcrkd>(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_wgclcrkd>(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_wgclcrkd>(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); } ucgccld1.inidata(); simpleButton1_Click(sender, e); } } }
private void btAddKuCun_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { PJ_wgclcrkd cl = new PJ_wgclcrkd(); bool isadd = false; cl = gridView1.GetFocusedRow() as PJ_wgclcrkd; if (cl == null || cl.type != "工程材料入库单原始库存") { cl = new PJ_wgclcrkd(); //cl.OrgCode = parentObj.OrgCode; //cl.OrgName = parentObj.OrgName; cl.type = "工程材料入库单原始库存"; cl.Remark = "工程材料入库单原始库存"; isadd = true; } if (cl.type == "工程材料入库单原始库存") { frmWGCLRKEdit frm = new frmWGCLRKEdit(); frm.RowData = cl; if (frm.ShowDialog() == DialogResult.OK) { if (isadd) { MainHelper.PlatformSqlMap.Create<PJ_wgclcrkd>(cl); } else { MainHelper.PlatformSqlMap.Update<PJ_wgclcrkd>(cl); } RefreshData(" where (type = '工程材料入库单' or type = '工程材料入库单原始库存') "); } } else return; }
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_wgclcrkd(); ConvertHelper.CopyTo<PJ_wgclcrkd>(rowData, returnData); }
void gridViewOperation_AfterEdit(PJ_wgclcrkd obj) { RefreshData(" where (type = '工程材料入库单' or type = '工程材料入库单原始库存') "); }
void gridViewOperation_AfterDelete(PJ_wgclcrkd 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_wgclcrkd where (type = '工程材料入库单' or type = '工程材料入库单原始库存')" + " and wpmc='" + obj.wpmc + "' " + " and ssgc='" + obj.ssgc + "' " + " and wpgg='" + obj.wpgg + "' and id!='" + obj.ID + "' "); IList<PJ_wgclcrkd> datalist = ClientHelper.PlatformSqlMap.GetListByWhere<PJ_wgclcrkd> ("where (type = '工程材料入库单' or type = '工程材料入库单原始库存')" + " and wpmc='" + obj.wpmc + "' " + " and ssgc='" + obj.ssgc + "' " + " 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_wgclcrkd>(datalist[0]); } RefreshData(" where OrgCode='" + parentID + "' and (type = '工程材料入库单' or type = '工程材料入库单原始库存') "); }
private void barExplorYear_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (gridtable == null) return; IList<PJ_wgclcrkd> datalist = new List<PJ_wgclcrkd>(); foreach (DataRow dr in gridtable.Rows) { PJ_wgclcrkd pc = new PJ_wgclcrkd(); 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); } //fys.strType = " and (type = '工程材料入库单' or type = '工程材料入库单原始库存') "; //fys.StrSQL = "select distinct ssgc from PJ_wgclcrkd where (type = '工程材料入库单' or type = '工程材料入库单原始库存') "; //if (fys.ShowDialog() == DialogResult.OK) //{ ExportWGSCTZEdit etdjh = new ExportWGSCTZEdit(); etdjh.ExportExcel(datalist); //} }
private void btView_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //IList<PJ_wgclcrkd> datalist = gridView1.DataSource as IList<PJ_wgclcrkd>; if (gridtable == null) return; IList<PJ_wgclcrkd> datalist = new List<PJ_wgclcrkd>(); foreach (DataRow dr in gridtable.Rows) { PJ_wgclcrkd pc = new PJ_wgclcrkd(); foreach (DataColumn dc in gridtable.Columns) { if (dc.DataType.FullName.IndexOf("wpjz") < 0) 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_wgclcrkd where (type = '工程材料入库单' or type = '工程材料入库单原始库存') "; //if (fys.ShowDialog() == DialogResult.OK) //{ ExportWGSCTZEdit etdjh = new ExportWGSCTZEdit(); etdjh.ExportExcel(datalist); //} }
void gridViewOperation_AfterDelete(PJ_wgclcrkd 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 + "' "); }
void gridViewOperation_AfterAdd(PJ_wgclcrkd 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); } }
void gridViewOperation_AfterAdd(PJ_wgclcrkd obj) { }
/// <summary> /// 新建对象设置Key值 /// </summary> /// <param name="newobj"></param> void gridViewOperation_CreatingObjectEvent(PJ_wgclcrkd newobj) { if (parentID == null) return; newobj.OrgCode = parentID; newobj.OrgName = parentObj.OrgName; newobj.indate = DateTime.Now; try { frmLP.ReadTaskData(newobj, RecordWorkFlowData, ParentTemple, CurrRecord); } catch { } }
private void barCopy_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { frmNumSelect fys = new frmNumSelect(); fys.strType = " and 1=1"; fys.StrSQL = "select distinct dhht from PJ_wgclrkysd where 1=1 and dhht!=''"; if (fys.ShowDialog() == DialogResult.OK) { string filter = " where 1=1"; if(fys.strNum!="全部") filter = " where dhht='" + fys.strNum + "'"; IList<PJ_wgclrkysd> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_wgclrkysd>( filter ); IList<PJ_wgclcrkd> cdatalist = new List<PJ_wgclcrkd>(); string num = ""; IList<PJ_wgclcrkd> pnumli = Client.ClientHelper.PlatformSqlMap.GetListByWhere <PJ_wgclcrkd>(" where id like '" + DateTime.Now.ToString("yyyyMMdd") + "%' and type='工程材料入库单' order by id desc "); if (pnumli.Count == 0) num = "SCRK" + DateTime.Now.ToString("yyyyMMdd") + string.Format("{0:D4}", 1); else { num = "SCRK" + (Convert.ToDecimal(pnumli[0].num.Replace("SCRK", "")) + 1); } PJ_wgclcrkd lc = null; foreach (PJ_wgclrkysd ysd in datalist) { lc = MainHelper.PlatformSqlMap.GetOne<PJ_wgclcrkd>(" where lyparent='"+ysd.ID +"' and type = '工程材料入库单'"); if (lc == null) { PJ_wgclcrkd clc = new PJ_wgclcrkd(); clc.ID = clc.CreateID(); clc.ssgc = ysd.ssgc; clc.ssxm = ysd.ssxm; clc.type = "工程材料入库单"; clc.num = num; clc.wpmc = ysd.wpmc; clc.wpgg = ysd.wpgg; clc.wpdw = ysd.wpdw; clc.wpdj = ysd.wpdj; clc.wpcj = ysd.ghdw; clc.wpsl = ysd.wpsl; clc.kcsl = ysd.wpsl; clc.indate = ysd.indate; clc.lyparent = ysd.ID; cdatalist.Add(clc); Thread.Sleep(new TimeSpan(100000));//0.1毫秒 } } frmWGCLRKYSShow fss = new frmWGCLRKYSShow(); fss.DataList = cdatalist; if (fss.ShowDialog() == DialogResult.OK) { foreach (PJ_wgclcrkd clc in cdatalist) { double i = 0; System.Collections.IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneInt", "select sum(cast(kcsl as float) ) from PJ_wgclcrkd where (type = '工程材料入库单' or type = '工程材料入库单原始库存')" + " and wpmc='" + clc.wpmc + "' " + " and ssgc='" + clc.ssgc + "' " + " and wpgg='" + clc.wpgg + "' and id!='" + clc.ID + "' "); if (mclist[0] != null) i = Convert.ToDouble(mclist[0].ToString()); clc.zkcsl = (Convert.ToDouble(clc.kcsl) + i).ToString(); Client.ClientHelper.PlatformSqlMap.Create<PJ_wgclcrkd>(clc); } MsgBox.ShowTipMessageBox("导入成功!"); } } }