/// <summary>
/// 主页面 厂家
/// </summary>
/// <param name="cmb"></param>
public static void LoadCmbVendor(ComboBoxEdit cmb)
{
DataTable dtVendor = GetSpecifiedVendor();
for (int i = 0; i < dtVendor.Rows.Count; i++)
{
ComboxData data = new ComboxData();
data.Text = dtVendor.Rows[i]["vend_nm"].ToString();
data.Value = dtVendor.Rows[i]["vend_code"].ToString();
cmb.Properties.Items.Add(data);
}
}
private void LoadCombobox()
{
try
{
DataTable dtReason = MetalMaskGlobal.GetMakerReason();
DataTable dtStoreLoc = MetalMaskGlobal.GetRegisterBinInfo();
DataTable dtMaker = MetalMaskGlobal.GetMakerVendor();
for (int i = 0; i < dtReason.Rows.Count; i++)
{
ComboxData data = new ComboxData();
data.Text = dtReason.Rows[i]["COMM_CODE_NM"].ToString();
data.Value = dtReason.Rows[i]["COMM_CODE"].ToString();
cmbReason.Properties.Items.Add(data);
}
for (int i = 0; i < dtStoreLoc.Rows.Count; i++)
{
cmbStore.Properties.Items.Add(dtStoreLoc.Rows[i]["Bin"].ToString());
}
for (int i = 0; i < dtMaker.Rows.Count; i++)
{
ComboxData data = new ComboxData();
data.Text = dtMaker.Rows[i]["vend_nm"].ToString();
data.Value = dtMaker.Rows[i]["vend_code"].ToString();
cmbMaker.Properties.Items.Add(data);
}
ComboxData dataOwer = new ComboxData();
dataOwer.Text = PaCSGlobal.LoginUserInfo.Vendername;
dataOwer.Value = PaCSGlobal.LoginUserInfo.Venderid;
cmbOwerVend.Properties.Items.Add(dataOwer);
if (!PaCSGlobal.LoginUserInfo.Venderid.Equals("C660"))
{
ComboxData dataOwer2 = new ComboxData();
dataOwer2.Text = "SSDP";
dataOwer2.Value = "C660";
cmbOwerVend.Properties.Items.Add(dataOwer2);
}
cmbOwerVend.SelectedIndex = 0;
}
catch (Exception LoadCombobox)
{
XtraMessageBox.Show(this, "System error[LoadCombobox]: " + LoadCombobox.Message);
}
}
/// <summary>
/// 制造原因
/// </summary>
/// <returns></returns>
public RepositoryItemComboBox cmbMakerReason()
{
RepositoryItemComboBox cmbReason = new RepositoryItemComboBox();
DataTable dtReason = GetMakerReason();
for (int i = 0; i < dtReason.Rows.Count; i++)
{
ComboxData data = new ComboxData();
data.Text = dtReason.Rows[i]["COMM_CODE_NM"].ToString();
data.Value = dtReason.Rows[i]["COMM_CODE"].ToString();
cmbReason.Items.Add(data);
}
cmbReason.ParseEditValue += new ConvertEditValueEventHandler(repositoryItemComboBox_ParseEditValue);
return(cmbReason);
}
/// <summary>
/// 废弃原因
/// </summary>
/// <returns></returns>
public RepositoryItemComboBox cmbDsuReason()
{
RepositoryItemComboBox cmbReason = new RepositoryItemComboBox();
string sqlReason = "SELECT COMM_CODE,COMM_CODE_NM||':'||COMM_CODE COMM_CODE_NM FROM PACSC_MD_COMM_CODE WHERE TYPE_CODE = 'DSU_RSN' and fct_code = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' ";
DataTable dtReason = OracleHelper.ExecuteDataTable(sqlReason);
for (int i = 0; i < dtReason.Rows.Count; i++)
{
ComboxData data = new ComboxData();
data.Text = dtReason.Rows[i]["COMM_CODE_NM"].ToString();
data.Value = dtReason.Rows[i]["COMM_CODE"].ToString();
cmbReason.Items.Add(data);
}
cmbReason.ParseEditValue += new ConvertEditValueEventHandler(repositoryItemComboBox_ParseEditValue);
return(cmbReason);
}
/// <summary>
/// 搬出厂家
/// </summary>
/// <returns></returns>
public RepositoryItemComboBox cmbVendor()
{
RepositoryItemComboBox cmbVendor = new RepositoryItemComboBox();
cmbVendor.TextEditStyle = TextEditStyles.DisableTextEditor;
DataTable dtVendor = GetSpecifiedVendor();
for (int i = 0; i < dtVendor.Rows.Count; i++)
{
ComboxData data = new ComboxData();
data.Text = dtVendor.Rows[i]["vend_nm"].ToString() + ":" + dtVendor.Rows[i]["vend_code"].ToString();
data.Value = dtVendor.Rows[i]["vend_code"].ToString();
cmbVendor.Items.Add(data);
}
cmbVendor.ParseEditValue += new ConvertEditValueEventHandler(repositoryItemComboBox_ParseEditValue);
return(cmbVendor);
}
public RepositoryItemComboBox cmbLine()
{
RepositoryItemComboBox cmbLine = new RepositoryItemComboBox();
cmbLine.TextEditStyle = TextEditStyles.DisableTextEditor;
DataTable dtLine = GetVendorLine(PaCSGlobal.LoginUserInfo.Venderid);
for (int i = 0; i < dtLine.Rows.Count; i++)
{
ComboxData data = new ComboxData();
data.Text = dtLine.Rows[i]["line_nm"].ToString();
data.Value = dtLine.Rows[i]["line_code"].ToString();
cmbLine.Items.Add(data);
}
cmbLine.ParseEditValue += new ConvertEditValueEventHandler(repositoryItemComboBox_ParseEditValue);
return(cmbLine);
}
public static void LoadCmbStatus(ComboBoxEdit cmb)
{
string sql = " select comm_code,comm_code_nm " +
" from pacsc_md_comm_code " +
" where type_code ='TOOL_STATUS' " +
" and grp_code = 'MB' " +
" and comm_code not in " +
" ( " +
" 'MBDIN', 'MBLIN', 'MBTIN', 'MBTOT' " +
" ) " +
" and fct_code = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' ";
DataTable dtStatus = OracleHelper.ExecuteDataTable(sql);
for (int i = 0; i < dtStatus.Rows.Count; i++)
{
ComboxData data = new ComboxData();
data.Text = dtStatus.Rows[i]["comm_code_nm"].ToString();
data.Value = dtStatus.Rows[i]["comm_code"].ToString();
cmb.Properties.Items.Add(data);
}
}
private void LoadCombobox()
{
try
{
string sqlReason = "SELECT COMM_CODE,COMM_CODE_NM FROM PACSC_MD_COMM_CODE WHERE TYPE_CODE = 'MAKE_RSN'";
string sqlStoreLoc = "select distinct(TOOL_BIN_CODE) storeloc from pacsm_rm_tool w where w.tool_gubun_code ='MM' and vend_loc_code = '" + PaCSGlobal.LoginUserInfo.Venderid + "' and status_code not in('MBNIN','MBBIN','MBCIN','MBTIN') ";///not in
string sqlMaker = "select distinct nvl(vend_code,'C660') vend_code,(select vend_nm_cn from pacsm_md_vend b where nvl(a.vend_code,'C660') = b.vend_code) vend_nm from gmes20_line a";
DataTable dtReason = OracleHelper.ExecuteDataTable(sqlReason);
DataTable dtStoreLoc = OracleHelper.ExecuteDataTable(sqlStoreLoc);
DataTable dtMaker = OracleHelper.ExecuteDataTable(sqlMaker);
for (int i = 0; i < dtReason.Rows.Count; i++)
{
ComboxData data = new ComboxData();
data.Text = dtReason.Rows[i]["COMM_CODE_NM"].ToString();
data.Value = dtReason.Rows[i]["COMM_CODE"].ToString();
cmbReason.Properties.Items.Add(data);
}
for (int i = 0; i < dtStoreLoc.Rows.Count; i++)
{
cmbStore.Properties.Items.Add(dtStoreLoc.Rows[i]["storeloc"].ToString());
}
for (int i = 0; i < dtMaker.Rows.Count; i++)
{
ComboxData data = new ComboxData();
data.Text = dtMaker.Rows[i]["vend_nm"].ToString();
data.Value = dtMaker.Rows[i]["vend_code"].ToString();
cmbMaker.Properties.Items.Add(data);
}
}
catch (Exception LoadCombobox)
{
XtraMessageBox.Show(this, "System error[LoadCombobox]: " + LoadCombobox.Message);
}
}
