public static void queryDscweek(object sender) { try { System.Data.DataTable dt = new System.Data.DataTable(); List <System.Web.UI.WebControls.ListItem> listItem = new List <System.Web.UI.WebControls.ListItem>(); string strSql = "Select b.doc_code, b.emp_name From dscdocm b Inner Join dscweek a On a.emp_id=b.emp_id Where p_yymm=? And shift_no='A13'"; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql); cmd.Parameters.Add("@Param1", System.Data.Odbc.OdbcType.Char).Value = DateTime.Now.ToString("yyyyMM"); //cmd.Parameters.Add("@Param2", System.Data.Odbc.OdbcType.Char).Value = DateTime.Now.ToString("yyyyMM"); Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection(); dt = conn.GetData(cmd); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { listItem.Add(new System.Web.UI.WebControls.ListItem(dt.Rows[i]["doc_code"].ToString().Trim() + " " + dt.Rows[i]["emp_name"].ToString().Trim(), dt.Rows[i]["doc_code"].ToString().Trim())); } ((System.Web.UI.WebControls.DropDownList)sender).Items.AddRange(listItem.ToArray()); ((System.Web.UI.WebControls.DropDownList)sender).DataBind(); } } catch (Exception ex) { PublicLib.handleError("", "PublicLib", ex.Message); } }
public static void queryCodeFile(object sender, string strType, string strParam) { try { System.Data.DataTable dt = new System.Data.DataTable(); List <System.Web.UI.WebControls.ListItem> listItem = new List <System.Web.UI.WebControls.ListItem>(); string strSql = "Select item_code, description From code_file Where check_flag='Y' And item_type=?" + strParam; System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql); cmd.Parameters.Add("@Param", System.Data.Odbc.OdbcType.Char).Value = strType; Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection(); dt = conn.GetData(cmd); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { listItem.Add(new System.Web.UI.WebControls.ListItem(dt.Rows[i]["item_code"].ToString().Trim() + " " + dt.Rows[i]["description"].ToString().Trim(), dt.Rows[i]["item_code"].ToString().Trim())); } ((System.Web.UI.WebControls.DropDownList)sender).Items.AddRange(listItem.ToArray()); ((System.Web.UI.WebControls.DropDownList)sender).DataBind(); } } catch (Exception ex) { PublicLib.handleError("", "PublicLib", ex.Message); } }