/// <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;
}
