protected void ASPxGridView1_PageIndexChanged(object sender, EventArgs e)
{
SetCondition();
ASPxGridView1.DataBind();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
// ASPxTextBox uPSo = ASPxGridView1.FindEditFormTemplateControl("txtPSo") as ASPxTextBox;
ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uMCode = ASPxGridView1.FindEditFormTemplateControl("txtMCode") as ASPxTextBox;
ASPxTextBox uMName = ASPxGridView1.FindEditFormTemplateControl("txtMName") as ASPxTextBox;
ASPxTextBox uGCode = ASPxGridView1.FindEditFormTemplateControl("txtGCode") as ASPxTextBox;
ASPxTextBox uGName = ASPxGridView1.FindEditFormTemplateControl("txtGName") as ASPxTextBox;
ASPxComboBox uHcFLAG = ASPxGridView1.FindEditFormTemplateControl("txtHcFLAG") as ASPxComboBox;
ASPxComboBox uQSite = ASPxGridView1.FindEditFormTemplateControl("txtQSite") as ASPxComboBox;
ASPxTextBox uMNum = ASPxGridView1.FindEditFormTemplateControl("txtMNum") as ASPxTextBox;
ASPxTextBox uRemark = ASPxGridView1.FindEditFormTemplateControl("txtRemark") as ASPxTextBox;
ASPxComboBox uPackFlag = ASPxGridView1.FindEditFormTemplateControl("txtPackFlag") as ASPxComboBox;
ASPxComboBox uLqFlag = ASPxGridView1.FindEditFormTemplateControl("txtLqFlag") as ASPxComboBox;
ASPxComboBox uTName = ASPxGridView1.FindEditFormTemplateControl("txtTName") as ASPxComboBox;
ASPxDateEdit uOnTime = ASPxGridView1.FindEditFormTemplateControl("txtOnTime") as ASPxDateEdit;
string strHcFLAG = uHcFLAG.Value.ToString();
string strPCode = uPCode.Value.ToString();
string strPackFlag = uPackFlag.Value.ToString();
string strQSite = uQSite.Value.ToString();
string strLqFlag = uLqFlag.Value.ToString();
string strTName = uTName.Value.ToString();
string strMCode = uMCode.Text.Trim();
string strMName = uMName.Text.Trim();
string strGName = uGName.Text.Trim();
string strGCode = uGCode.Text.Trim();
string strMNum = uMNum.Text.Trim();
string strRemark = uRemark.Text.Trim();
string strLCode = "";
if (strPCode == "E")
{
strLCode = "ZS5";
}
if (strPCode == "W")
{
strLCode = "F010";
}
if (strPCode == "Z")
{
strLCode = "XA100";
}
if (strLqFlag == "Y")
{
strLCode = "LQ8010";
}
//if (strHcFLAG == "Y")
//{
// Response.Write("<script>alert('该物料将冲抵回冲池！！是否继续？')</script>");
//}
//if (strHcFLAG == "N")
//{
// Response.Write("<script>alert('不进行冲抵，是否继续？')</script>");
//}
string Sql = "insert into ms_single_mat(material_code,material_num,online_time,add_time,flag,gzdd,gys_code,add_yhdm,type_name,qadsite,location_code,HC_FLAG,BILL_REMARK)"
+ "VALUES('" + strMCode + "','" + strMNum + "',to_date('" + uOnTime.Value + "','yyyy-mm-dd hh24:mi:ss'),sysdate ,'N','" + strPCode + "','" + strGCode + "','" + theUserCode + "',"
+ "'" + strTName + "','" + strQSite + "','" + strLCode + "','" + strHcFLAG + "','" + strRemark + "')";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxGridView1.DataSource = GetData(-1);
ASPxGridView1.DataBind();
ASPxGridView1.Templates.DetailRow = new MyDetailTemplate();
}
protected void Page_Init(object sender, EventArgs e)
{
ASPxGridView1.DataSource = Data;
ASPxGridView1.DataBind();
}
protected void tabela_1()
{
string idDzialu = (string)Session["id_dzialu"];
string idTabeli = "5";
if (cl.debug(int.Parse(idDzialu)))
{
cm.log.Info(tenPlik + ": rozpoczęcie tworzenia tabeli 1");
}
DataTable tabelka01 = DevExpressXXL.zLicznikiemKolumn(dr.konwertujNaPrzecinek(dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse(idDzialu), 5, Date1.Date, Date2.Date, 114, tenPlik)));
Session["tabelka001"] = tabelka01;
ASPxGridView1.DataSource = null;
ASPxGridView1.DataSourceID = null;
ASPxGridView1.AutoGenerateColumns = true;
ASPxGridView1.DataSource = tabelka01;
ASPxGridView1.DataBind();
ASPxGridView1.KeyFieldName = "id_sedziego";
ASPxGridView1.Columns.Clear();
int szerokoscKolumny = 80;
ASPxGridView1.Width = Panel1.Width;
ASPxGridView1.Columns.Add(DevExpressXXL.kolumnaDoTabeli("L.p.", "id", idTabeli, "", true, 36));
ASPxGridView1.Columns.Add(DevExpressXXL.kolumnaDoTabeli("Imie i nazwisko", "Imienazwisko", idTabeli, "", true, 250));
// GridViewBandColumn kolumna_SprawyZakresuUbezpieczenSpolecznych = DevExpressXXL.GetBoundColumn("Sprawy z zakresu ubezpieczeń społecznych ");
ASPxGridView1.Columns.Add(DevExpressXXL.kolumnaDoTabeli("zaległość poprzedniego roku", "d_01", idTabeli, "", false, szerokoscKolumny));
string[] teksty00 = new string[] { "Ogółem", "GC", "GNs", "GNc", "GCo", "GCps", "WSC", "WSNc", "Gz" };
ASPxGridView1.Columns.Add(DevExpressXXL.podKolumna(teksty00, 2, idTabeli, false, szerokoscKolumny, "WPŁYW"));
ASPxGridView1.Columns.Add(DevExpressXXL.SekcjaDwiePodKolumny(teksty00, "WYZNACZONO", 11, idTabeli, szerokoscKolumny));
ASPxGridView1.Columns.Add(DevExpressXXL.SekcjaDwiePodKolumny(teksty00, "ZAŁATWIONO", 29, idTabeli, szerokoscKolumny));
ASPxGridView1.Columns.Add(DevExpressXXL.podKolumna(teksty00, 47, idTabeli, false, szerokoscKolumny, "ZAŁATWIENIA"));
#region sesje odbyte przez sędziego
GridViewBandColumn sesjeSedziego = DevExpressXXL.GetBoundColumn("sesje odbyte przez sędziego ");
GridViewBandColumn wszystkieSesjeSedziego = DevExpressXXL.GetBoundColumn("na potrzeby MS-S");
wszystkieSesjeSedziego.Columns.Add(DevExpressXXL.kolumnaDoTabeli("ogółem", "d_56", idTabeli, "", false, szerokoscKolumny));
wszystkieSesjeSedziego.Columns.Add(DevExpressXXL.podKolumna(new string[2] {
"rozprawy", "posiedzenia"
}, 57, idTabeli, false, szerokoscKolumny, "z tego "));
sesjeSedziego.Columns.Add(wszystkieSesjeSedziego);
ASPxGridView1.Columns.Add(sesjeSedziego);
#endregion sesje odbyte przez sędziego
ASPxGridView1.Columns.Add(DevExpressXXL.podKolumna(teksty00, 59, idTabeli, false, szerokoscKolumny, "POZOSTAŁOŚĆ na następny miesiąc"));
ASPxGridView1.Columns.Add(DevExpressXXL.podKolumna(new string[] { "Ogółem", " do 3 m-cy", "pow. 3 do 6 m - cy", "pow. 6 do 12 m-cy", "pow. 12 m-cy do 2 lat", "pow. 2 do 3 lat", "pow. 3 do 5 lat", "pow. 5 do 8 lat", "pow. 8 lat" }, 68, idTabeli, false, szerokoscKolumny, "pozostało spraw starych "));
ASPxGridView1.Columns.Add(DevExpressXXL.podKolumna(new string[] { "Ogółem", "zakreś- lonych", "nie zakreś- lonych" }, 77, idTabeli, false, szerokoscKolumny, "stan spraw zawieszonych (wszystkie kategorie spraw)"));
GridViewBandColumn liczbaSporzadzonychUzasadnien = DevExpressXXL.podKolumna(new string[] { "Łącznie", "w terminie ustawowym 14 dni", "razem po terminie ustawowym", "nie- usprawied- liwione" }, 80, idTabeli, false, szerokoscKolumny, "liczba sporządzonych uzasadnień (wszystkie kategorie spraw)**");
GridViewBandColumn PoUplywie = (DevExpressXXL.podKolumna(new string[] { "1-14 dni", "w tym nieuspra -wiedliwione", "15-30 dni", "w tym nieuspra -wiedliwione", "powyżej 1 do 3 mies", "w tym nieuspra -wiedliwione", "ponad 3 mies", "w tym nieuspra -wiedliwione" }, 84, idTabeli, false, szerokoscKolumny, "po upływie terminiu ustawowego"));
liczbaSporzadzonychUzasadnien.Columns.Add(PoUplywie);
liczbaSporzadzonychUzasadnien.Columns.Add(DevExpressXXL.kolumnaDoTabeli("uzasadnienia wygłoszone *", "d_92", idTabeli, "", false, szerokoscKolumny));
liczbaSporzadzonychUzasadnien.Columns.Add(DevExpressXXL.kolumnaDoTabeli("Liczba spraw, do których wpłynął wniosek o transkrypcje uzasadnień wygłoszonych", "d_93", idTabeli, "", false, szerokoscKolumny));
liczbaSporzadzonychUzasadnien.Columns.Add(DevExpressXXL.podKolumna(new string[] { "razem", "w tym, w których projekt został zaakceptowany przez sędziego" }, 94, idTabeli, false, szerokoscKolumny, "Liczba spraw, w których projekt uzasadnienia orzeczenia sporządził asystent**"));
ASPxGridView1.Columns.Add(liczbaSporzadzonychUzasadnien);
GridViewBandColumn zalatwiono01skargiNaPrzewleklosc = DevExpressXXL.GetBoundColumn("skargi na przewlekłość");
zalatwiono01skargiNaPrzewleklosc.Columns.Add(DevExpressXXL.kolumnaDoTabeli("wpływ", "d_96", idTabeli, "", false, szerokoscKolumny));
zalatwiono01skargiNaPrzewleklosc.Columns.Add(DevExpressXXL.podKolumna(new string[] { "ogółem", "uwzględniono" }, 97, idTabeli, false, szerokoscKolumny, "załatwiono"));
zalatwiono01skargiNaPrzewleklosc.Columns.Add(DevExpressXXL.kolumnaDoTabeli("pozostałość", "d_99", idTabeli, "", false, szerokoscKolumny));
ASPxGridView1.Columns.Add(zalatwiono01skargiNaPrzewleklosc);
GridViewBandColumn mediacje = DevExpressXXL.GetBoundColumn("mediacje");
mediacje.Columns.Add(DevExpressXXL.kolumnaDoTabeli("WPŁYW liczba spraw, w których strony skierowano do mediacji ", "d_100", idTabeli, "", false, szerokoscKolumny));
mediacje.Columns.Add(DevExpressXXL.podKolumna(new string[] { "liczba ugód zawartych przed mediatorem", "w tym zatwierdzono ugodę" }, 101, idTabeli, false, szerokoscKolumny, "rozstrzygnięcie"));
ASPxGridView1.Columns.Add(mediacje);
ASPxGridView1.Columns.Add(DevExpressXXL.kolumnaDoTabeli("Uwagi", "d_102", idTabeli, "", false, szerokoscKolumny));
ASPxGridView1.Columns.Add(DevExpressXXL.podKolumna(new string[] { "na rozprawie", "na posiedzeniu" }, 103, idTabeli, false, szerokoscKolumny, "suma kontrolna"));
ASPxGridView1.TotalSummary.Clear();
ASPxGridView1.TotalSummary.Add(DevExpressXXL.komorkaSumujaca("Ogółem"));
for (int i = 1; i < 106; i++)
{
ASPxGridView1.TotalSummary.Add(DevExpressXXL.komorkaSumujaca(i));
}
}
public void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
DateTime DT1 = Convert.ToDateTime(ASPxDateEdit1.Text.Trim());
DateTime DT2 = Convert.ToDateTime(ASPxDateEdit2.Text.Trim());
string plinecode = "", scode = "";
try
{
if (DT1.AddDays(31) < DT2)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "选择日期范围不能超过31天，请重新选择！");
return;
}
else if (ASPxListBoxUsed.Items.Count <= 0)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", " 请选择要查询的零件！");
return;
}
plinecode = txtPCode.Value.ToString();
if (plinecode == "E")
{
scode = "ZDE068";
}
if (plinecode == "W")
{
scode = "ZD910";
}
if (plinecode == "R")
{
scode = "RONE001";
}
DataTable Table1 = new DataTable();
Table1.Columns.Add("日期");
Table1.Columns.Add("SO");
Table1.Columns.Add("计划");
for (int a = 0; a < ASPxListBoxUsed.Items.Count; a++)
{
string part = ASPxListBoxUsed.Items[a].ToString();
Table1.Columns.Add(part);
Table1.Columns.Add(part + "数量"); //数量=零件数量*计划数量
Table1.Columns.Add(part + "供应商");
PL_QUERY_ITEM8 sp = new PL_QUERY_ITEM8()
{
PLINECODE1 = plinecode,
SCODE1 = scode,
BEGINDATE1 = ASPxDateEdit1.Date,
ENDDATE1 = ASPxDateEdit2.Date,
PART1 = part
};
Procedure.run(sp);
}
string sql1 = "select distinct to_char(begin_date,'yyyy-mm-dd'),plan_code ,plan_so,plan_qty,plan_seq from data_plan where pline_code='" + txtPCode.Value.ToString() + "' and begin_date>=to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') and end_date<=to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') order by plan_seq,plan_code";
DataTable dt1 = dc.GetTable(sql1);
for (int j = 0; j < dt1.Rows.Count; j++)
{
string PlanQty = dt1.Rows[j][3].ToString();
string PlanSo = dt1.Rows[j][2].ToString();
string PlanCode = dt1.Rows[j][1].ToString();
string RQbegin = dt1.Rows[j][0].ToString();
int PlanSl = Convert.ToInt32(PlanQty);
DataRow dr = Table1.NewRow();
dr[0] = RQbegin;
dr[1] = PlanSo;
dr[2] = PlanCode;
for (int i = 0, m = 0; i < ASPxListBoxUsed.Items.Count; i++)
{
string part2 = ASPxListBoxUsed.Items[i].ToString();
string ChSql1 = "select replace ( a.comp,'#','') comp ,a.qty,a.gysmc from RSTBOMQD_ITEM8 a where a.udesc='" + part2 + "' and a.zddm='" + scode + "' and a.plan_Code='" + PlanCode + "' and a.plan_so='" + PlanSo + "' ";
DataTable dt2 = dc.GetTable(ChSql1);
if (dt2.Rows.Count > 0)
{
string code = dt2.Rows[0][0].ToString();
string qty = dt2.Rows[0][1].ToString();
string gys = dt2.Rows[0][2].ToString();
int sl = Convert.ToInt32(qty);
dr[m + 3] = code;
dr[m + 4] = sl * PlanSl;
dr[m + 5] = gys;
m = m + 3;
}
}
Table1.Rows.Add(dr);
}
Session["inv8800table"] = Table1;
ASPxGridView1.DataSource = Table1;
ASPxGridView1.DataBind();
}
catch { }
}
//差异调整
public void ASPxGridView1_CustomDataCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e)
{
string s = e.Parameters;
string[] s1 = s.Split('|');
string type1 = s1[0]; //按钮
int rowIndex = int.Parse(s1[1]); //index
ASPxGridView atl1 = (ASPxGridView)sender; //选中的行数是什么
int count1 = atl1.Selection.Count;
if (type1 == "Adjust")
{
for (int i = 0; i < count1 && rowIndex < rowIndex + count1; i++, rowIndex++)
{
string strMaterialnum = ASPxGridView1.GetRowValues(rowIndex, "MATERIAL_NUM").ToString();
string gzdd = ASPxGridView1.GetRowValues(rowIndex, "GZDD").ToString();
string qadsite = ASPxGridView1.GetRowValues(rowIndex, "QADSITE").ToString();
string materialcode = ASPxGridView1.GetRowValues(rowIndex, "MATERIAL_CODE").ToString();
int Materialnum = Convert.ToInt32(strMaterialnum);
//插入到日志表
try
{
string Sql3 = "INSERT INTO ATPUFSB_LOG (bill_code,material_code,material_num,gzdd,create_time,flag,yhmc,handle_time,qadsite,gys_code,rmes_id,user_code,flag_log,rqsj)"
+ " SELECT bill_code,material_code,material_num,gzdd,create_time,flag,yhmc,handle_time,qadsite,gys_code,rmes_id,'"
+ theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM atpufsb WHERE gzdd='" + gzdd + "' and qadsite='" + qadsite + "' and material_code='" + materialcode + "' "
+ "and create_time>=to_date('" + ASPxDateEdit1.Text.Trim() + "','yyyy-mm-dd') and create_time <=to_date('" + ASPxDateEdit2.Text.Trim() + "','yyyy-mm-dd')";
dc.ExeSql(Sql3);
}
catch
{
}
string Sql = "update atpufsb set flag='Y',handle_time=sysdate,yhmc='" + theUserName + "' where gzdd='" + gzdd + "' and qadsite='" + qadsite + "' and material_code='" + materialcode + "' "
+ "and create_time>=to_date('" + ASPxDateEdit1.Text.Trim() + "','yyyy-mm-dd') and create_time <=to_date('" + ASPxDateEdit2.Text.Trim() + "','yyyy-mm-dd')";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql3 = "INSERT INTO ATPUFSB_LOG (bill_code,material_code,material_num,gzdd,create_time,flag,yhmc,handle_time,qadsite,gys_code,rmes_id,user_code,flag,rqsj)"
+ " SELECT bill_code,material_code,material_num,gzdd,create_time,flag,yhmc,handle_time,qadsite,gys_code,rmes_id,'"
+ theUserCode + "' , 'AFTEREDIT', SYSDATE FROM atpufsb WHERE gzdd='" + gzdd + "' and qadsite='" + qadsite + "' and material_code='" + materialcode + "' "
+ "and create_time>=to_date('" + ASPxDateEdit1.Text.Trim() + "','yyyy-mm-dd') and create_time <=to_date('" + ASPxDateEdit2.Text.Trim() + "','yyyy-mm-dd')";
dc.ExeSql(Sql3);
}
catch
{
return;
}
string Sql2 = "select material_num from ms_over_mat where material_code='" + materialcode + "' and gzdd='" + gzdd + "' and qadsite='" + qadsite + "'";
DataTable dt2 = dc.GetTable(Sql2);
if (dt2.Rows.Count > 0)
{
string strmn = dt2.Rows[0][0].ToString();
int mn = Convert.ToInt32(strmn);
Materialnum = mn - Materialnum;
}
else
{
Materialnum = 0 - Materialnum;
}
strMaterialnum = Convert.ToString(Materialnum);
MS_MODIFY_OVER_MAT sp = new MS_MODIFY_OVER_MAT()
{
FUNC1 = "UPDATE",
MATERIALCODE1 = materialcode,
LINESIDENUM1 = strMaterialnum,
GZDD1 = gzdd,
YHDM1 = theUserCode,
QADSITE1 = qadsite
};
Rmes.DA.Base.Procedure.run(sp);
}
e.Result = "OK,回冲池数量已调整！";
}
else
{
e.Result = "Fail,调整失败！";
}
}
public void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
DateTime DT1 = Convert.ToDateTime(ASPxDateEdit1.Text.Trim());
DateTime DT2 = Convert.ToDateTime(ASPxDateEdit2.Text.Trim());
if (DT1.AddDays(31) < DT2)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "选择日期范围不能超过31天，请重新选择！");
return;
}
else if (ASPxListBoxUsed.Items.Count <= 0)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", " 请选择要查询的零件！");
return;
}
DataTable Table1 = new DataTable();
//string iteam_code = "";
Table1.Columns.Add("日期");
Table1.Columns.Add("SO");
Table1.Columns.Add("计划");
Table1.Columns.Add("流水号");
for (int a = 0; a < ASPxListBoxUsed.Items.Count; a++)
{
string part = ASPxListBoxUsed.Items[a].ToString();
string delsql = "delete from RSTBOMQD_ITEM8 where udesc='" + part + "'";
dc.ExeSql(delsql);
Table1.Columns.Add(part);
Table1.Columns.Add(part + "数量");
//Table1.Columns.Add(part+'▍↔'+"数量");
}
string plancode = "", PlanSo = "", PlanCode = "", RQbegin = "", plinecode = "", xl = "", scode = "", PlanQty = "";
int PlanSl = 0;
string snSql = "select lsh,max(ptime) ptime from ATPUDQYQDYB where PTIME>=to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') and PTIME<=to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') group by lsh order by ptime,lsh";
DataTable sndt = dc.GetTable(snSql);
for (int j = 0; j < sndt.Rows.Count; j++)
{
RQbegin = sndt.Rows[j][1].ToString();
string soSql = "select plan_code from data_plan_sn where sn='" + sndt.Rows[j][0].ToString() + "' and pline_code='" + txtPCode.Value.ToString() + "' ";
plancode = dc.GetValue(soSql);
//DataTable sodt = dc.GetTable(soSql);
//if (sodt.Rows.Count > 0) { plancode = sodt.Rows[0][0].ToString(); }
string sql1 = "select distinct begin_date,plan_so,plan_qty from data_plan where pline_code='" + txtPCode.Value.ToString() + "' and plan_code='" + plancode + "' and plan_type<>'C' and plan_type<>'D' ";
DataTable dt1 = dc.GetTable(sql1);
if (dt1.Rows.Count <= 0)
{
continue;
}
PlanSo = dt1.Rows[0][1].ToString();
PlanQty = dt1.Rows[0][2].ToString();
PlanSl = Convert.ToInt32(PlanQty);
plinecode = txtPCode.Value.ToString();
PlanCode = plancode;
DataRow dr = Table1.NewRow();
dr[0] = RQbegin;
dr[1] = PlanSo;
dr[2] = PlanCode;
dr[3] = sndt.Rows[j][0].ToString();
for (int i = 0, m = 0; i < ASPxListBoxUsed.Items.Count; i++)
{
string part2 = ASPxListBoxUsed.Items[i].ToString();
if (plinecode == "E")
{
scode = "ZF5";
}
if (plinecode == "W")
{
scode = "ATPU-T560";
}
//string delsql = "delete from RSTBOMQD_ITEM8 where udesc='" + part2 + "'";
//dc.ExeSql(delsql);
PL_BOMZJTS_ITEM8 sp = new PL_BOMZJTS_ITEM8()
{
PLANSO1 = PlanSo,
SCODE1 = scode,
PLANCODE1 = PlanCode,
PART1 = part2,
MACHINENAME1 = MachineName
};
Procedure.run(sp);
PL_UPDATE_BOMZJTS_ITEM8 sp2 = new PL_UPDATE_BOMZJTS_ITEM8()
{
PLANSO1 = PlanSo,
SCODE1 = scode,
PLANCODE1 = PlanCode,
PLINECODE1 = plinecode,
MACHINENAME1 = MachineName
};
Procedure.run(sp2);
PL_UPDATE_ITEM8 sp4 = new PL_UPDATE_ITEM8()
{
PLANSO1 = PlanSo,
PLANCODE1 = PlanCode,
SCODE1 = scode
};
Procedure.run(sp4);
//string ChSql22 = "select comp ,qty from RSTBOMQD_ITEM8 where udesc='" + part2 + "' and zddm='" + scode + "' ";
string ChSql1 = "select replace ( a.comp,'#','') comp ,a.qty,a.gysmc from RSTBOMQD_ITEM8 a where a.udesc='" + part2 + "' and a.zddm='" + scode + "' and a.plan_Code='" + PlanCode + "' ";
if (PlanSo != "")
{
ChSql1 = ChSql1 + " and a.plan_so='" + PlanSo + "'";
}
DataTable dt2 = dc.GetTable(ChSql1);
string code = "", qty = "";
int sl;
if (dt2.Rows.Count > 0)
{
code = dt2.Rows[0][0].ToString();
qty = dt2.Rows[0][1].ToString();
sl = Convert.ToInt32(qty);
//dr[m + 4] = code;
//dr[m + 5] = sl * PlanSl;
//m = m + 2;
dr[m + 4] = code;
dr[m + 5] = sl;
m = m + 2;
}
else
{
dr[m + 4] = code;
dr[m + 5] = "";
m = m + 2;
}
}
Table1.Rows.Add(dr);
}
Session["rept3400table"] = Table1;
ASPxGridView1.DataSource = Table1;
ASPxGridView1.DataBind();
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox uKHMC = ASPxGridView1.FindEditFormTemplateControl("txtKHMC") as ASPxTextBox;
ASPxTextBox uKHH = ASPxGridView1.FindEditFormTemplateControl("txtKHH") as ASPxTextBox;
ASPxTextBox uWLH = ASPxGridView1.FindEditFormTemplateControl("txtWLH") as ASPxTextBox;
ASPxTextBox uGYSDM = ASPxGridView1.FindEditFormTemplateControl("txtGYSDM") as ASPxTextBox;
ASPxTextBox uSO = ASPxGridView1.FindEditFormTemplateControl("txtSO") as ASPxTextBox;
ASPxTextBox uBBH = ASPxGridView1.FindEditFormTemplateControl("txtBBH") as ASPxTextBox;
string Sql = "UPDATE ATPUKHTM SET KHH='" + uKHH.Text.Trim() + "',WLH='" + uWLH.Text.Trim() + "',GYSDM='" + uGYSDM.Text.Trim() + "',BBH='" + uBBH.Text.Trim() + "',input_person='" + theUserId + "',input_time=sysdate "
+ " WHERE KHMC = '" + uKHMC.Text.Trim() + "' and SO = '" + uSO.Text.Trim() + "'";
dc.ExeSql(Sql);
//插入到日志表
try
{
string KHHOld = "";
string WLHOld = "";
string SNOld = "";
string BBHOld = "";
if (e.OldValues["KHH"] != null)
{
KHHOld = e.OldValues["KHH"].ToString();
}
if (e.OldValues["WLH"] != null)
{
WLHOld = e.OldValues["WLH"].ToString();
}
if (e.OldValues["SN"] != null)
{
SNOld = e.OldValues["SN"].ToString();
}
if (e.OldValues["BBH"] != null)
{
BBHOld = e.OldValues["BBH"].ToString();
}
string Sql2 = " INSERT INTO ATPUKHTM_LOG (khmc,khh,wlh,gysdm,sn,so,bbh,user_code,flag,rqsj)"
+ " VALUES( '"
+ e.OldValues["KHMC"].ToString() + "','"
+ KHHOld + "','"
+ WLHOld + "','"
+ e.OldValues["GYSDM"].ToString() + "','"
+ SNOld + "','"
+ e.OldValues["SO"].ToString() + "','"
+ BBHOld + "','"
+ theUserCode + "','BEFOREEDIT',SYSDATE) ";
dc.ExeSql(Sql2);
string KHHNew = "";
string WLHNew = "";
string SNNew = "";
string BBHNew = "";
if (e.OldValues["KHH"] != null)
{
KHHNew = e.NewValues["KHH"].ToString();
}
if (e.OldValues["WLH"] != null)
{
WLHNew = e.NewValues["WLH"].ToString();
}
if (e.OldValues["SN"] != null)
{
SNNew = e.NewValues["SN"].ToString();
}
if (e.OldValues["BBH"] != null)
{
BBHNew = e.NewValues["BBH"].ToString();
}
string Sql3 = "INSERT INTO ATPUKHTM_LOG (khmc,khh,wlh,gysdm,sn,so,bbh,user_code,flag,rqsj)"
+ " VALUES( '"
+ e.NewValues["KHMC"].ToString() + "','"
+ KHHNew + "','"
+ WLHNew + "','"
+ e.NewValues["GYSDM"].ToString() + "','"
+ SNNew + "','"
+ e.NewValues["SO"].ToString() + "','"
+ BBHNew + "','"
+ theUserCode + "','AFTEREDIT',SYSDATE) ";
dc.ExeSql(Sql3);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
try
{
string s = e.Parameters;
if (s == "Cancle")
{
this.ASPxGridView1.CancelEdit();
return;
}
ASPxTextBox Id = ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
ASPxComboBox personId = ASPxGridView1.FindEditFormTemplateControl("cmb_Person") as ASPxComboBox;
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(HrPayroll), "Id='" + Id.Text + "'");
HrPayroll payroll = C2.Manager.ORManager.GetObject(query) as HrPayroll;
bool action = false;
if (SafeValue.SafeString(personId.Value, "0") == "0")
{
throw new Exception("Name not be null!!!");
return;
}
if (payroll == null)
{
action = true;
payroll = new HrPayroll();
}
payroll.Person = SafeValue.SafeInt(personId.Value, 0);
ASPxDateEdit fromDate = ASPxGridView1.FindEditFormTemplateControl("txt_FromDate") as ASPxDateEdit;
payroll.FromDate = fromDate.Date;
ASPxDateEdit toDate = ASPxGridView1.FindEditFormTemplateControl("txt_ToDate") as ASPxDateEdit;
payroll.ToDate = toDate.Date;
ASPxTextBox term = ASPxGridView1.FindEditFormTemplateControl("txt_Term") as ASPxTextBox;
payroll.Term = term.Text;
ASPxTextBox pic = ASPxGridView1.FindEditFormTemplateControl("txt_Pic") as ASPxTextBox;
payroll.Pic = pic.Text;
ASPxComboBox status = ASPxGridView1.FindEditFormTemplateControl("cmb_StatusCode") as ASPxComboBox;
payroll.StatusCode = status.Text;
ASPxMemo remark = ASPxGridView1.FindEditFormTemplateControl("txt_Remark") as ASPxMemo;
payroll.Remark = remark.Text;
if (action)
{
payroll.CreateBy = HttpContext.Current.User.Identity.Name;
payroll.CreateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(payroll, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(payroll);
}
else
{
payroll.UpdateBy = HttpContext.Current.User.Identity.Name;
payroll.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(payroll, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(payroll);
}
Session["Payroll"] = "Id=" + payroll.Id;
this.dsPayroll.FilterExpression = Session["Payroll"].ToString();
if (this.ASPxGridView1.GetRow(0) != null)
{
this.ASPxGridView1.StartEdit(0);
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
protected void ASPxGridView1_CustomDataCallback1(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
ASPxTextBox Id = ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
string s = e.Parameters;
if (s == "Confirm")
{
string update_sql = string.Format(@"update Hr_Payroll set StatusCode='Confirm' where StatusCode='Draft'");
ConnectSql.ExecuteSql(update_sql);
e.Result = "Success!";
}
if (s == "UnConfirm")
{
string update_sql = string.Format(@"update Hr_Payroll set StatusCode='Draft' where Id={0}", SafeValue.SafeInt(Id.Text, 0));
ConnectSql.ExecuteSql(update_sql);
e.Result = "Success!";
}
if (s == "UnCancel")
{
string update_sql = string.Format(@"update Hr_Payroll set StatusCode='Draft' where Id={0}", SafeValue.SafeInt(Id.Text, 0));
ConnectSql.ExecuteSql(update_sql);
e.Result = "Success!";
}
if (s == "Payroll")
{
string sql = string.Format(@"select Person,sum(Amt) as TotalAmt,max(Remark) as Remark from Hr_Quote group by Person");
DataTable tab = ConnectSql.GetTab(sql);
int fromYear = txt_from.Date.Year;
int fromMonth = txt_from.Date.Month;
string name = HttpContext.Current.User.Identity.Name;
int toYear = txt_end.Date.Year;
int toMonth = txt_end.Date.Month;
bool result = false;
string from = txt_from.Date.ToString("yyyy-MM-dd");
string to = txt_end.Date.ToString("yyyy-MM-dd");
int month = toMonth - fromMonth;
DateTime firstDayOfFromMonth = new DateTime(fromYear, fromMonth, 1);
DateTime lastDayOfFromMonth = new DateTime(fromYear, fromMonth, DateTime.DaysInMonth(fromYear, fromMonth));
DateTime firstDayOfToMonth = new DateTime(toYear, toMonth, 1);
DateTime lastDayOfToMonth = new DateTime(toYear, toMonth, DateTime.DaysInMonth(toYear, toMonth));
if (month < 2)
{
for (int a = 0; a <= month; a++)
{
for (int i = 0; i < tab.Rows.Count; i++)
{
int person = SafeValue.SafeInt(tab.Rows[i]["Person"], 0);
string sql_pay = string.Format(@"select count(*) from Hr_Payroll where Person={0} and (FromDate>='{1}' and ToDate<='{2}')", person, firstDayOfFromMonth.ToString("yyyy-MM-dd"), lastDayOfFromMonth.ToString("yyyy-MM-dd"));
int cnt = SafeValue.SafeInt(ConnectSql.ExecuteScalar(sql_pay), 0);
string sql_pay_to = string.Format(@"select count(*) from Hr_Payroll where Person={0} and (FromDate>='{1}' and ToDate<='{2}')", person, firstDayOfToMonth.ToString("yyyy-MM-dd"), lastDayOfToMonth.ToString("yyyy-MM-dd"));
int cnt_to = SafeValue.SafeInt(ConnectSql.ExecuteScalar(sql_pay_to), 0);
if (cnt == 0)
{
#region From Date
decimal amt = SafeValue.SafeDecimal(tab.Rows[i]["TotalAmt"]);
string remark = SafeValue.SafeString(tab.Rows[i]["Remark"]);
HrPayroll payroll = new HrPayroll();
payroll.Person = person;
payroll.FromDate = firstDayOfFromMonth;
payroll.ToDate = lastDayOfFromMonth;
payroll.StatusCode = "Draft";
payroll.Term = "";
payroll.Remark = "";
payroll.Pic = "";
payroll.CreateBy = name;
payroll.CreateDateTime = DateTime.Now;
payroll.Amt = amt;
Manager.ORManager.StartTracking(payroll, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(payroll);
sql = string.Format(@"select * from Hr_Quote where Person={0}", person);
DataTable tabDet = ConnectSql.GetTab(sql);
for (int j = 0; j < tabDet.Rows.Count; j++)
{
string code = SafeValue.SafeString(tabDet.Rows[j]["PayItem"]);
string des = SafeValue.SafeString(tabDet.Rows[j]["Remark"]);
decimal payamt = SafeValue.SafeDecimal(tabDet.Rows[j]["Amt"]);
decimal before = SafeValue.SafeDecimal(tabDet.Rows[j]["Amt"]);
sql = string.Format(@"insert into Hr_PayrollDet(PayrollId,ChgCode,Description,Amt,CreateBy,CreateDateTime,Before) values({0},'{1}','{2}',{3},'{4}',getdate(),{3})", payroll.Id, code, des, payamt, name);
ConnectSql.ExecuteSql(sql);
}
#endregion
result = true;
}
else if (cnt_to == 0)
{
#region To Date
decimal amt = SafeValue.SafeDecimal(tab.Rows[i]["TotalAmt"]);
string remark = SafeValue.SafeString(tab.Rows[i]["Remark"]);
HrPayroll payroll = new HrPayroll();
payroll.Person = person;
payroll.FromDate = firstDayOfToMonth;
payroll.ToDate = lastDayOfToMonth;
payroll.StatusCode = "Draft";
payroll.Term = "";
payroll.Remark = "";
payroll.Pic = "";
payroll.CreateBy = name;
payroll.CreateDateTime = DateTime.Now;
payroll.Amt = amt;
Manager.ORManager.StartTracking(payroll, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(payroll);
sql = string.Format(@"select * from Hr_Quote where Person={0}", person);
DataTable tabDet = ConnectSql.GetTab(sql);
for (int j = 0; j < tabDet.Rows.Count; j++)
{
string code = SafeValue.SafeString(tabDet.Rows[j]["PayItem"]);
string des = SafeValue.SafeString(tabDet.Rows[j]["Remark"]);
decimal payamt = SafeValue.SafeDecimal(tabDet.Rows[j]["Amt"]);
decimal before = SafeValue.SafeDecimal(tabDet.Rows[j]["Amt"]);
sql = string.Format(@"insert into Hr_PayrollDet(PayrollId,ChgCode,Description,Amt,CreateBy,CreateDateTime,Before) values({0},'{1}','{2}',{3},'{4}',getdate(),{3})", payroll.Id, code, des, payamt, name);
ConnectSql.ExecuteSql(sql);
}
#endregion
result = true;
}
else
{
result = false;
e.Result = "Had Created Payroll!No Need Again!";
}
}
}
if (result)
{
e.Result = "Success!";
}
}
}
}
//protected void comWorkUnit_Callback(object sender, CallbackEventArgsBase e)
//{
// string pline = e.Parameter;
// List<StationEntity> stations = StationFactory.GetByProductLine(pline);
// ASPxComboBox workUnit = (ASPxComboBox)sender;
// workUnit.DataSource = stations;
// workUnit.TextField = "STATION_NAME";
// workUnit.ValueField = "WORKUNIT_CODE";
// workUnit.DataBind();
//}
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
if (ASPxGridView1.IsNewRowEditing)//新增
{
ASPxComboBox pline = ASPxGridView1.FindEditFormTemplateControl("combPline") as ASPxComboBox;
ASPxComboBox detectDataType = ASPxGridView1.FindEditFormTemplateControl("detectDataType") as ASPxComboBox;
ASPxTextBox detectstandard = ASPxGridView1.FindEditFormTemplateControl("txtDetectDataStandard") as ASPxTextBox;
ASPxTextBox detectup = ASPxGridView1.FindEditFormTemplateControl("txtDetectDataUp") as ASPxTextBox;
ASPxTextBox detectdown = ASPxGridView1.FindEditFormTemplateControl("txtDetectDataDown") as ASPxTextBox;
ASPxTextBox detectseries = ASPxGridView1.FindEditFormTemplateControl("ASPxTextBox2") as ASPxTextBox;
ASPxTextBox detectname = ASPxGridView1.FindEditFormTemplateControl("texDetectDataName") as ASPxTextBox;
if (detectDataType.Value == null)
{
e.RowError = "请选择检验类型！";
}
if (pline.Value == null)
{
e.RowError = "请选择产线！";
}
if (detectDataType.Value.ToString() == "3")//零件类型
{
string sql = "select * from copy_pt_mstr where pt_desc2 ='" + detectname.Text.Trim() + "'";
dataConn dc1 = new dataConn(sql);
DataTable dt = dc1.GetTable();
if (dt.Rows.Count <= 0)
{
e.RowError = "项目名称必须与零件名称相同！";
return;
}
}
if (detectDataType.Value.ToString() == "0")//计量型
{
if (detectup.Value == null || detectdown.Value == null)
{
e.RowError = "请输入上下限！";
return;
}
try
{
if (Convert.ToDouble(detectup.Value.ToString()) < Convert.ToDouble(detectdown.Value.ToString()))
{
e.RowError = "最大值小于最小值！";
return;
}
}
catch
{
e.RowError = "录入值不合法！";
return;
}
}
string aa = dc.GetValue("select count(1) from code_detect where pline_code='" + pline.Value.ToString() + "' and detect_name='" + detectname.Value.ToString() + "' "); //and product_series='" + detectseries.Value.ToString() + "'
if (aa != "0")
{
e.RowError = "录入数据重复！";
return;
}
}
if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing)
{
ASPxComboBox pline = ASPxGridView1.FindEditFormTemplateControl("combPline") as ASPxComboBox;
ASPxComboBox detectDataType = ASPxGridView1.FindEditFormTemplateControl("detectDataType") as ASPxComboBox;
ASPxTextBox detectstandard = ASPxGridView1.FindEditFormTemplateControl("txtDetectDataStandard") as ASPxTextBox;
ASPxTextBox detectup = ASPxGridView1.FindEditFormTemplateControl("txtDetectDataUp") as ASPxTextBox;
ASPxTextBox detectdown = ASPxGridView1.FindEditFormTemplateControl("txtDetectDataDown") as ASPxTextBox;
ASPxTextBox detectname = ASPxGridView1.FindEditFormTemplateControl("texDetectDataName") as ASPxTextBox;
//if (detectDataType.Value.ToString() == "1")//记点型限定01
//{
// if (detectstandard.Value == null)
// {
// e.RowError = "请输入标准值！";
// return;
// }
// try
// {
// if (detectstandard.Value.ToString() != "1" && detectstandard.Value.ToString() != "0")
// {
// e.RowError = "记点型限定输入0、1！";
// }
// }
// catch
// {
// e.RowError = "标准值输入错误！";
// }
//}
if (detectDataType.Value.ToString() == "0")//计量型
{
if (detectup.Value == null || detectdown.Value == null)
{
e.RowError = "请输入上下限！";
return;
}
try
{
if (Convert.ToDouble(detectup.Value.ToString()) < Convert.ToDouble(detectdown.Value.ToString()))
{
e.RowError = "最大值小于最小值！";
return;
}
}
catch
{
e.RowError = "录入值不合法！";
return;
}
}
if (detectDataType.Value.ToString() == "3")//零件类型
{
string sql = "select * from copy_pt_mstr where pt_desc2 ='" + detectname.Text.Trim() + "'";
dataConn dc1 = new dataConn(sql);
DataTable dt = dc1.GetTable();
if (dt.Rows.Count <= 0)
{
e.RowError = "项目名称必须与零件名称相同！";
return;
}
}
}
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
string rmes_id = e.OldValues["RMES_ID"].ToString();
DetectDataEntity detEntity = db.First <DetectDataEntity>("where rmes_id=@0", rmes_id);
ASPxComboBox pline = ASPxGridView1.FindEditFormTemplateControl("combPline") as ASPxComboBox;
//ASPxComboBox workUnit = ASPxGridView1.FindEditFormTemplateControl("comWorkUnit") as ASPxComboBox;
detEntity.PLINE_CODE = pline.SelectedItem.Value.ToString();
//detEntity.WORKUNIT_CODE = e.NewValues["WORKUNIT_CODE"].ToString();
detEntity.DETECT_CODE = e.NewValues["DETECT_CODE"].ToString();
detEntity.DETECT_NAME = e.NewValues["DETECT_NAME"].ToString();
detEntity.DETECT_UNIT = e.NewValues["DETECT_UNIT"].ToString();
detEntity.PRODUCT_SERIES = "";// e.NewValues["PRODUCT_SERIES"].ToString();
detEntity.ASSOCIATION_TYPE = e.NewValues["ASSOCIATION_TYPE"].ToString();
detEntity.INPUT_TIME = DateTime.Now;
detEntity.INPUT_PERSON = theUserId;
if (detEntity.DETECT_TYPE != "0")
{
//if (detEntity.DETECT_TYPE == "1")
//{
// try
// {
// detEntity.DETECT_STANDARD = Convert.ToInt32(e.NewValues["DETECT_STANDARD"].ToString().Trim());
// }
// catch
// {
// detEntity.DETECT_STANDARD = 0;
// }
//}
//else
//{
// detEntity.DETECT_STANDARD = 0;
//}
detEntity.DETECT_STANDARD = 0;
detEntity.DETECT_MAX = 0;
detEntity.DETECT_MIN = 0;
}
else
{
detEntity.DETECT_STANDARD = Convert.ToDouble(e.NewValues["DETECT_STANDARD"].ToString());
detEntity.DETECT_MAX = Convert.ToDouble(e.NewValues["DETECT_MAX"].ToString());
detEntity.DETECT_MIN = Convert.ToDouble(e.NewValues["DETECT_MIN"].ToString());
}
db.Update(detEntity);
//插入到日志表20161101
try
{
//string Sql2 = "INSERT INTO CODE_DETECT_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,TEMP01,TEMP02,user_code,flag,rqsj)"
// + " SELECT RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,TEMP01,TEMP02,'"
// + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM CODE_DETECT WHERE RMES_ID = '" + rmes_id + "' ";
string Sql2 = " INSERT INTO CODE_DETECT_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,user_code,flag,rqsj)"
+ " VALUES( '" + rmes_id + "','" + theCompanyCode + "','" + e.OldValues["PLINE_CODE"].ToString() + "','" + e.OldValues["PRODUCT_SERIES"].ToString() + "','"
+ e.OldValues["DETECT_CODE"].ToString() + "','"
+ e.OldValues["DETECT_NAME"].ToString() + "','"
+ e.OldValues["DETECT_TYPE"].ToString() + "','"
+ e.OldValues["DETECT_STANDARD"].ToString() + "','"
+ e.OldValues["DETECT_MAX"].ToString() + "','"
+ e.OldValues["DETECT_MIN"].ToString() + "','"
+ e.OldValues["DETECT_UNIT"].ToString() + "','"
+ e.OldValues["ASSOCIATION_TYPE"].ToString() + "','"
+ theUserCode + "','BEFOREEDIT',SYSDATE) ";
dc.ExeSql(Sql2);
string Sql3 = " INSERT INTO CODE_DETECT_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,user_code,flag,rqsj)"
+ " VALUES( '" + rmes_id + "','" + theCompanyCode + "','" + e.NewValues["PLINE_CODE"].ToString() + "','" + e.NewValues["PRODUCT_SERIES"].ToString() + "','"
+ e.NewValues["DETECT_CODE"].ToString() + "','"
+ e.NewValues["DETECT_NAME"].ToString() + "','"
+ e.NewValues["DETECT_TYPE"].ToString() + "','"
+ e.NewValues["DETECT_STANDARD"].ToString() + "','"
+ e.NewValues["DETECT_MAX"].ToString() + "','"
+ e.NewValues["DETECT_MIN"].ToString() + "','"
+ e.NewValues["DETECT_UNIT"].ToString() + "','"
+ e.NewValues["ASSOCIATION_TYPE"].ToString() + "','"
+ theUserCode + "','AFTEREDIT',SYSDATE) ";
dc.ExeSql(Sql3);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox pline = ASPxGridView1.FindEditFormTemplateControl("combPline") as ASPxComboBox;
//ASPxComboBox workUnit = ASPxGridView1.FindEditFormTemplateControl("comWorkUnit") as ASPxComboBox;
ASPxComboBox detectDataType = ASPxGridView1.FindEditFormTemplateControl("detectDataType") as ASPxComboBox;
string sql = "select 'DECT'||TRIM(TO_CHAR(SEQ_USER_ID.NEXTVAL,'000000')) from dual";
dc.setTheSql(sql);
string dece_code1 = dc.GetValue();
DetectDataEntity detEntity = new DetectDataEntity();
detEntity.COMPANY_CODE = theCompanyCode;
//detEntity.DETECT_CODE = e.NewValues["DETECT_CODE"].ToString();
detEntity.DETECT_CODE = dece_code1;
detEntity.DETECT_NAME = e.NewValues["DETECT_NAME"].ToString();
detEntity.DETECT_UNIT = e.NewValues["DETECT_UNIT"].ToString();
detEntity.PRODUCT_SERIES = "";// e.NewValues["PRODUCT_SERIES"].ToString();
detEntity.ASSOCIATION_TYPE = e.NewValues["ASSOCIATION_TYPE"].ToString();
detEntity.PLINE_CODE = pline.SelectedItem.Value.ToString();
detEntity.DETECT_TYPE = detectDataType.SelectedItem.Value.ToString();
detEntity.INPUT_TIME = DateTime.Now;
detEntity.INPUT_PERSON = theUserId;
if (detEntity.DETECT_TYPE != "0") //非计量型无上下限 记点型限定01
{
//if (detEntity.DETECT_TYPE == "1")
//{
// try
// {
// detEntity.DETECT_STANDARD = Convert.ToInt32(e.NewValues["DETECT_STANDARD"].ToString().Trim());
// }
// catch
// {
// detEntity.DETECT_STANDARD = 0;
// }
//}
//else
//{
// detEntity.DETECT_STANDARD = 0;
//}
detEntity.DETECT_STANDARD = 0;
detEntity.DETECT_MAX = 0;
detEntity.DETECT_MIN = 0;
}
else //计量型
{
if (e.NewValues["DETECT_STANDARD"] == null || e.NewValues["DETECT_STANDARD"].ToString().Trim() == "")
{
detEntity.DETECT_STANDARD = 0;
}
else
{
detEntity.DETECT_STANDARD = Convert.ToDouble(e.NewValues["DETECT_STANDARD"].ToString().Trim());
}
if (e.NewValues["DETECT_MAX"] == null || e.NewValues["DETECT_MAX"].ToString().Trim() == "")
{
detEntity.DETECT_MAX = 0;
}
else
{
detEntity.DETECT_MAX = Convert.ToDouble(e.NewValues["DETECT_MAX"].ToString());
}
if (e.NewValues["DETECT_MIN"] == null || e.NewValues["DETECT_MIN"].ToString().Trim() == "")
{
detEntity.DETECT_MIN = 0;
}
else
{
detEntity.DETECT_MIN = Convert.ToDouble(e.NewValues["DETECT_MIN"].ToString());
}
}
db.Insert(detEntity);
//插入到日志表20161101
try
{
string Sql2 = "INSERT INTO CODE_DETECT_LOG (RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,TEMP01,TEMP02,user_code,flag,rqsj)"
+ " SELECT RMES_ID,COMPANY_CODE,PLINE_CODE,PRODUCT_SERIES,DETECT_CODE,DETECT_NAME,DETECT_TYPE,DETECT_STANDARD,DETECT_MAX,DETECT_MIN,DETECT_UNIT,ASSOCIATION_TYPE,TEMP01,TEMP02,'"
+ theUserCode + "' , 'ADD', SYSDATE FROM CODE_DETECT WHERE DETECT_CODE = '"
+ dece_code1 + "' AND DETECT_NAME = '" + e.NewValues["DETECT_NAME"].ToString() + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
public void LoadGridView(int codeIncome)
{
try
{
var pResult = "";
_ds = _objPicking.GePickingInPanelReception(codeIncome, Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
Session["dsReporte"] = _ds;
if (!Convert.IsDBNull(_ds))
{
if (_ds.Tables[0].Rows.Count > 0)
{
if (!Convert.IsDBNull(_ds.Tables[0].Rows[0]["TASK_ID"]))
{
Session["TASK_ID_PANEL_PICKING"] = Convert.ToString(_ds.Tables[0].Rows[0]["TASK_ID"]);
ASPxLabel14.Value = Convert.ToString(_ds.Tables[0].Rows[0]["TASK_ID"]);
ASPxLabel14.Text = Convert.ToString(_ds.Tables[0].Rows[0]["TASK_ID"]);
}
if (!Convert.IsDBNull(_ds.Tables[0].Rows[0]["NAME_CLASSIFICATION"]))
{
ASPxComboBox1.Text = Convert.ToString(_ds.Tables[0].Rows[0]["NAME_CLASSIFICATION"]);
}
if ((!Convert.IsDBNull(_ds.Tables[0].Rows[0]["NAME_CUSTOMER"])))
{
ASPxComboBox3.Text = Convert.ToString(_ds.Tables[0].Rows[0]["NAME_CUSTOMER"]);
}
if ((!Convert.IsDBNull(_ds.Tables[0].Rows[0]["LOGIN"])))
{
ASPxComboBox2.Text = Convert.ToString(_ds.Tables[0].Rows[0]["LOGIN"]);
ASPxLabel13.Value = Convert.ToString(_ds.Tables[0].Rows[0]["LOGIN"]);
ASPxLabel13.Text = Convert.ToString(_ds.Tables[0].Rows[0]["LOGIN"]);
}
if ((!Convert.IsDBNull(_ds.Tables[0].Rows[0]["REFERENCE"])))
{
ASPxTextBox1.Text = Convert.ToString(_ds.Tables[0].Rows[0]["REFERENCE"]);
}
if ((!Convert.IsDBNull(_ds.Tables[0].Rows[0]["DOC_SAP_RECEPTION"])))
{
if (!ASPxTextBox2.Enabled)
{
ASPxTextBox2.Text = Convert.ToString(_ds.Tables[0].Rows[0]["DOC_SAP_RECEPTION"]);
}
}
if ((!Convert.IsDBNull(_ds.Tables[0].Rows[0]["COMMENTS"])))
{
ASPxMemo1.Text = Convert.ToString(_ds.Tables[0].Rows[0]["COMMENTS"]);
}
if ((!Convert.IsDBNull(_ds.Tables[0].Rows[0]["ALLOW_STORAGE_ON_DIFF"])))
{
ASPxCheckBox1.Value = Convert.ToInt32(_ds.Tables[0].Rows[0]["ALLOW_STORAGE_ON_DIFF"]);
}
if ((!Convert.IsDBNull(_ds.Tables[0].Rows[0]["SCANNING_STATUS"])))
{
switch (_ds.Tables[0].Rows[0]["SCANNING_STATUS"].ToString())
{
case "PENDING":
ASPxLabel11.Text = "Pendiente";
ASPxLabel11.ForeColor = Color.Red;
break;
case "IN_PROGRESS":
ASPxLabel11.Text = "En progreso...";
ASPxLabel11.ForeColor = Color.Yellow;
break;
case "COMPLETED":
ASPxLabel11.Text = "Completado";
ASPxLabel11.ForeColor = Color.Green;
break;
}
}
}
if (_ds.Tables[1].Rows.Count > 0)
{
ASPxGridView1.DataSource = _ds.Tables[1];
var regionCombo = (ASPxGridView1.Columns["CODE_SKU"] as GridViewDataComboBoxColumn);
if (regionCombo != null)
{
regionCombo.PropertiesComboBox.DataSource = _ds.Tables[1].DefaultView.ToTable(true,
"CODE_SKU");
regionCombo.PropertiesComboBox.ValueField = "CODE_SKU";
regionCombo.PropertiesComboBox.TextField = "CODE_SKU";
}
ASPxGridView1.DataBind();
Session["DATOS"] = _ds;
//ASPxComboBox4.Text = Convert.ToString(ds.Tables[1].Rows[0]["CODE_SKU"]);
//ASPxTextBox3.Text = Convert.ToString(ds.Tables[1].Rows[0]["DESCRIPTION_SKU"]);
//ASPxSpinEdit1.Number = Convert.ToInt32(ds.Tables[1].Rows[0]["EXPECTED"]);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
//callback方式刷新gridview
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
//ASPxGridView1.JSProperties.Add("cpCallbackValue", ".txt");
string s = e.Parameters;
string[] s1 = s.Split('|');
if (s1.Length > 1)
{
if (s1[0] == "XLS")
{
Microsoft.Office.Interop.Excel.Application apps = new Microsoft.Office.Interop.Excel.Application();
string theWriteFile = "Restruct" + System.DateTime.Now.ToString("yyyyMMddHHmmss");
string filename = @"C:\tranlist\" + theWriteFile + ".xls";
if (System.IO.File.Exists(filename))
{
try
{
System.IO.File.Delete(filename);
}
catch (Exception)
{
showAlert(this, "请先关闭打开的xls文件！");
return;
}
}
String sourcePath = Server.MapPath(Request.ApplicationPath) + "\\Rmes\\File\\改制BOM对比\\gzbomdb.xls";
//String sourcePath = Server.MapPath(Request.ApplicationPath) + "\\file\\c\\gzbomdb.xls";
String targetPath = filename; // "D:\\DT900\\UP\\lshqd.xls";
bool isrewrite = true; // true=覆盖已存在的同名文件,false则反之
System.IO.File.Copy(sourcePath, targetPath, isrewrite);
object oMissing = System.Reflection.Missing.Value;
apps.Visible = false;
apps.DisplayAlerts = false;
//得到WorkBook对象,可以用两种方式之一:下面的是打开已有的文件
Microsoft.Office.Interop.Excel.Workbook xBook = apps.Workbooks._Open(filename, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing);
//Microsoft.Office.Interop.Excel.Workbook _wbk;
//try
//{
// //得到WorkBook对象,可以用两种方式之一:下面的是打开已有的文件
// _wbk = excel.Workbooks._Open(filename, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
// oMissing, oMissing, oMissing, oMissing, oMissing);
//}
//catch
//{
// showAlert(this, "找不到路径！");
// Workbooks wbks = excel.Workbooks;
// //若打开已有excel，把“true”替换成该excel的文件路径；
// //注：若新建一个excel文档，“xxx”替换成true即可；不过这里新建的excel文档默认只有一个sheet。
// _wbk = wbks.Add(true);
//}
//指定要操作的Sheet，两种方式：
Microsoft.Office.Interop.Excel.Worksheet xSheet = (Microsoft.Office.Interop.Excel.Worksheet)xBook.Sheets[1];
//_wsh.Cells[1, 1] = "
//添加行
//((Range)_wsh.Rows[11, Missing.Value]).Insert(Missing.Value, XlInsertFormatOrigin.xlFormatFromLeftOrAbove);
//添加列
//_wsh.get_Range(_wsh.Cells[1, 1], Missing.Value).Insert(Missing.Value, XlInsertShiftDirection.xlShiftToRight);
//_wsh.get_Range(_wsh.Cells[1, 1], _wsh.Cells[_wsh.Rows.Count, 1]).Insert(Missing.Value, XlInsertShiftDirection.xlShiftToRight);
//设置单元格颜色
//((Range)_wsh.Rows[1, Missing.Value]).Interior.ColorIndex = 3;
xSheet.Cells[1, 1] = "流水号";
xSheet.Cells[1, 2] = "零件号";
xSheet.Cells[1, 3] = "零件名称";
xSheet.Cells[1, 4] = "数量";
xSheet.Cells[1, 5] = "工序";
xSheet.Cells[1, 6] = "工位";
xSheet.Cells[1, 7] = "计划号";
xSheet.Cells[1, 8] = "SO";
xSheet.Cells[1, 9] = "地点";
xSheet.Cells[1, 10] = "供应商";
xSheet.Cells[1, 11] = "类型";
xSheet.Cells[1, 12] = "保管员";
for (int i = 0; i < ASPxGridView1.VisibleRowCount; i++)
{
//添加行
//object a = ASPxGridView1.GetRow(i);
xSheet.Cells[i + 2, 1] = ASPxGridView1.GetRowValues(i, "GHTM");
xSheet.Cells[i + 2, 2] = ASPxGridView1.GetRowValues(i, "ABOM_COMP");
xSheet.Cells[i + 2, 3] = ASPxGridView1.GetRowValues(i, "ABOM_DESC");
xSheet.Cells[i + 2, 4] = ASPxGridView1.GetRowValues(i, "ABOM_QTY");
xSheet.Cells[i + 2, 5] = ASPxGridView1.GetRowValues(i, "ABOM_OP");
xSheet.Cells[i + 2, 6] = ASPxGridView1.GetRowValues(i, "ABOM_WKCTR");
xSheet.Cells[i + 2, 7] = ASPxGridView1.GetRowValues(i, "ABOM_JHDM");
xSheet.Cells[i + 2, 8] = ASPxGridView1.GetRowValues(i, "ABOM_SO");
xSheet.Cells[i + 2, 9] = ASPxGridView1.GetRowValues(i, "GZDD");
xSheet.Cells[i + 2, 10] = ASPxGridView1.GetRowValues(i, "ABOM_GYS");
xSheet.Cells[i + 2, 11] = ASPxGridView1.GetRowValues(i, "COMP_FLAG");
xSheet.Cells[i + 2, 12] = ASPxGridView1.GetRowValues(i, "BGY");
string compFlag = ASPxGridView1.GetRowValues(i, "COMP_FLAG").ToString();
switch (compFlag)
{
case "0":
//2代表白色
((Range)xSheet.Rows[i + 2, Missing.Value]).Interior.ColorIndex = 2;
break;
case "1":
//3代表红色
((Range)xSheet.Rows[i + 2, Missing.Value]).Interior.ColorIndex = 3;
break;
case "2":
//10代表不刺眼的绿色
((Range)xSheet.Rows[i + 2, Missing.Value]).Interior.ColorIndex = 10;
break;
default:
return;
}
}
xBook.Save();
xBook.Close(oMissing, oMissing, oMissing);
apps.Quit();
xSheet = null;
xBook = null;
apps = null;
try
{
ASPxGridView1.JSProperties.Add("cpCallbackValue", theWriteFile + ".xls");
}
catch { }
//}
//catch
//{
// showAlert(this, "导出失败！");
// return;
//}
}
}
else
{
//string theWriteFile = "";
ASPxGridView1.JSProperties.Add("cpCallbackValue", ".xls");
}
setCondition();
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
string MachineName = Request.UserHostAddress;
string hostIPAddress = Page.Request.UserHostAddress;
//IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress);
MachineName = hostIPAddress;
string sql = "delete FROM rst_qad_prtpart where dyyh='" + MachineName + "'";
dc.ExeSql(sql);
//按日期生成
if (cmbPlan.Text == "" && listPlan.Items.Count == 0)
{
sql = "SELECT DISTINCT plan_code,plan_so,plan_qty FROM data_plan WHERE TO_CHAR(begin_date,'YYYYMMDD')='" + datePlanDate.Text
+ "'and run_flag='Y' and pline_code='" + cmbPline.Value.ToString() + "'";
DataTable dt = dc.GetTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
BomReplaceFactory.QAD_CREATE_PRTPART("CAL", cmbPline.Value.ToString(), dt.Rows[i]["plan_so"].ToString(),
dt.Rows[i]["plan_code"].ToString(), dt.Rows[i]["plan_qty"].ToString(), MachineName);
}
}
//按计划生成
if (cmbPlan.Text != "" && listPlan.Items.Count == 0)
{
string planNum = "1";
if (txtQTY.Text != "")
{
planNum = txtQTY.Text;
}
BomReplaceFactory.QAD_CREATE_PRTPART("ONE", cmbPline.Value.ToString(), txtSo.Text, cmbPlan.Value.ToString()
, planNum, MachineName);
}
//批量生成
if (listPlan.Items.Count > 0)
{
for (int i = 0; i < listPlan.Items.Count; i++)
{
string str = listPlan.Items[i].Text;
string[] strs = str.Split(';');
string planCode = strs[0].ToString();
string so = strs[1].ToString();
string qty = strs[2].ToString();
BomReplaceFactory.QAD_CREATE_PRTPART("CAL", cmbPline.Value.ToString(), so,
planCode, qty, MachineName);
}
}
sql = "select ljbgy,ljdm,ljmc,ljgw,flgw ,ljdd ,SUM(ljsl) ljsl1,thljdm ,OLDLJDM ,get_zdbygw('" + cmbPline.Value.ToString()
+ "',flgw) flgw1 ,bz ,ljgys from rst_qad_prtpart t where 1=1 ";
string sqlDetail = "select t.jhdm,t.so,t.ljbgy,t.ljdm,t.ljmc,t.ljgw,t.flgw ,t.ljdd ,t.ljsl,t.thljdm ,OLDLJDM ,get_zdbygw('" + cmbPline.Value.ToString()
+ "',t.flgw) flgw1 ,bz ,ljgys,aa.zsl from rst_qad_prtpart t LEFT JOIN (SELECT a.ljbgy,a.ljdm,a.ljmc,a.ljgw,a.flgw,a.ljdd, SUM(a.ljsl) AS zsl FROM rst_qad_prtpart a WHERE GZDD = '" + cmbPline.Value.ToString() + "'"
+ " AND DYYH = '" + MachineName + "' GROUP BY a.ljbgy,a.ljdm,a.ljmc,a.ljgw,a.flgw,a.ljdd) aa ON t.ljbgy=aa.ljbgy AND t.ljdm=aa.ljdm AND t.ljmc=aa.ljmc "
+ " AND t.ljgw=aa.ljgw AND t.flgw=aa.flgw AND t.ljdd=aa.ljdd where 1=1 ";
string condition = "";
if (txtStoreman.Text != "")
{
condition += " and upper(t.ljbgy)>=upper('" + txtStoreman.Text + "') and upper(t.ljbgy)<=upper('" + txtStoreman2.Text + "') ";
}
if (txtGwdm.Text != "")
{
condition += " and upper(t.ljgw)=upper('" + txtGwdm.Text + "')";
}
if (txtLj.Text != "")
{
condition += " and upper(t.ljdm)=upper('" + txtLj.Text + "')";
}
if (cmbPlan.Text != "" && listPlan.Items.Count == 0 && CheckSn.Checked)
{
condition += " and so='" + txtSo.Text + "' and jhdm='" + cmbPlan.Value.ToString() + "'";
}
sql = sql + condition + " and gzdd='" + cmbPline.Value.ToString() + "' and dyyh='" + MachineName + "' GROUP BY ljbgy,ljdm ,ljmc ,ljgw ,flgw,ljdd ,ljgys ,thljdm ,oldljdm,bz order by ljbgy,ljgw,flgw,ljdm";
sqlDetail = sqlDetail + condition + " and gzdd='" + cmbPline.Value.ToString() + "' and dyyh='" + MachineName + "' ";
Session["RequisitionDetail"] = sqlDetail;
Session["mmsMaterialRequisition001"] = sql;
ASPxGridView1.DataSource = dc.GetTable(sql);
ASPxGridView1.DataBind();
}
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
//创建一个新的excel文档
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Workbooks wbks = excel.Workbooks;
//若打开已有excel，把“true”替换成该excel的文件路径；
//注：若新建一个excel文档，“xxx”替换成true即可；不过这里新建的excel文档默认只有一个sheet。
_Workbook _wbk = wbks.Add(true);
//取得sheet
Sheets shs = _wbk.Sheets;
//i是要取得的sheet的index
_Worksheet _wsh = (_Worksheet)shs.get_Item(1);
//_wsh.Cells[1, 1] = "
//添加行
//((Range)_wsh.Rows[11, Missing.Value]).Insert(Missing.Value, XlInsertFormatOrigin.xlFormatFromLeftOrAbove);
//添加列
//_wsh.get_Range(_wsh.Cells[1, 1], Missing.Value).Insert(Missing.Value, XlInsertShiftDirection.xlShiftToRight);
//_wsh.get_Range(_wsh.Cells[1, 1], _wsh.Cells[_wsh.Rows.Count, 1]).Insert(Missing.Value, XlInsertShiftDirection.xlShiftToRight);
//设置单元格颜色
//((Range)_wsh.Rows[1, Missing.Value]).Interior.ColorIndex = 3;
_wsh.Cells[1, 1] = "流水号";
_wsh.Cells[1, 2] = "零件号";
_wsh.Cells[1, 3] = "零件名称";
_wsh.Cells[1, 4] = "数量";
_wsh.Cells[1, 5] = "工序";
_wsh.Cells[1, 6] = "工位";
_wsh.Cells[1, 7] = "计划号";
_wsh.Cells[1, 8] = "SO";
_wsh.Cells[1, 9] = "地点";
_wsh.Cells[1, 10] = "供应商";
_wsh.Cells[1, 11] = "类型";
_wsh.Cells[1, 12] = "保管员";
for (int i = 0; i < ASPxGridView1.VisibleRowCount; i++)
{
//添加行
//object a = ASPxGridView1.GetRow(i);
_wsh.Cells[i + 2, 1] = ASPxGridView1.GetRowValues(i, "GHTM");
_wsh.Cells[i + 2, 2] = ASPxGridView1.GetRowValues(i, "ABOM_COMP");
_wsh.Cells[i + 2, 3] = ASPxGridView1.GetRowValues(i, "ABOM_DESC");
_wsh.Cells[i + 2, 4] = ASPxGridView1.GetRowValues(i, "ABOM_QTY");
_wsh.Cells[i + 2, 5] = ASPxGridView1.GetRowValues(i, "ABOM_OP");
_wsh.Cells[i + 2, 6] = ASPxGridView1.GetRowValues(i, "ABOM_WKCTR");
_wsh.Cells[i + 2, 7] = ASPxGridView1.GetRowValues(i, "ABOM_JHDM");
_wsh.Cells[i + 2, 8] = ASPxGridView1.GetRowValues(i, "ABOM_SO");
_wsh.Cells[i + 2, 9] = ASPxGridView1.GetRowValues(i, "GZDD");
_wsh.Cells[i + 2, 10] = ASPxGridView1.GetRowValues(i, "ABOM_GYS");
_wsh.Cells[i + 2, 11] = ASPxGridView1.GetRowValues(i, "COMP_FLAG");
_wsh.Cells[i + 2, 12] = ASPxGridView1.GetRowValues(i, "BGY");
string compFlag = ASPxGridView1.GetRowValues(i, "COMP_FLAG").ToString();
switch (compFlag)
{
case "0":
//2代表白色
((Range)_wsh.Rows[i + 2, Missing.Value]).Interior.ColorIndex = 2;
break;
case "1":
//3代表红色
((Range)_wsh.Rows[i + 2, Missing.Value]).Interior.ColorIndex = 3;
break;
case "2":
//10代表不刺眼的绿色
((Range)_wsh.Rows[i + 2, Missing.Value]).Interior.ColorIndex = 10;
break;
default:
return;
}
}
//如果目录不存在则创建目录
if (!Directory.Exists("C:/excel"))
{
Directory.CreateDirectory("C:/excel");
}
//屏蔽掉系统跳出的覆盖文件Alert
excel.DisplayAlerts = false;
_wbk.Saved = true;
//保存到指定目录
//替换点否会报错
_wbk.SaveAs("C:/excel/改制差异清单明细信息导出.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value);
//用@的方法只是不会报错，但\显示不出来
//showAlert(this, @"文件已保存至C:\excel\改制差异清单明细信息导出.xls");
//加一个中文的双引号就不会有什么问题
showAlert(this, "文件已成功保存！");
//设置回默认值
excel.DisplayAlerts = true;
excel.Quit();
//释放掉多余的excel进程
//??释放有问题，关闭电脑的时候会提示--将这些资源依次释放再设置为空，最后回收内存就不会再有问题
System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);
System.Runtime.InteropServices.Marshal.ReleaseComObject((object)wbks);
System.Runtime.InteropServices.Marshal.ReleaseComObject((object)_wbk);
System.Runtime.InteropServices.Marshal.ReleaseComObject((object)shs);
System.Runtime.InteropServices.Marshal.ReleaseComObject((object)_wsh);
_wsh = null;
shs = null;
_wbk = null;
wbks = null;
excel = null;
GC.Collect(0);
}
catch
{
showAlert(this, "导出失败！");
return;
}
}
private void setCondition()
{
string sql = "select * from dp_kcb where ";
if (txtPCode.Text.Trim() != "")
{
sql = sql + " gzdd = '" + txtPCode.Value.ToString() + "'";
}
else
{
sql = sql + " gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ";
}
if (ASPxDateEdit1.Text.Trim() != "")
{
sql = sql + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')>= to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') ";
}
if (ASPxDateEdit2.Text.Trim() != "")
{
sql = sql + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')<= to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss')";
}
if (textSO.Text.Trim() != "")
{
sql = sql + " AND so like '%" + textSO.Text.Trim() + "%'";
}
if (txtPc.Text.Trim() != "")
{
sql = sql + " AND gzrq like '%" + txtPc.Value.ToString().Trim() + "%'";
}
sql = sql + " order by so,ghtm";
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
string sql2 = "select SO,COUNT(*) SL from dp_kcb where ";
if (txtPCode.Text.Trim() != "")
{
sql2 = sql2 + " gzdd = '" + txtPCode.Value.ToString() + "'";
}
else
{
sql2 = sql2 + " gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ";
}
if (ASPxDateEdit1.Text.Trim() != "")
{
sql2 = sql2 + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')>= to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss')";
}
if (ASPxDateEdit2.Text.Trim() != "")
{
sql2 = sql2 + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')<= to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss')";
}
if (textSO.Text.Trim() != "")
{
sql2 = sql2 + " AND so like '%" + textSO.Text.Trim() + "%'";
}
if (txtPc.Text.Trim() != "")
{
sql2 = sql2 + " AND gzrq like '%" + txtPc.Text.Trim() + "%'";
}
sql2 = sql2 + " GROUP BY SO order by So";
DataTable dt2 = dc.GetTable(sql2);
ASPxGridView2.DataSource = dt2;
ASPxGridView2.DataBind();
}
//修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
if (txtPCode.Text.Trim() == "")
{
return;
}
else
{
ASPxTextBox uLSeq = ASPxGridView1.FindEditFormTemplateControl("txtLSeq") as ASPxTextBox;
//ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uLTime = ASPxGridView1.FindEditFormTemplateControl("txtLTime") as ASPxTextBox;
ASPxComboBox uLCode = ASPxGridView1.FindEditFormTemplateControl("txtLCode") as ASPxComboBox;
string strLSeq = uLSeq.Text.Trim();
string strPCode = txtPCode.Value.ToString();
string strLTime = uLTime.Text.Trim();
string strLCode = uLCode.Value.ToString();
string NstrSEQ = e.NewValues["LOCATION_SEQ"].ToString().Trim();
string OstrSEQ = e.OldValues["LOCATION_SEQ"].ToString().Trim();
int Nseq = Convert.ToInt32(NstrSEQ);
int Oseq = Convert.ToInt32(OstrSEQ);
//插入到日志表update
try
{
string Sql2 = "INSERT INTO MS_LOCATION_TIME_LOG (LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,user_code,flag,rqsj)"
+ " SELECT LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,'"
+ theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM MS_LOCATION_TIME WHERE LOCATION_SEQ <= '" + NstrSEQ + "' and LOCATION_SEQ >'" + OstrSEQ + "'AND GZDD = '" + strPCode + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
if (Nseq > Oseq)
{
string UpSql = "UPDATE MS_LOCATION_TIME SET LOCATION_SEQ = LOCATION_SEQ-1 WHERE LOCATION_SEQ <= '" + NstrSEQ + "' and LOCATION_SEQ >'" + OstrSEQ + "'AND GZDD = '" + strPCode + "' ";
dc.ExeSql(UpSql);
e.Cancel = true;
}
else if (Nseq < Oseq)
{
string UpSql = "UPDATE MS_LOCATION_TIME SET LOCATION_SEQ = LOCATION_SEQ+1 WHERE LOCATION_SEQ >= '" + NstrSEQ + "' and LOCATION_SEQ <'" + OstrSEQ + "'AND GZDD = '" + strPCode + "' ";
dc.ExeSql(UpSql);
e.Cancel = true;
}
//插入到日志表update
try
{
string Sql2 = "INSERT INTO MS_LOCATION_TIME_LOG (LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,user_code,flag,rqsj)"
+ " SELECT LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,'"
+ theUserCode + "' , 'AFTEREDIT', SYSDATE FROM MS_LOCATION_TIME WHERE LOCATION_SEQ <= '" + NstrSEQ + "' and LOCATION_SEQ >'" + OstrSEQ + "'AND GZDD = '" + strPCode + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
//插入到日志表update again
try
{
string Sql2 = "INSERT INTO MS_LOCATION_TIME_LOG (LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,user_code,flag,rqsj)"
+ " SELECT LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,'"
+ theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM MS_LOCATION_TIME WHERE GZDD = '" + strPCode + "' and LOCATION_CODE = '" + strLCode + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
string Sql = "UPDATE MS_LOCATION_TIME SET LOCATION_TIME='" + strLTime + "',LOCATION_SEQ='" + strLSeq + "' WHERE GZDD = '" + strPCode + "' and LOCATION_CODE = '" + strLCode + "'";
dc.ExeSql(Sql);
//插入到日志表update again
try
{
string Sql2 = "INSERT INTO MS_LOCATION_TIME_LOG (LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,user_code,flag,rqsj)"
+ " SELECT LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,'"
+ theUserCode + "' , 'AFTEREDIT', SYSDATE FROM MS_LOCATION_TIME WHERE GZDD = '" + strPCode + "' and LOCATION_CODE = '" + strLCode + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
}
public void ASPxGridView1_CustomDataCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e)
{
string s = e.Parameters;
string[] s1 = s.Split('|');
string type1 = s1[0];
int rowIndex = int.Parse(s1[1]);
string sql = "";
string ThisLsh = "", thisJhdm = "", ThisSo = "";
//ASPxGridView atl1 = (ASPxGridView)sender;
//int count1 = atl1.Selection.Count;
//List<object> aa = atl1.GetSelectedFieldValues("RMES_ID");
try
{
ThisLsh = ASPxGridView1.GetRowValues(rowIndex, "GHTM").ToString();
thisJhdm = ASPxGridView1.GetRowValues(rowIndex, "JHDM").ToString();
//ThisSo = Convert.ToString(ASPxGridView1.GetRowValues(rowIndex, "BEGIN_DATE")).Substring(0, Convert.ToString(ASPxGridView1.GetRowValues(rowIndex, "BEGIN_DATE")).IndexOf(" "));
ThisSo = ASPxGridView1.GetRowValues(rowIndex, "SO").ToString();
}
catch
{
e.Result = "Fail,缺少关键值！";
return;
}
sql = " select * from DATA_PRODUCT a left join data_plan b on a.plan_code=b.plan_code where (b.plan_type='C' or b.plan_type='D')and sn='" + ThisLsh + "' ";
DataTable dt = dc.GetTable(sql);
switch (type1)
{
case "Offset1":
if (dt.Rows.Count > 0)
{
e.Result = "Fail,改制发动机！";
}
else
{
string SQLSTR2 = "insert into qad_bkfllog(lsh1,user1,rqsj1,gzdd1,jhdm1) values('" + ThisLsh + "','" + theUserName + "',sysdate,'" + txtPlineCode.Value.ToString() + "','" + thisJhdm + "')";
dc.ExeSql(SQLSTR2);
}
break;
case "Offset3":
if (dt.Rows.Count > 0)
{
e.Result = "Fail,改制发动机！";
}
else
{
string SQlstr = "delete from qad_bkflrecord where lsh1='" + ThisLsh + "'";
dc.ExeSql(SQlstr);
}
//e.Result = "OK,下调成功！";
break;
default:
break;
}
}
//新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
if (txtPCode.Text.Trim() == "")
{
return;
}
else
{
ASPxTextBox uLSeq = ASPxGridView1.FindEditFormTemplateControl("txtLSeq") as ASPxTextBox;
//ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uLTime = ASPxGridView1.FindEditFormTemplateControl("txtLTime") as ASPxTextBox;
ASPxComboBox uLCode = ASPxGridView1.FindEditFormTemplateControl("txtLCode") as ASPxComboBox;
string strLSeq = uLSeq.Text.Trim();
string strPCode = txtPCode.Value.ToString();
string strLTime = uLTime.Text.Trim();
string strLCode = uLCode.Value.ToString();
string chSql2 = "SELECT LOCATION_SEQ FROM MS_LOCATION_TIME WHERE LOCATION_SEQ='" + strLSeq + "' AND GZDD='" + strPCode + "' ";
DataTable dt2 = dc.GetTable(chSql2);
if (dt2.Rows.Count > 0)
{
//插入到日志表
try
{
string Sql2 = "INSERT INTO MS_LOCATION_TIME_LOG (LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,user_code,flag,rqsj)"
+ " SELECT LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,'"
+ theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM MS_LOCATION_TIME WHERE LOCATION_SEQ >= '" + strLSeq + "' AND GZDD='" + strPCode + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
string UpSql = "UPDATE MS_LOCATION_TIME SET LOCATION_SEQ = LOCATION_SEQ+1 WHERE LOCATION_SEQ >= '" + strLSeq + "' AND GZDD='" + strPCode + "' ";
dc.ExeSql(UpSql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO MS_LOCATION_TIME_LOG (LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,user_code,flag,rqsj)"
+ " SELECT LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,'"
+ theUserCode + "' , 'AFTEREDIT', SYSDATE FROM MS_LOCATION_TIME WHERE LOCATION_SEQ >= '" + strLSeq + "' AND GZDD='" + strPCode + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
}
string Sql = "INSERT INTO MS_LOCATION_TIME (LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,input_person,input_time)VALUES('" + strLSeq + "','" + strLCode + "'," + strLTime + ",'" + strPCode + "','" + theUserId + "',sysdate)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO MS_LOCATION_TIME_LOG (LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,user_code,flag,rqsj)"
+ " SELECT LOCATION_SEQ,LOCATION_CODE,LOCATION_TIME,GZDD,'"
+ theUserCode + "' , 'ADD', SYSDATE FROM MS_LOCATION_TIME WHERE LOCATION_CODE = '" + strLCode + "' AND GZDD='" + strPCode + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
}
private void setCondition()
{
string FUNC1 = "", BC1, ZD1, GZDD1 = "", MACHINENAME1 = "", check = "", rq1 = "", rq2 = "";
if (txtChose.Text.Trim() != "")
{
FUNC1 = txtChose.Value.ToString();
}
if (FUNC1 == "BC")
{
rq1 = ASPxDateEdit1.Text.Trim();
rq2 = ASPxDateEdit1.Text.Trim();
}
else
{
rq1 = ASPxDateEdit1.Text.Trim();
rq2 = ASPxDateEdit2.Text.Trim();
}
check = chkJX.Value.ToString();
BC1 = txtBc.Text.Trim();
ZD1 = txtSCode.Text.Trim();
if (txtPCode.Text.Trim() != "")
{
GZDD1 = txtPCode.Value.ToString();
}
MACHINENAME1 = MachineName;
//if (check == "False")
//ASPxGridView1.ClientVisible = true;
//ASPxGridView2.ClientVisible = false;
MW_CREATE_RSTZZPTJ_NEW sp = new MW_CREATE_RSTZZPTJ_NEW()
{
FUNC1 = FUNC1,
RQ1 = ASPxDateEdit1.Date,
RQ2 = ASPxDateEdit2.Date,
BCMC1 = BC1,
ZDMC1 = ZD1,
MACHINENAME1 = MachineName
};
Procedure.run(sp);
string ChSql = "SELECT zdmc 站点名称,JHDM , SO PLAN_SO,jhsl 计划数量,wcsl 完成数量 FROM RSTZZPTJ WHERE MachineNAME='" + MachineName + "'";
DataTable Chdt = dc.GetTable(ChSql);
ASPxGridView1.DataSource = Chdt;
ASPxGridView1.DataBind();
//else
string Chsql2 = "";
if (FUNC1 == "BC")
{
if (BC1 == "全部")
{
Chsql2 = "select STATION_NAME 站点名称,PLAN_SO, count(distinct SN) 完成数量 from VW_DATA_COMPLETE where STATION_NAME='" + ZD1 + "' and WORK_DATE=to_date('" + rq1 + "','yyyy-mm-dd hh24:mi:ss') group by STATION_NAME,PLAN_SO ";
}
else
{
Chsql2 = "select STATION_NAME 站点名称,PLAN_SO ,count(distinct SN) 完成数量 from VW_DATA_COMPLETE where STATION_NAME='" + ZD1 + "' and WORK_DATE=to_date('" + rq1 + "','yyyy-mm-dd hh24:mi:ss') and shift_name='" + BC1 + "' group by STATION_NAME,PLAN_SO ";
}
}
else
{
Chsql2 = "select STATION_NAME 站点名称,PLAN_SO ,count(distinct SN) 完成数量 from VW_DATA_COMPLETE where STATION_NAME='" + ZD1 + "' and WORK_DATE>=to_date('" + rq1 + "','yyyy-mm-dd hh24:mi:ss') and WORK_DATE<=to_date('" + rq2 + "','yyyy-mm-dd hh24:mi:ss') group by STATION_NAME,PLAN_SO ";
}
DataTable dt2 = dc.GetTable(Chsql2);
ASPxGridView2.DataSource = dt2;
ASPxGridView2.DataBind();
//}
}
/// <summary>
/// desabilita los campos que no son editables
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ASPxGridView1_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e)
{
if (e.Column.FieldName == "identificacion")
{
ASPxPageControl tabs = (ASPxPageControl)ASPxGridView1.FindEditFormTemplateControl("pageControl");
ASPxFormLayout form = (ASPxFormLayout)tabs.FindControl("formLayoutUbicacion");
ASPxComboBox comboProvincia = (ASPxComboBox)form.FindControl("cmbProvincia");
if (comboProvincia.Items.Count == 0)
{
this.cargarProvincias();
}
EmisorReceptorIMEC dato = null;
using (var conexion = new DataModelFE())
{
if (e.Editor.Value != null)
{
dato = conexion.EmisorReceptorIMEC.Find(e.Editor.Value.ToString());
if (dato != null)
{
comboProvincia.Value = dato.provincia;
}
}
}
}
if (this.ASPxGridView1.IsNewRowEditing)
{
if (e.Column.FieldName == "identificacion")
{
this.cargarProvincias();
}
if (e.Column.FieldName == "estado")
{
e.Editor.Value = "ACTIVO";
}
}
else
{/****************** CUANDO ES UNA MODIFICACION *******************/
if (this.ASPxGridView1.IsEditing && e.Column.FieldName == "identificacion" && !String.IsNullOrEmpty(e.Editor.Value.ToString()) && Session["entro"].ToString() == "NO")
{
Session["entro"] = "SI";
EmisorReceptorIMEC dato = null;
using (var conexion = new DataModelFE())
{
dato = conexion.EmisorReceptorIMEC.Find(e.Editor.Value.ToString());
}
ASPxPageControl tabs = (ASPxPageControl)ASPxGridView1.FindEditFormTemplateControl("pageControl");
ASPxFormLayout form = (ASPxFormLayout)tabs.FindControl("formLayoutUbicacion");
this.cargarProvincias();
/* PROVINCIA */
ASPxComboBox comboProvincia = (ASPxComboBox)form.FindControl("cmbProvincia");
comboProvincia.Value = dato.provincia;
/* CANTON */
ASPxComboBox comboCanton = (ASPxComboBox)form.FindControl("cmbCanton");
comboCanton.Items.Clear();
/* DISTRITO */
ASPxComboBox comboDistrito = (ASPxComboBox)form.FindControl("cmbDistrito");
comboDistrito.Items.Clear();
/* BARRIO */
ASPxComboBox comboBarrio = (ASPxComboBox)form.FindControl("cmbBarrio");
comboBarrio.Items.Clear();
/* OTRA SEÑAS */
ASPxMemo otraSena = (ASPxMemo)form.FindControl("txtOtraSenas");
otraSena.Text = dato.otraSena;
using (var conexion = new DataModelFE())
{
foreach (var item in conexion.Ubicacion.
Where(x => x.codProvincia == dato.provincia).
Select(x => new { x.codCanton, x.nombreCanton }).Distinct())
{
comboCanton.Items.Add(item.nombreCanton, item.codCanton);
}
comboCanton.IncrementalFilteringMode = IncrementalFilteringMode.Contains;
comboCanton.Value = dato.canton;
foreach (var item in conexion.Ubicacion.
Where(x => x.codProvincia == dato.provincia).
Where(x => x.codCanton == dato.canton).
Select(x => new { x.codDistrito, x.nombreDistrito }).Distinct())
{
comboDistrito.Items.Add(item.nombreDistrito, item.codDistrito);
}
comboDistrito.IncrementalFilteringMode = IncrementalFilteringMode.Contains;
comboDistrito.Value = dato.distrito;
foreach (var item in conexion.Ubicacion.
Where(x => x.codProvincia == dato.provincia).
Where(x => x.codCanton == dato.canton).
Where(x => x.codDistrito == dato.distrito).
Select(x => new { x.codBarrio, x.nombreBarrio }).Distinct())
{
comboBarrio.Items.Add(item.nombreBarrio, item.codBarrio);
}
comboBarrio.IncrementalFilteringMode = IncrementalFilteringMode.Contains;
comboBarrio.Value = dato.barrio;
}
}
}
}
protected void ASPxButton1_Click(object sender, EventArgs e)
{
var id = Convert.ToInt32(ASPxComboBox1.Value);
if (id == 0)
{
return;
}
var dict = new Dictionary <string, int>();
foreach (RepeaterItem r in Repeater1.Controls)
{
ASPxSpinEdit spin = (ASPxSpinEdit)r.Controls[1];
dict.Add(spin.Caption, Convert.ToInt32(spin.Value));
}
var db = new Db();
var project = db.Projects.Find(id);
var results = new List <DrawResult>();
var ran = new Random();
var all = new List <DrawResult>();
foreach (var buiding in project.Buildings)
{
foreach (var progress in buiding.BuildingProgresses)
{
for (var i = progress.FromFloor; i <= progress.ToFloor; i++)
{
for (var j = 1; j <= buiding.DoorsEachFloor; j++)
{
all.Add(new DrawResult()
{
Building = buiding, Floor = i, Door = j, Progress = progress.Progress
});
}
}
}
}
all = all.OrderBy(p => Guid.NewGuid()).ToList();
foreach (var progressDrawCount in dict)
{
var atMost = all.Where(r => r.Progress == progressDrawCount.Key).Count();
var count = atMost < progressDrawCount.Value ? atMost : progressDrawCount.Value;
while (results.Where(r => r.Progress == progressDrawCount.Key).Count() < count)
{
foreach (var building in project.Buildings)
{
var draw = all.FirstOrDefault(p => p.Building == building && p.Progress == progressDrawCount.Key);
if (draw != null)
{
results.Add(draw);
all.Remove(draw);
}
}
}
}
var tempIndex = 1;
results.ForEach(r => r.Index = tempIndex++);
ASPxGridView1.Visible = true;
ASPxGridView1.DataSource = results;
Session["results"] = results;
ASPxGridView1.DataBind();
return;
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
try
{
using (var conexion = new DataModelFE())
{
//se declara el objeto a insertar
EmisorReceptorIMEC dato = new EmisorReceptorIMEC();
//llena el objeto con los valores de la pantalla
dato.identificacionTipo = e.NewValues["identificacionTipo"].ToString();
dato.identificacion = e.NewValues["identificacion"].ToString();
dato.nombre = e.NewValues["nombre"].ToString();
dato.nombreComercial = e.NewValues["nombreComercial"] != null ? e.NewValues["nombreComercial"].ToString().ToUpper() : null;
if (e.NewValues["telefono"] != null)
{
//dato.telefonoCodigoPais = e.NewValues["telefonoCodigoPais"].ToString();
dato.telefonoCodigoPais = "506";
dato.telefono = e.NewValues["telefono"].ToString();
}
dato.correoElectronico = e.NewValues["correoElectronico"] != null ? e.NewValues["correoElectronico"].ToString() : null;
if (e.NewValues["fax"] != null)
{
//dato.faxCodigoPais = e.NewValues["faxCodigoPais"].ToString();
dato.faxCodigoPais = "506";
dato.fax = e.NewValues["fax"].ToString();
}
ASPxPageControl tabs = (ASPxPageControl)ASPxGridView1.FindEditFormTemplateControl("pageControl");
ASPxFormLayout form = (ASPxFormLayout)tabs.FindControl("formLayoutUbicacion");
/* PROVINCIA */
ASPxComboBox comboProvincia = (ASPxComboBox)form.FindControl("cmbProvincia");
/* CANTON */
ASPxComboBox comboCanton = (ASPxComboBox)form.FindControl("cmbCanton");
/* DISTRITO */
ASPxComboBox comboDistrito = (ASPxComboBox)form.FindControl("cmbDistrito");
/* BARRIO */
ASPxComboBox comboBarrio = (ASPxComboBox)form.FindControl("cmbBarrio");
ASPxMemo otraSena = (ASPxMemo)form.FindControl("txtOtraSenas");
dato.provincia = comboProvincia.Value.ToString();
dato.canton = comboCanton.Value.ToString();
dato.distrito = comboDistrito.Value.ToString();
dato.barrio = comboBarrio.Value.ToString();
dato.otraSena = otraSena.Text;
dato.estado = e.NewValues["estado"].ToString();
dato.usuarioCreacion = Session["usuario"].ToString();
dato.fechaCreacion = Date.DateTimeNow();
//agregar cliente
var existeEmisor = conexion.EmisorReceptorIMEC.Find(dato.identificacion);
if (existeEmisor == null)
{
conexion.EmisorReceptorIMEC.Add(dato);
}
else
{
conexion.Entry(dato).State = EntityState.Modified;
}
conexion.SaveChanges();
//asociar cliente
object[] key = new object[] { Session["emisor"].ToString(), dato.identificacion };
var cliente = conexion.Cliente.Find(key);
if (cliente == null)
{
cliente = new Cliente();
cliente.emisor = Session["emisor"].ToString();
cliente.receptor = dato.identificacion;
conexion.Cliente.Add(cliente);
conexion.SaveChanges();
}
//esto es para el manero del devexpress
e.Cancel = true;
this.ASPxGridView1.CancelEdit();
((ASPxGridView)sender).JSProperties["cpUpdatedMessage"] = "Los datos se agregaron correctamente, puede continuar.";
}
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(fullErrorMessage, ex.EntityValidationErrors);
}
catch (Exception ex)
{
throw new Exception(Utilidades.validarExepcionSQL(ex), ex.InnerException);
}
finally
{
//refescar los datos
this.refreshData();
}
}
//创建EDITFORM前
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing)
{
//string strFlag = ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "FLAG").ToString();
//if (strFlag == "Y")
//{
//Show(this, "已经计算的不能修改!");
//ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
//ASPxGridView1.JSProperties.Add("cpCallbackRet", "已经计算的不能修改！");
// return;
//}
(ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox).Enabled = false;
(ASPxGridView1.FindEditFormTemplateControl("txtMCode") as ASPxTextBox).Enabled = false;
(ASPxGridView1.FindEditFormTemplateControl("txtTName") as ASPxComboBox).Enabled = false;
}
string Sql = " select distinct a.pline_code,b.pline_name as showtext from vw_user_role_program a left join code_product_line b on a.pline_code=b.pline_code where a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' and a.company_code='" + theCompanyCode + "' ";
DataTable dt = dc.GetTable(Sql);
ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
uPCode.DataSource = dt;
uPCode.TextField = dt.Columns[1].ToString();
uPCode.ValueField = dt.Columns[0].ToString();
string Sql2 = "select INTERNAL_NAME TYPE_NAME,INTERNAL_CODE TYPE_CODE from CODE_INTERNAL WHERE INTERNAL_TYPE_CODE ='009' order by INTERNAL_CODE";
DataTable dt2 = dc.GetTable(Sql2);
ASPxComboBox uLCode = ASPxGridView1.FindEditFormTemplateControl("txtTName") as ASPxComboBox;
uLCode.DataSource = dt2;
uLCode.TextField = dt2.Columns[0].ToString();
DataTable dt1 = new DataTable();
dt1.Columns.Add("VALUE1", typeof(string));
dt1.Columns.Add("TEXT1", typeof(string));
DataRow dr1 = dt1.NewRow();
dt1.Rows.Add("Y", "是");
dt1.Rows.Add("N", "否");
ASPxComboBox gcfalg = ASPxGridView1.FindEditFormTemplateControl("txtHcFLAG") as ASPxComboBox;
gcfalg.DataSource = dt1;
gcfalg.TextField = dt1.Columns[1].ToString();
gcfalg.ValueField = dt1.Columns[0].ToString();
DataTable dt3 = new DataTable();
dt3.Columns.Add("VALUE1", typeof(string));
dt3.Columns.Add("TEXT1", typeof(string));
DataRow dr3 = dt3.NewRow();
dt3.Rows.Add("Y", "是");
dt3.Rows.Add("N", "否");
ASPxComboBox lqflag = ASPxGridView1.FindEditFormTemplateControl("txtLqFlag") as ASPxComboBox;
lqflag.DataSource = dt3;
lqflag.TextField = dt3.Columns[1].ToString();
lqflag.ValueField = dt3.Columns[0].ToString();
DataTable dt4 = new DataTable();
dt4.Columns.Add("VALUE1", typeof(string));
dt4.Columns.Add("TEXT1", typeof(string));
DataRow dr4 = dt4.NewRow();
dt4.Rows.Add("N", "否");
dt4.Rows.Add("Y", "是");
ASPxComboBox packflag = ASPxGridView1.FindEditFormTemplateControl("txtPackFlag") as ASPxComboBox;
packflag.DataSource = dt4;
packflag.TextField = dt4.Columns[1].ToString();
packflag.ValueField = dt4.Columns[0].ToString();
if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing)
{
(ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox).Enabled = false;
(ASPxGridView1.FindEditFormTemplateControl("txtMCode") as ASPxTextBox).Enabled = false;
(ASPxGridView1.FindEditFormTemplateControl("txtTName") as ASPxComboBox).Enabled = false;
}
}
//初始化GridView
private void setCondition()
{
string sql = "";
//if (ComboTable.Text.Trim() == "三方物流")
//{
sql = "SELECT R.ROWID,R.GZDD,R.BILL_CODE,R.MATERIAL_CODE,P.PT_DESC2,R.BGY_CODE,SUM(R.MATERIAL_NUM) AS SUM_MATERIAL_NUM,"
+ "R.LOCATION_CODE,R.GYS_CODE,V.VD_SORT,R.INV_CODE,R.PO_NBR,TO_CHAR(R.REQUIRE_TIME,'YYYY-MM-DD HH24:MI:SS') AS REQUIRE_TIME,R.BILL_REMARK "
+ " FROM MS_SFJIT_RESULT R "
+ " LEFT JOIN COPY_PT_MSTR P ON R.MATERIAL_CODE = P.PT_PART "
+ " LEFT JOIN COPY_VD_MSTR V ON R.GYS_CODE = V.VD_ADDR "
+ " WHERE 1=1 ";
if (ComboGzdd.Text.Trim() != "")
{
sql += " AND R.GZDD = '" + ComboGzdd.Value.ToString() + "' ";
}
//若单据号为空则不显示数据
if (ComboBillCode.Text.Trim() == "")
{
sql += " AND R.BILL_CODE = '' ";
}
if (ComboBillCode.Text.Trim() != "")
{
sql += " AND R.BILL_CODE = '" + ComboBillCode.Text.Trim().ToUpper() + "' ";
}
if (ComboLocationCode.Text.Trim() != "")
{
sql += " AND R.LOCATION_CODE = '" + ComboLocationCode.Text + "' ";
}
if (ComboBgyCode.Text.Trim() != "")
{
sql += " AND R.BGY_CODE = '" + ComboBgyCode.Text + "' ";
}
if (TextMaterialCode.Text.Trim() != "")
{
sql += " AND R.MATERIAL_CODE like '%" + TextMaterialCode.Text + "%' ";
}
if (TextBillRemark.Text.Trim() != "")
{
sql += " AND R.BILL_REMARK like '%" + TextBillRemark.Text + "%' ";
}
if (DateStart.Text.Trim() != "")
{
sql += " AND REQUIRE_TIME >= TO_DATE('" + DateStart.Text + "','YYYY-MM-DD HH24:MI:SS') ";
}
if (DateEnd.Text.Trim() != "")
{
sql += " AND R.REQUIRE_TIME <= TO_DATE('" + DateEnd.Text + "','YYYY-MM-DD HH24:MI:SS') ";
}
sql += " GROUP BY R.ROWID,R.GZDD,R.BILL_CODE,R.MATERIAL_CODE,R.GYS_CODE,P.PT_DESC2,R.BGY_CODE,R.LOCATION_CODE,V.VD_SORT,R.INV_CODE,R.PO_NBR,R.REQUIRE_TIME,R.BILL_REMARK "
+ " ORDER BY R.BILL_CODE DESC";
//}
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
//给BillCode赋值
//if (dt.Rows.Count > 0)
//{
// string BillCode = dt.Rows[0]["BILL_CODE"] as string;
// queryPlan(BillCode);
//}
//else
//{
// ASPxGridView2.DataSource = null;
// ASPxGridView2.DataBind();
//}
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
int indexPline, indexUser;
//string sql;
ASPxGridLookup GridLookupRole = ASPxGridView1.FindEditFormTemplateControl("GridLookupRole") as ASPxGridLookup;
ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup;
List <object> Plines = GridLookupRole.GridView.GetSelectedFieldValues("RMES_ID");
List <object> Users = gridLookupUser.GridView.GetSelectedFieldValues("USER_ID");
for (indexUser = 0; indexUser < Users.Count; indexUser++)
{
for (indexPline = 0; indexPline < Plines.Count; indexPline++)
{
string Sql1 = "delete from REL_USER_PLINE WHERE COMPANY_CODE = '" + theCompanyCode + "' and USER_ID = '" + Users[indexUser] + "'and PLINE_CODE = '" + Plines[indexPline] + "'";
dc.ExeSql(Sql1);
string Sql = "INSERT INTO REL_USER_PLINE (COMPANY_CODE,PLINE_CODE,USER_ID,RMES_ID) "
+ "VALUES('" + theCompanyCode + "','" + Plines[indexPline] + "','" + Users[indexUser] + "',SEQ_RMES_ID.NextVal)";
dc.ExeSql(Sql);
}
}
////新增
//int indexUser, indexRole;
//ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup;
//ASPxGridLookup gridLookupRole = ASPxGridView1.FindEditFormTemplateControl("GridLookupRole") as ASPxGridLookup;
//List<object> Users = gridLookupUser.GridView.GetSelectedFieldValues("USER_ID");
//List<object> Roles = gridLookupRole.GridView.GetSelectedFieldValues("PLINE_CODE");
//for (indexUser = 0; indexUser < Users.Count; indexUser++)
//{
// for (indexRole = 0; indexRole < Roles.Count; indexRole++)
// {
// MW_MODIFY_USER_PLINE sp = new MW_MODIFY_USER_PLINE()
// {
// THEFUNCTION1 = "ADD",
// THECOMPANYCODE1 = theCompanyCode,
// THEUSERID1 = Users[indexUser].ToString(),
// THEPLINECODE1 = Roles[indexRole].ToString()
// };
// Procedure.run(sp);
//dataConn theDataConn = new dataConn();
//theDataConn.theComd.CommandType = CommandType.StoredProcedure;
//theDataConn.theComd.CommandText = "MW_MODIFY_USER_PLINE";
//theDataConn.theComd.Parameters.Add("THEFUNCTION1", OracleDbType.Varchar2).Value = "ADD";
//theDataConn.theComd.Parameters.Add("THEFUNCTION1", OracleDbType.Varchar2).Direction = ParameterDirection.Input;
//theDataConn.theComd.Parameters.Add("THECOMPANYCODE1", OracleDbType.Varchar2).Value = theCompanyCode;
//theDataConn.theComd.Parameters.Add("THECOMPANYCODE1", OracleDbType.Varchar2).Direction = ParameterDirection.Input;
//theDataConn.theComd.Parameters.Add("THEUSERID1", OracleDbType.Varchar2).Value = Users[indexUser].ToString();
//theDataConn.theComd.Parameters.Add("THEUSERID1", OracleDbType.Varchar2).Direction = ParameterDirection.Input;
//theDataConn.theComd.Parameters.Add("THEPLINECODE1", OracleDbType.Varchar2).Value = Roles[indexRole].ToString();
//theDataConn.theComd.Parameters.Add("THEPLINECODE1", OracleDbType.Varchar2).Direction = ParameterDirection.Input;
//theDataConn.OpenConn();
//theDataConn.theComd.ExecuteNonQuery();
//theDataConn.CloseConn();
// }
//}
setCondition();
e.Cancel = true;
ASPxGridView1.CancelEdit();
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
//判断是否有人在转换,如果是退出，提示随后再加
string sql = "select bomrunning,bomuser from atpusysstate1";
DataTable dt = dc.GetTable(sql);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() == "1")
{
return;
}
}
//加入转换用户
userManager theUserManager = (userManager)Session["theUserManager"];
string userName = theUserManager.getUserName();
sql = "update atpusysstate1 set bomuser='******',bomrunning=1";
dc.ExeSql(sql);
//删除原来记录
sql = "DELETE FROM RST_QAD_MOVEPART";
dc.ExeSql(sql);
string MachineName = Request.UserHostAddress;
//批量生成
if (listPlan.Items.Count > 0)
{
for (int i = 0; i < listPlan.Items.Count; i++)
{
string str = listPlan.Items[i].Text;
string[] strs = str.Split(';');
string planCode = strs[0].ToString();
string so = strs[1].ToString();
string qty = strs[2].ToString();
BomReplaceFactory.QAD_CREATE_MOVEGZ(cmbPline.Value.ToString(), so, planCode, qty);
}
}
sql = "SELECT ABOM_COMP ,ABOM_WKCTR ,ABOM_KW ,SUM(ABOM_QTY) QTY1 from rst_qad_movepart GROUP BY ABOM_COMP,ABOM_WKCTR,ABOM_KW ORDER BY ABOM_COMP,ABOM_WKCTR";
//sql = "SELECT ABOM_COMP ,ABOM_WKCTR ,ABOM_KW ,SUM(ABOM_QTY) QTY1 from rst_qad_movepart WHERE abom_user='******' GROUP BY ABOM_COMP,ABOM_WKCTR,ABOM_KW ORDER BY ABOM_COMP,ABOM_WKCTR";
Session["mmsMaterialMoveGZ001"] = sql;
ASPxGridView1.DataSource = dc.GetTable(sql);
ASPxGridView1.DataBind();
//----------------2016.10.25 ADD 生成txt文件-------------------
string qadsite = dc.GetValue("select FUNC_GET_PLANSITE( '" + cmbPline.Value.ToString() + "', 'D') from dual");
//生成txt文件
if (!Directory.Exists("C:\\TRANLIST"))
{
Directory.CreateDirectory("C:\\TRANLIST");
}
//文件名
string ThisWjmc = "";
if (cmbPline.Value.ToString() == "E")
{
ThisWjmc = "TL" + datePlanDate.Date.ToString("yyMMdd") + "B-" + System.DateTime.Now.ToString("HHmmss");
}
//TL20031219DCEC-B.TXT
else if (cmbPline.Value.ToString() == "W")
{
ThisWjmc = "TL" + datePlanDate.Date.ToString("yyMMdd") + "C-" + System.DateTime.Now.ToString("HHmmss");
}
else if (cmbPline.Value.ToString() == "ISZ")
{
ThisWjmc = "TL" + datePlanDate.Date.ToString("yyMMdd") + "Z-" + System.DateTime.Now.ToString("HHmmss");
}
else if (cmbPline.Value.ToString() == "R")
{
ThisWjmc = "TL" + datePlanDate.Date.ToString("yyMMdd") + "R-" + System.DateTime.Now.ToString("HHmmss");
}
string theWriteFile = "";
sql = "SELECT DISTINCT GZDD FROM RST_QAD_MOVEPART ORDER BY GZDD";
dt = dc.GetTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
string theQadSite = dt.Rows[i][0].ToString();
if (qadsite == "R")
{
theWriteFile = "R" + theQadSite.Substring(theQadSite.Length - 1, 1) + ThisWjmc;
}
else
{
theWriteFile = ThisWjmc;
}
FileStream fs1 = new FileStream("C:\\TRANLIST\\" + theWriteFile + ".txt", FileMode.Create, FileAccess.Write, FileShare.ReadWrite);//创建写入文件
//StreamWriter sw = new StreamWriter(fs1);
StreamWriter sw = new StreamWriter(fs1, System.Text.Encoding.UTF8);
sw.WriteLine("移仓单号,地点,生效日期,子零件,缺省库位,车间库位,数量,");//开始写入值
sql = "SELECT ABOM_COMP 零件 ,ABOM_WKCTR 工位,ABOM_KW 库位,SUM(ABOM_QTY) 数量 from rst_qad_movepart WHERE GZDD='" + theQadSite
+ "' GROUP BY ABOM_COMP,ABOM_WKCTR,ABOM_KW ORDER BY ABOM_COMP,ABOM_WKCTR";
DataTable dt2 = dc.GetTable(sql);
for (int j = 0; j < dt2.Rows.Count; j++)
{
string Line1 = "";
Line1 = Line1 + theWriteFile + ",";
Line1 = Line1 + theQadSite + ",";
//Line1 = Line1 + Convert.ToDateTime(txtAccountDate.Text).ToString("yyyy/mm/dd") + ",";
try
{
Line1 = Line1 + Convert.ToDateTime(txtAccountDate.Text).ToString("yyyy/MM/dd") + ",";
}
catch
{
Line1 = Line1 + Convert.ToDateTime(datePlanDateTo.Text).ToString("yyyy/MM/dd") + ",";
}
Line1 = Line1 + dt2.Rows[j][0].ToString() + ",";
Line1 = Line1 + dt2.Rows[j][2].ToString() + ",";
Line1 = Line1 + dt2.Rows[j][1].ToString() + ",";
Line1 = Line1 + dt2.Rows[j][3].ToString() + ",";
sw.WriteLine(Line1);
//sw.NewLine = Line1;
}
sw.Close();
sw.Dispose();
fs1.Close();
fs1.Dispose();
}
sql = "update atpusysstate1 set bomrunning=0";
dc.ExeSql(sql);
//GC.Collect();
try
{
//System.Net.WebClient myWebClient = new System.Net.WebClient();
//myWebClient.DownloadFile(@"\\192.168.112.144\TRANLIST\" + theWriteFile + ".txt", @"C:\TRANLIST\" + theWriteFile + ".txt");
ASPxGridView1.JSProperties.Add("cpCallbackValue", theWriteFile + ".txt");
}
catch { }
//showAlert(this, "请前往C:\\\\TRANLIST目录查看文件！");
}
