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