private void initCode() { //初始化下拉列表 string sql = "select distinct a.pline_code,b.pline_name 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 + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); SqlCode1.SelectCommand = sql; SqlCode1.DataBind(); SqlCode2.SelectCommand = sql; SqlCode2.DataBind(); //txtPCode.SelectedIndex = txtPCode.Items.Count >= 0 ? 0 : -1; //txtPCode1.SelectedIndex = txtPCode.Items.Count >= 0 ? 0 : -1; //txtPCode2.SelectedIndex = txtPCode.Items.Count >= 0 ? 0 : -1; string Sql2 = " select pt_part from copy_pt_mstr order by pt_part"; SqlICode.SelectCommand = Sql2; SqlICode.DataBind(); string Sql3 = "select DETECT_NAME from code_detect where pline_code in ( SELECT PLINE_ID FROM VW_USER_ROLE_PROGRAM WHERE USER_ID='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') "; DataTable dt3 = dc.GetTable(Sql3); ASPxListBoxUnused.DataSource = dt3; ASPxListBoxUnused.DataBind(); }
//是点击按钮的时候才执行吗? //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") // { // //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:\\tranlist\\Storage")) // //{ // // Directory.CreateDirectory("C:\\tranlist\\Storage"); // //} // //屏蔽掉系统跳出的覆盖文件Alert // excel.DisplayAlerts = false; // _wbk.Saved = true; // //保存到指定目录 // //替换点否会报错 // string theWriteFile = "Restruct" + System.DateTime.Now.ToString("yyyyMMddHHmmss"); // _wbk.SaveAs("C:\\tranlist\\" + theWriteFile + ".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); // //_wbk.SaveCopyAs("C:\\tranlist\\" + theWriteFile + ".xls"); // //用@的方法只是不会报错,但\显示不出来 // //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); // try // { // ASPxGridView1.JSProperties.Add("cpCallbackValue", theWriteFile + ".xls"); // } // catch { } // //} // //catch // //{ // // showAlert(this, "导出失败!"); // // return; // //} // } // } // else // { // //string theWriteFile = ""; // ASPxGridView1.JSProperties.Add("cpCallbackValue", ".xls"); // } // setCondition(); //} //初始化生产线 private void initPlineCode() { string sql = "select distinct a.pline_code,b.pline_name 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 + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); }
protected void btnCodeFilter_Click(object sender, EventArgs e) { if (Session["user"] == null || Session["access"] != "ADMIN") { Response.Redirect("../index.aspx"); } string codeType = CodeTypeSearch.SelectedValue.Trim(); string codeId = CodeIdSearch.SelectedValue.Trim(); if (codeType == "%" && codeId == "%") { Session["codemainselect"] = "SELECT * FROM [CODE] ORDER BY [CODE_TYPE], [CODE_ID]"; SqlCode.SelectCommand = (string)Session["codemainselect"]; gvCode.DataBind(); } else if (codeType != "%" && codeId == "%") { Session["codemainselect"] = "SELECT * FROM [CODE] WHERE CODE_TYPE = '" + codeType + "' ORDER BY CODE_TYPE, CODE_ID"; SqlCode.SelectCommand = (string)Session["codemainselect"]; gvCode.DataBind(); } else if (codeType != "%" && codeId != "%") { Session["codemainselect"] = "SELECT * FROM [CODE] WHERE CODE_TYPE = '" + codeType + "' AND CODE_ID = '" + codeId + "' ORDER BY CODE_TYPE, CODE_ID"; SqlCode.SelectCommand = (string)Session["codemainselect"]; SqlCode.DataBind(); gvCode.DataBind(); } }
private void initCode() { //初始化用户下拉列表 string sql = "SELECT PLINE_CODE,PLINE_NAME FROM CODE_PRODUCT_LINE WHERE COMPANY_CODE = '" + theCompanyCode + "' ORDER BY PLINE_CODE"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); }
private void initCode() { //初始化生产线下拉列表 string sql = "select pline_code,pline_name from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); }
private void initCode() { //初始化工位下拉列表 string sql = "SELECT distinct STATION_NAME LOCATION_NAME FROM CODE_STATION WHERE COMPANY_CODE = '" + theCompanyCode + "' and pline_code in ((select pline_id from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')) ORDER BY LOCATION_NAME"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); }
private void initCode() { //初始化生产线下拉列表 string sql = "select a.depotid pline_code,a.depotname pline_name from dp_dmdepot a left join REL_USER_DMDEPOT b on a.depotid=b.depotid where b.user_code='" + theUserCode + "' and b.PROGRAM_CODE='INV9700' "; //string sql = "select distinct a.pline_code,b.pline_name 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 + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); }
private void initCode() { //初始化下拉列表 string sql = "select distinct a.pline_code,b.pline_name 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 + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); //txtPCode.SelectedIndex = txtPCode.Items.Count >= 0 ? 0 : -1; }
private void initCode() { //初始化下拉列表 string sql = "select distinct a.pline_code,b.pline_name 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 + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); //string sql2 = "select distinct a.plan_code from data_plan where "; //SqlPlanCode.SelectCommand = sql2; //SqlPlanCode.DataBind(); }
private void initCode() { //初始化生产线下拉列表 string sql = "select distinct a.pline_code,b.pline_name 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 + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); //txtPCode.SelectedIndex = txtPCode.Items.Count >= 0 ? 0 : -1; string sql2 = "select STATION_CODE,STATION_NAME from CODE_STATION where pline_code in(select distinct a.pline_code,b.pline_name 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 + "') order by STATION_NAME"; StationCode.SelectCommand = sql2; StationCode.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] == null || Session["access"] != "ADMIN") { Response.Redirect("../index.aspx"); } if (!IsPostBack) { Session["codemainselect"] = "SELECT * FROM [CODE] ORDER BY [CODE_TYPE], [CODE_ID]"; SqlCode.SelectCommand = (string)Session["codemainselect"]; SqlCode.DataBind(); } if (IsPostBack) { SqlCode.SelectCommand = (string)Session["codemainselect"]; SqlCode.DataBind(); } }
private void initCode() { //初始化生产线下拉列表 string sql = "select distinct a.pline_code,b.pline_name,a.pline_id 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 + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); DataTable dt = dc.GetTable(sql); string sql2 = ""; if (dt.Rows.Count > 0) { sql2 = "select distinct location_code from code_location where pline_code ='" + dt.Rows[0][2].ToString() + "' ORDER BY LOCATION_CODE"; } else { sql2 = "select distinct location_code from code_location where pline_code in (select pline_id from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ORDER BY LOCATION_CODE"; } SqlRLocation.SelectCommand = sql2; SqlRLocation.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { theProgramCode = "rept3200"; userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); theUserId = theUserManager.getUserId(); string sql = "select distinct a.pline_code,b.pline_name 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 + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); SqlCode1.SelectCommand = sql; SqlCode1.DataBind(); if (!IsPostBack) { //第一次进入页面默认取东区 txtPCode.SelectedIndex = 0; //第一次进入页面取不到生产线,用这种方式给ASPxGridView1增加数据 //string plineSql = "select distinct a.pline_code,b.pline_name 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 dt1 = dc.GetTable(plineSql); ////注意此处用rows才能取到,用columns取不到 //string pline = dt1.Rows[0]["PLINE_CODE"].ToString(); //string inSqlTemp = ""; //inSqlTemp = " SELECT DISTINCT SN FROM DATA_STORE WHERE PLINE_CODE = '" + pline + "' "; //DataTable dt = dc.GetTable(inSqlTemp); //ASPxGridView1.DataSource = dt; //ASPxGridView1.DataBind(); } //initPlineCode(); //放在pageload里,模糊查询,分页等功能才能正常使用,因为这些事件都会来后台处理数据,所以要查询的相关数据必须要放在pageload里,否则 //无法实现正常功能 setCondition1(); setCondition(); }
//private void initPlanCode() //{ // //初始化计划下拉列表(物料确认过的计划,且未参与过物流计算的计划) // string sql = "select plan_code from ms_single_plan where gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') order by online_time desc "; // sqlPlanCode.SelectCommand = sql; // sqlPlanCode.DataBind(); //} private void initPlineCode() { //初始化生产线下拉列表 string sql = "select distinct a.pline_code,b.pline_name 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 + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); DataTable dt = dc.GetTable(sql); string sql2 = ""; if (dt.Rows.Count > 0) { sql2 = "select plan_code from ms_single_plan where gzdd ='" + dt.Rows[0][0].ToString() + "' order by online_time desc "; } else { sql = "select plan_code from ms_single_plan where gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') order by online_time desc "; } sqlPlanCode.SelectCommand = sql2; sqlPlanCode.DataBind(); }
private void initCode() { //初始化生产线下拉列表 string sql = "select distinct a.pline_code,b.pline_name,a.pline_id 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 + "'"; SqlCode.SelectCommand = sql; SqlCode.DataBind(); //txtPCode.SelectedIndex = txtPCode.Items.Count >= 0 ? 0 : -1; DataTable dt = dc.GetTable(sql); string sql2 = ""; if (dt.Rows.Count > 0) { sql2 = "select STATION_CODE,STATION_NAME from CODE_STATION where pline_code ='" + dt.Rows[0][2].ToString() + "'order by STATION_NAME"; } else { sql2 = "select STATION_CODE,STATION_NAME from CODE_STATION where pline_code in(select distinct a.pline_id from vw_user_role_program a where a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' and a.company_code='" + theCompanyCode + "') order by STATION_NAME"; } StationCode.SelectCommand = sql2; StationCode.DataBind(); }