public void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { string ThisSO = "", PlineCode = "", StationCode = ""; string Chsql2 = "SELECT PLAN_SO,PLINE_CODE FROM DATA_PLAN WHERE PLAN_CODE='" + ASPxTextPlanCode.Text.Trim() + "'"; DataTable Chdt2 = dc.GetTable(Chsql2); if (Chdt2.Rows.Count <= 0) { ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); ASPxGridView1.JSProperties.Add("cpCallbackRet", "计划号不存在!"); return; } else { ThisSO = Chdt2.Rows[0][0].ToString(); PlineCode = Chdt2.Rows[0][1].ToString(); } string Chsql3 = "SELECT STATION_CODE FROM CODE_STATION WHERE STATION_NAME='" + ASPxTextSation.Text.ToUpper().Trim() + "'"; DataTable Chdt3 = dc.GetTable(Chsql3); if (Chdt3.Rows.Count <= 0) { ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); ASPxGridView1.JSProperties.Add("cpCallbackRet", "站点名称不存在!"); return; } else { StationCode = Chdt3.Rows[0][0].ToString(); } ProductDataFactory.PL_QUERY_BOMZJTS(ThisSO, StationCode, PlineCode, "", ASPxTextPlanCode.Text.Trim(), ""); ProductDataFactory.PL_UPDATE_BOMZJTS(ThisSO, StationCode, ASPxTextPlanCode.Text.Trim(), PlineCode, ""); string Delsql = "delete from RSTBOMQD_XC "; dc.ExeSql(Delsql); string Insql = "INSERT INTO RSTBOMQD_XC (SELECT '" + ASPxTextPlanCode.Text.Trim() + "',GWMC,COMP,UDESC,QTY,GXMC,ZDMC,ZDDM,GYSMC from RSTBOMQD)"; dc.ExeSql(Insql); string sql = "SELECT GWMC,GXMC,COMP,QTY,GYSMC FROM rstbomqd_xc where zddm='" + StationCode + "' and jhmc='" + ASPxTextPlanCode.Text.Trim() + "' order by gwmc,gxmc"; DataTable dt = dc.GetTable(sql); Session["inv9500sql"] = sql; ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); }
public void GetByPlanStatonDcec_CL(string CompanyCode, string PlanCode, string PlineCode, string StationCode, string Sn, string fdjxl, string so, string stationcode1) { try { //大线生成计划对应的站点bom是根据当前登录的站点StationCode,返修点是根据选择的站点,这两个变量统一,但生成snbomtemp时,返修点要根据返修站点当前登录站点生成 //调用存储过程 获取替换后的站点BOM 插入data_sn_bom_temp和rstbomqd、rstbomts StationEntity ent_st = StationFactory.GetBySTATIONCODE(StationCode); string station_name = ent_st.STATION_NAME; ProductDataFactory.PL_QUERY_BOMZJTS(so, StationCode, PlineCode, fdjxl, PlanCode, Sn); ProductDataFactory.PL_UPDATE_BOMZJTS(so, StationCode, PlanCode, PlineCode, Sn); ProductDataFactory.PL_UPDATE_BOMLSHTS(Sn, StationCode); ProductDataFactory.PL_UPDATE_BOMSOTHTS(so, PlanCode, StationCode, Sn, LoginInfo.UserInfo.USER_CODE, stationcode1); } catch (Exception e1) { return; } }