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