/// <summary> /// 绑定发料状态 /// </summary> /// <param name="cmb"></param> public static void BindOverState(FZYK.WinCtrl.YKComboBox cmb) { cmb.Items.Add(""); cmb.Items.Add("未发料"); cmb.Items.Add("发料中"); cmb.Items.Add("发料完成"); }
public static void BindDevicebxGuZhangMemo(FZYK.WinCtrl.YKComboBox cmb) { string sqlStr = "SELECT value, sort FROM B_CommonForCombox WHERE valid=1 AND setName='D_bxGuZhangMemo'"; DataTable dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); cmb.BindData(dt, "value", "value", "sort"); }
/// <summary> /// 绑定入库状态 /// </summary> /// <param name="cmb"></param> public static void BindInState(FZYK.WinCtrl.YKComboBox cmb) { cmb.Items.Add("[全部]"); cmb.Items.Add("未入库"); cmb.Items.Add("部分入库"); cmb.Items.Add("入库完毕"); }
/// <summary> /// 绑定螺栓塔型数据中防松罩损耗计算方式下拉框 /// 添加:天生 2012年9月18日 16:33:49 /// </summary> /// <param name="cmb"></param> public static void BindFSZLossWay(FZYK.WinCtrl.YKComboBox cmb) { string sqlStr = " SELECT bcfc.setMemo, bcfc.[value], bcfc.sort FROM B_CommonForCombox bcfc WHERE bcfc.valid=1 AND bcfc.setName='F_FSZLossWay'"; DataTable dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); cmb.BindData(dt, "setMemo", "value", "sort"); }
public static void BindFYTaskMainState(FZYK.WinCtrl.YKComboBox cmb) { DataTable dt = new DataTable(); dt.Columns.Add("fPTState", typeof(string)); dt.Columns.Add("sort", typeof(int)); DataRow r1 = dt.NewRow(); r1["fPTState"] = ""; r1["sort"] = 0; DataRow r2 = dt.NewRow(); r2["fPTState"] = "未下单"; r2["sort"] = 1; DataRow r3 = dt.NewRow(); r3["fPTState"] = "部分下单"; r3["sort"] = 2; DataRow r4 = dt.NewRow(); r4["fPTState"] = "下单完"; r4["sort"] = 3; DataRow r5 = dt.NewRow(); r5["fPTState"] = "标识下单完"; r5["sort"] = 4; dt.Rows.Add(r1); dt.Rows.Add(r2); dt.Rows.Add(r3); dt.Rows.Add(r4); dt.Rows.Add(r5); dt.AcceptChanges(); cmb.BindData(dt, "fPTState", "fPTState", "sort"); }
public static void BindDeviceWXType(FZYK.WinCtrl.YKComboBox cmb) { cmb.Items.Clear(); cmb.Items.Add(""); cmb.Items.Add("厂内维修"); cmb.Items.Add("厂外维修"); }
/// <summary> /// 绑定合同类别 /// 2013-8-13 张 新增 /// </summary> /// <param name="cmb"></param> public static void BindContractClass(FZYK.WinCtrl.YKComboBox cmb) { cmb.Items.Add("[全部]"); cmb.Items.Add("正常"); cmb.Items.Add("增补"); cmb.Items.Add("重签"); }
/// <summary> /// 使用状态 /// </summary> /// <param name="cmb"></param> public static void BindRunningState(FZYK.WinCtrl.YKComboBox cmb) { string sqlstr = "SELECT distinct value,sort FROM B_CommonForCombox WHERE setName='D_DeviceRunningState'"; DataTable dt = FZYK.Com.YKDataClass.getDataTable(sqlstr); cmb.BindData(dt, "value", "value", "sort"); }
/// <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-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); }
/// <summary> /// 绑定审批状态 /// 2013-12-9 张镇波 新增 /// 2014-3-17 增加全部选项 /// </summary> /// <param name="cmb"></param> public static void BindApproveState(FZYK.WinCtrl.YKComboBox cmb) { cmb.Items.Add(""); cmb.Items.Add("未提交"); cmb.Items.Add("审批中"); cmb.Items.Add("审批通过"); cmb.Items.Add("审批未通过"); }
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> /// 获取标准下拉框 /// 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> /// 绑定年 /// </summary> /// <param name="cmb"></param> public static void BindMyMonth(FZYK.WinCtrl.YKComboBox cmb) { for (int i = 1; i <= 12; i++) { cmb.Items.Add(i); } cmb.Text = ""; }
/// <summary> /// 绑定采购部处理意见 /// </summary> /// <param name="cmb"></param> public static void BindDealOpinion(FZYK.WinCtrl.YKComboBox cmb) { cmb.Items.Add("让步接收"); cmb.Items.Add("降级"); cmb.Items.Add("退货"); cmb.Items.Add("按废钢处理"); cmb.Items.Add("第三方复检合格"); }
/// <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-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-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> /// 绑定标准 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> /// 绑定仓库 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> /// 绑定出库类型 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> /// 绑定年 /// </summary> /// <param name="cmb"></param> public static void BindMyYear(FZYK.WinCtrl.YKComboBox cmb) { for (int i = 2012; i <= DateTime.Now.Year; i++) { cmb.Items.Add(i); } cmb.Text = ""; }
/// <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-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> /// 绑定物料档案分类 /// 修改 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); }
public static void BindDevicerkdSuppliers(FZYK.WinCtrl.YKComboBox cmb) { string sqlStr = "SELECT DISTINCT rkdSuppliers FROM D_DeviceRuKuDetail ORDER BY rkdSuppliers"; DataTable dt = FZYK.Com.YKDataClass.getDataTable(sqlStr); DataRow dr = dt.NewRow(); dr["rkdSuppliers"] = ""; dt.Rows.InsertAt(dr, 0); dt.AcceptChanges(); cmb.BindData(dt, "rkdSuppliers", "rkdSuppliers", ""); }
/// <summary> /// 根据key找B_CommonForCombox表中值绑定下拉框 /// 修改时间:2012年7月25日 09:06:11 修改人:CXP 修改内容:增加sort排序 /// 修改时间:2012年9月2日 14:06:11 修改人:CXP 修改内容:修改sort排序 /// </summary> /// <param name="cmb">下拉框</param> /// <param name="key">检索关键字</param> public static void BindCommonForCombox(FZYK.WinCtrl.YKComboBox cmb, string key) { string sqlstr = "SELECT cfc.value,sort FROM B_CommonForCombox cfc WHERE cfc.valid=1 AND cfc.setName='" + key + "' order by sort"; DataTable dt = FZYK.Com.YKDataClass.getDataTable(sqlstr); DataRow dr = dt.NewRow(); dr["value"] = ""; dt.Rows.InsertAt(dr, 0); dt.AcceptChanges(); cmb.BindData(dt, "value", "value", "sort"); cmb.SelectedIndex = 0; }
/// <summary> /// 绑定车间(CXP2012-09-15 改ValueMemer为wsID) /// </summary> /// <param name="cmb"></param> public static void BindWorkShop(FZYK.WinCtrl.YKComboBox cmb) { string sqlstr = " SELECT wsID,wsName FROM B_WorkShop "; DataTable dt = FZYK.Com.YKDataClass.getDataTable(sqlstr); DataRow dr = dt.NewRow(); dr["wsName"] = ""; dt.Rows.InsertAt(dr, 0); dt.AcceptChanges(); cmb.BindData(dt, "wsName", "wsID", ""); cmb.SelectedIndex = 0; }