/// <summary> /// 绑定结算方式 2012-8-15修改 /// </summary> /// <param name="cmb"></param> public static void BindSettleWay(FZYK.WinCtrl.YKComboBox cmb) { string sqlStr = " SELECT * FROM B_SettleWay ORDER BY swSort ASC"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "swName", "swID", "", 3); }
/// <summary> /// 绑定标准 2012-11-20 张 修改 /// </summary> /// <param name="cmb"></param> /// <param name="flag">1,(全部)2、(无)3、不增加新项目</param> public static void BindExtraType(FZYK.WinCtrl.YKComboBox cmb, int flag) { string sqlStr = "SELECT * FROM B_ExtraType"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "etName", "etNum", "", flag); }
/// <summary> /// 绑定采购类型下拉框 /// </summary> /// <param name="cmb"></param> public static void BindPurchaseType(FZYK.WinCtrl.YKComboBox cmb) { string sqlStr = " SELECT * FROM B_PurchaseType "; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "ptName", "ptNum", "", 3); }
/// <summary> /// 绑定出库类型 2012-8-16增加 /// </summary> /// <param name="cmb"></param> public static void BindOutType(FZYK.WinCtrl.YKComboBox cmb) { string sqlStr = " SELECT * FROM B_InOutType WHERE iotType = '出库' ORDER BY iotSort ASC"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "iotName", "iotID", "", 3); }
/// <summary> /// 绑定材质下拉框 2012-8-20 /// </summary> /// <param name="cmb">需要绑定的下拉框</param> /// <param name ="type">需要绑定的材质类型</param> public static void BindLimber(FZYK.WinCtrl.YKComboBox cmb, string type) { string sqlStr = "SELECT * FROM B_Limber WHERE lType = '" + type + "' ORDER BY lSort ASC"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "lName", "lID", "", 1); }
/// <summary> /// 绑定处理意见 /// 2013-6-17 张 新增 /// </summary> /// <param name="cmb"></param> public static void BindSuggest(FZYK.WinCtrl.YKComboBox cmb) { string sql = " SELECT DISTINCT ud_corrective FROM dbo.Q_UnqualifiedSetting"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sql); DevCommon.BindComboBox(cmb, dt, "ud_corrective", "ud_corrective", "", 1); }
/// <summary> /// 绑定仓库 2012-8-16增加 /// </summary> /// <param name="cmb"></param> public static void BindWarehouse(FZYK.WinCtrl.YKComboBox cmb) { string sqlStr = " SELECT * FROM B_Warehouse ORDER BY wSort ASC"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "wName", "wID", "", 3); }
/// <summary> /// 绑定仓库[全部] 2013-3-27 张 新增 /// </summary> /// <param name="cmb"></param> public static void BindWarehouseAll(FZYK.WinCtrl.YKComboBox cmb, string type) { string sqlStr = " SELECT * FROM B_Warehouse WHERE wType ='" + type + "' ORDER BY wSort ASC"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "wName", "wID", "", 1); }
/// <summary> /// 原材料品名下拉框 /// 2013-8-13 张 新增 /// 2014-3-17 增加全部选项 /// </summary> /// <param name="cmb"></param> public static void BindmfNameYCL(FZYK.WinCtrl.YKComboBox cmb) { string sqlStr = "SELECT mfName FROM B_MaterialFileView WHERE mcTag = '原材料' GROUP BY mfName ORDER BY MIN(mcID)"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "mfName", "mfName", "", 1); }
/// <summary> /// 获取标准下拉框 /// 2013-8-13 张 新增 /// 2014-3-17 增加全部选项 /// </summary> /// <param name="cmb"></param> public static void BindetName(FZYK.WinCtrl.YKComboBox cmb) { string sql = "SELECT etName FROM B_ExtraType"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sql); DevCommon.BindComboBox(cmb, dt, "etName", "etName", "", 1); }
/// <summary> /// 绑定到货去向下拉框 /// 2013-10-28 张 新增 /// 2014-3-17 增加全部选项 /// </summary> /// <param name="cmb"></param> public static void BindSendTo(FZYK.WinCtrl.YKComboBox cmb) { string sqlStr = "SELECT stName FROM C_SendTo"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "stName", "stName", "", 1); }
/// <summary> /// 绑定入库类型 /// 2014-3-17 增加全部选项 /// 2013-11-4 新增 /// </summary> /// <param name="cmb"></param> public static void BindStockInType(FZYK.WinCtrl.YKComboBox cmb) { string sqlstr = "SELECT * FROM dbo.B_InOutType WHERE iotType = '入库' ORDER BY iotSettle"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlstr); DevCommon.BindComboBox(cmb, dt, "iotName", "iotID", "", 1); }
public static void BindCompanyYCL(FZYK.WinCtrl.YKComboBox cmb) { string sql = " select DISTINCT Tag1 from dbo.B_Tag WHERE Tag = '原材料'"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sql); DevCommon.BindComboBox(cmb, dt, "Tag1", "Tag1", "", 3); }
/// <summary> /// 绑定物料分类 辅材 /// 2014-3-18 新增 /// </summary> /// <param name="cmb"></param> public static void BindmcNameFC(FZYK.WinCtrl.YKComboBox cmb) { string sqlStr = " SELECT mcName,mcID FROM B_MaterialClass WHERE mcTag ='辅材' AND mcTag1 = '辅材' ORDER BY mcNum ASC"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "mcName", "mcID", "", 4); }
/// <summary> /// 绑定物料档案分类 /// 修改 20150426 /// </summary> /// <param name="cmb"></param> public static void BindmcName(FZYK.WinCtrl.YKComboBox cmb, string tag, string tag1) { string sqlStr = "SELECT * FROM dbo.B_MaterialClass mc INNER JOIN dbo.B_Tag bt ON bt.Tag = mc.mcTag AND bt.TagX = mc.mcTag1" + " WHERE bt.Tag ='" + tag + "' AND bt.Tag1 = '" + tag1 + "' ORDER BY mcNum ASC"; DataTable dt = new DataTable(); dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DevCommon.BindComboBox(cmb, dt, "mcName", "mcID", "", 1); }
/// <summary> /// /// </summary> /// <param name="cmb">控件</param> public static void BindMS_SortName(FZYK.WinCtrl.YKComboBox cmb) { StringBuilder sbSql = new StringBuilder(); sbSql.Append("select * from DM_MeasureSort"); DataTable dt = FZYK.Com.YKDataClass.getDataTable(sbSql.ToString()); DataRow dr = dt.NewRow(); dr["MS_SortName"] = "[全部]"; dr["MS_ID"] = 0; dt.Rows.InsertAt(dr, 0); dt.AcceptChanges(); DevCommon.ComboBoxBindHavingBlank(cmb, dt, "MS_SortName", "MS_ID"); }