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