/// <summary>
/// 绑定管控代码
/// </summary>
/// <param name="locationkey"></param>
/// <param name="stepkey"></param>
private void BindContralPlan(string locationkey, string stepkey)
{
DataSet ds = spcEntity.GetSPControlGridData();
DataTable dt = new DataTable();
dt = ds.Tables[0].Clone();
string sql = string.Empty;
if (!string.IsNullOrEmpty(stepkey) && !string.IsNullOrEmpty(locationkey))
{
sql += string.Format("WERKS='{0}' AND STEP_KEY='{1}'", locationkey, stepkey);
}
else
{
if (!string.IsNullOrEmpty(locationkey))
{
sql += string.Format("WERKS='{0}'", locationkey);
}
if (!string.IsNullOrEmpty(stepkey))
{
sql += string.Format("STEP_KEY='{0}'", stepkey);
}
}
DataRow[] drs = ds.Tables[0].Select(string.Format("{0}", sql));
foreach (DataRow dr in drs)
{
dt.ImportRow(dr);
}
lueControlCode.Properties.DisplayMember = SPC_CONTROL_PLAN_FIELD.FIELD_CONTROLCODE;
lueControlCode.Properties.ValueMember = SPC_CONTROL_PLAN_FIELD.FIELD_CONTROLPLANID;
lueControlCode.Properties.DataSource = dt;
}
private void gvBind()
{
_dtCommon = null;
_dtCommon = _spcEntity.GetSPControlGridData().Tables[0];
}