public t_StAndClient_compaTable FindAndClientCompaTableByObject(t_StAndClient_compaTable compaTable)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
t_StAndClient_compaTable tStAndClientCompaTable = null;
if (compaTable != null)
{
if (compaTable.Client_PN != null && compaTable.Client_cCusCode != null & compaTable.St_Type != null)
{
try
{
tStAndClientCompaTable = (from i in erp2008.t_StAndClient_compaTable where i.Client_PN == compaTable.Client_PN && i.Client_cCusCode == compaTable.Client_cCusCode && i.St_Type == compaTable.St_Type select i
).SingleOrDefault();
return(tStAndClientCompaTable);
}
catch (Exception)
{
return(tStAndClientCompaTable);
}
}
//if (compaTable.Client_PN != null)
//{
// tStAndClientCompaTable = (from i in erp2008.t_StAndClient_compaTable where i.Client_PN == compaTable.Client_PN select i
// ).SingleOrDefault();
//}
}
return(tStAndClientCompaTable);
}
}
public void CreateClientRequireTwo(t_labels label)
{
t_StAndClient_compaTable tStAndClientCompaTable = new t_StAndClient_compaTable();
tStAndClientCompaTable.Client_PN = label.pn;
tStAndClientCompaTable.Client_cCusCode = label.clientCode;
tStAndClientCompaTable.St_Type = label.type;
tStAndClientCompaTable = clientFreeNameDao.FindAndClientCompaTableByObject(tStAndClientCompaTable);
label.ClientRequireTwo = tStAndClientCompaTable.Client_TypeName;
}
