public static bool SetOpVerData(Sys_Customer customerSrNo, string partNo, string cusVer, ComboBoxEx OpVerCombobox)
{
try
{
//IList<Com_PEMain> comPEMain = session.QueryOver<Com_PEMain>()
// .Where(x => x.sysCustomer == customerSrNo)
// .Where(x => x.partName == partNo)
// .Where(x => x.customerVer == cusVer)
// .List<Com_PEMain>();
IList <Com_PEMain> comPEMain1 = new List <Com_PEMain>();
CaxSQL.GetListCom_PEMain(customerSrNo, partNo, cusVer, out comPEMain1);
//CusVerCombobox.DisplayMember = "customerVer";
//CusVerCombobox.ValueMember = "peSrNo";
foreach (Com_PEMain i in comPEMain1)
{
if (OpVerCombobox.Items.Contains(i.opVer))
{
continue;
}
OpVerCombobox.Items.Add(i.opVer);
}
//CusVerCombobox.Items.Add(comPEMain);
}
catch (System.Exception ex)
{
return(false);
}
return(true);
}
public static bool SetPartNoData(Sys_Customer customerSrNo, ComboBoxEx PartNoCombobox)
{
try
{
//MessageBox.Show(customerSrNo.customerSrNo.ToString());
//IList<Com_PEMain> comPEMain = session.QueryOver<Com_PEMain>()
// .Where(x => x.sysCustomer == customerSrNo)
// .List<Com_PEMain>();
IList <Com_PEMain> comPEMain1 = new List <Com_PEMain>();
CaxSQL.GetListCom_PEMain(customerSrNo, out comPEMain1);
foreach (Com_PEMain i in comPEMain1)
{
if (PartNoCombobox.Items.Contains(i.partName))
{
continue;
}
PartNoCombobox.Items.Add(i.partName);
}
}
catch (System.Exception ex)
{
return(false);
}
return(true);
}
public static bool SetCusVerData(Sys_Customer customerSrNo, string partNo, ComboBoxEx CusVerCombobox)
{
try
{
IList <Com_PEMain> comPEMain = session.QueryOver <Com_PEMain>()
.Where(x => x.sysCustomer == customerSrNo)
.Where(x => x.partName == partNo)
.List <Com_PEMain>();
//CusVerCombobox.DisplayMember = "customerVer";
//CusVerCombobox.ValueMember = "peSrNo";
foreach (Com_PEMain i in comPEMain)
{
if (CusVerCombobox.Items.Contains(i.customerVer))
{
continue;
}
CusVerCombobox.Items.Add(i.customerVer);
}
//CusVerCombobox.Items.Add(comPEMain);
}
catch (System.Exception ex)
{
return(false);
}
return(true);
}
public static bool SetPartNoData(Sys_Customer SysCustomer, ComboBoxEx PartNoCombo)
{
try
{
//MessageBox.Show(SysCustomer.customerSrNo.ToString());
IList <Com_PEMain> comPEMain = session.QueryOver <Com_PEMain>()
.Where(x => x.sysCustomer == SysCustomer)
.List <Com_PEMain>();
foreach (Com_PEMain i in comPEMain)
{
if (PartNoCombo.Items.Contains(i.partName))
{
continue;
}
PartNoCombo.Items.Add(i.partName);
}
}
catch (System.Exception ex)
{
return(false);
}
return(true);
}
public Sys_Customer GetUser(string userName)
{
Sys_Customer user = null;
SqlParameter parm = new SqlParameter(PARM_ITEM_ID, SqlDbType.VarChar, 50);
parm.Value = userName;
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, SQL_SELECT_ITEM, parm))
{
if (rdr.Read())
{
//此行性能有损耗
user = SqlDataReaderToModel <Sys_Customer> .DoTransferType(rdr);
}
}
return(user);
}
public static Common.Business.Sys_Customer Fetch(Sys_Customer data)
{
Common.Business.Sys_Customer item = (Common.Business.Sys_Customer)Activator.CreateInstance(typeof(Common.Business.Sys_Customer));
//using (ObjectFactory.BypassPropertyChecks(item))
{
item.CustCode = data.CustCode;
item.CustName = data.CustName;
item.CustGrpCode = data.CustGrpCode;
item.OneTimeX = data.OneTimeX;
item.RelPartyX = data.RelPartyX;
item.IsDelete = data.IsDelete;
item.CreatedUser = data.CreatedUser;
item.CreatedDate = data.CreatedDate;
item.ChangedUser = data.ChangedUser;
item.ChangedDate = data.ChangedDate;
}
ObjectFactory.MarkAsChild(item);
ObjectFactory.MarkOld(item);
return(item);
}
public static bool SetPEPanelData(Sys_Customer customerSrNo, string partNo, string cusVer, string opVer, ref GridPanel PEPanel)
{
try
{
Com_PEMain comPEMain = session.QueryOver <Com_PEMain>()
.Where(x => x.sysCustomer == customerSrNo)
.Where(x => x.partName == partNo)
.Where(x => x.customerVer == cusVer)
.Where(x => x.opVer == opVer)
.SingleOrDefault <Com_PEMain>();
#region 插入Panel
object[] o = new object[] { false, "PFD", cusVer, opVer
, string.Format("{0}_{1}_{2}資料夾"
, partNo
, comPEMain.customerVer
, comPEMain.opVer) };
PEPanel.Rows.Add(new GridRow(o));
PEPanel.GetCell(0, 0).Value = false;
#region 判斷所有製程是否都有上傳MEMain，如果有上傳才顯示Control Plan
IList <Com_PartOperation> listComPartOperation = session.QueryOver <Com_PartOperation>()
.Where(x => x.comPEMain == comPEMain).List <Com_PartOperation>();
bool IsComplete = true;
foreach (Com_PartOperation i in listComPartOperation)
{
IList <Com_MEMain> comMEMain = session.QueryOver <Com_MEMain>()
.Where(x => x.comPartOperation == i).List <Com_MEMain>();
if (comMEMain.Count > 0)
{
continue;
}
else
{
IsComplete = false;
break;
}
}
if (IsComplete)
{
o = new object[] { false, "Control Plan", cusVer, opVer
, string.Format("{0}_{1}_{2}資料夾"
, partNo
, comPEMain.customerVer
, comPEMain.opVer) };
PEPanel.Rows.Add(new GridRow(o));
PEPanel.GetCell(1, 0).Value = false;
}
#endregion
#endregion
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
return(true);
}