public int InsertLabel(List <t_labels> lists)
{
int result = 0;
using (var scope = new TransactionScope(TransactionScopeOption.Required))
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
try
{
foreach (t_labels labels in lists)
{
erp2008.t_labels.Add(labels);
if (erp2008.SaveChanges() <= 0)
{
throw new Exception();
}
}
scope.Complete();
result = 1;
}
catch (Exception)
{
scope.Dispose();
result = 0;
}
}
}
return(result);
}
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 int InsertLabel(Entity.t_labels label)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
erp2008.t_labels.Add(label);
return(erp2008.SaveChanges());
}
}
public List <t_labels> FindLabelsesByCode(string code)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
return((from tabel in erp2008.t_labels where tabel.code == code select tabel
).ToList());
}
}
public List <SO_SODetails> FindSoDetailsByCsoAndCinvstd(string cSoCode, string cinvstd)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
List <SO_SODetails> details = null;
details = (from detail in erp2008.SO_SODetails where detail.cSOCode == cSoCode && detail.cInvCode == cinvstd select detail
).ToList();
return(details);
}
}
public List <SO_SODetails> FindSoDetailsByDetailses(SO_SODetails soDetails)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
List <SO_SODetails> details = null;
details = (from detail in erp2008.SO_SODetails select detail
).ToList();
return(details);
}
}
public long ExecPrSaveSerialNumber(System.Data.SqlClient.SqlParameter[] parameters)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
SqlParameter parameter = new SqlParameter("@oldNumber", SqlDbType.BigInt);
parameter.Direction = ParameterDirection.Output;
erp2008.Database.ExecuteSqlCommand("EXEC Pr_SaveSerialNumber @clientCode,@number,@oldNumber output", parameters[0], parameters[1], parameter);
return((long)parameter.Value);
}
}
public Entity.SA_Packs FindSaPacksBySaPacks(Entity.SA_Packs saPacks)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
SA_Packs saPack = null;
saPack = (from pack in erp2008.SA_Packs where pack.cPCode == saPacks.cPCode select pack
).SingleOrDefault();
return(saPack);
}
}
public Entity.SA_Packs FinSaPacksBysaCode(string saCode)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
SA_Packs saPacks = null;
saPacks = (from saPack in erp2008.SA_Packs where saPack.cPCode == saCode select saPack
).SingleOrDefault();
return(saPacks);
}
}
public Entity.SO_SOMain FindSoMainByCsoCode(string csoCode)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
SO_SOMain soMain = null;
soMain =
(from main in erp2008.SO_SOMain where main.cSOCode == csoCode select main).SingleOrDefault();
return(soMain);
}
}
public SO_SODetails FindSoDetailsById(int id)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
SO_SODetails details = null;
details = (from de in erp2008.SO_SODetails
where de.AutoID == id
select de).SingleOrDefault();
return(details);
}
}
public DateTime GetServerDateTime()
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
var now = erp2008.Database.SqlQuery <DateTime?>("SELECT GetDate()").First();
if (now == null)
{
now = new DateTime(1900, 1, 1, 0, 0, 0);
}
return(now.Value);
}
}
public t_opencardpack FindOpencardpackByCode(string code)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
t_opencardpack card = new t_opencardpack();
card =
(from opencard in erp2008.t_opencardpack
where opencard.Fbarcode == code
select opencard).SingleOrDefault();
return(card);
}
}
public Entity.SO_SODetails FindSoDetailsBySoDetails(Entity.SO_SODetails soDetails)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
//有时候客户一个订单下单分几次下一个型号，此处用来提出明细单的说明 18-6-23 lee
//一般一个订单号多个型号说明应该是一样的，所以直接拿第一个的说明就好了 18-6-23 lee
SO_SODetails details = null;
details = (from de in erp2008.SO_SODetails
where de.cSOCode == soDetails.cSOCode && de.cInvCode == soDetails.cInvCode
select de).ToList()[0];
return(details);
}
}
public Entity.t_opencardpack FindOpencardpackByCode(Entity.t_opencardpack opencardpack)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
t_opencardpack card = new t_opencardpack();
card =
(from opencard in erp2008.t_opencardpack
//join b in erp2008.b_Inventory on opencard.FProductNo equals b.cInvCode
//join sod in erp2008.SO_SODetails on opencard.cSOCode equals sod.cSOCode
//join som in erp2008.SO_SOMain on opencard.cSOCode equals som.cSOCode
where opencard.Fbarcode == opencardpack.Fbarcode
select opencard).SingleOrDefault();
return(card);
}
}
public Label_template FindLabelTemplatesById(int id)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
Label_template labelTemplates = null;
if (id != 0)
{
labelTemplates =
(from labelTemplate in erp2008.Label_template
where labelTemplate.Label_NO == id
select labelTemplate
).SingleOrDefault();
}
return(labelTemplates);
}
}
public double FindSoDetailsQtyByCsoAndCinvstd(string cSoCode, string cinvstd)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
double sum = 0.0;
var query = (from detail in erp2008.SO_SODetails
where detail.cSOCode == cSoCode && detail.cInvCode == cinvstd
select detail.iQuantity
).Sum();
if (query != null)
{
sum = (double)query;
}
return(sum);
}
}
public b_User LongIn(b_User user)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
CustomMD5 custom = new CustomMD5();
string pwd = custom.getpwd(user.cPassword);
b_User query = (from u in erp2008.b_User where u.cUser_Id == user.cUser_Id && u.cPassword == pwd select u).SingleOrDefault();
if (query != null)
{
return(query);
}
else
{
return(null);
}
}
}
public List <t_labels> FindLabelsesByOrderCodeTypeCode(string orderCode, string typeCode)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
List <t_labels> labels = null;
try
{
labels = (from l in erp2008.t_labels where l.orderCode == orderCode && l.typeCode == typeCode select l
).ToList();
}
catch (Exception)
{
labels = null;
}
return(labels);
}
}
public List <Entity.Label_template> FindLabelTemplatesByClientCode(string clientCode)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
List <Label_template> labelTemplates = null;
if (string.IsNullOrEmpty(clientCode))
{
labelTemplates = (from labelTemplate in erp2008.Label_template where labelTemplate.cCusCode == "STANDARD" select labelTemplate
).ToList();
}
//labelTemplates = (from labelTemplate in erp2008.Label_template where labelTemplate.cCusCode==clientCode || labelTemplate.cCusCode=="Semtech" select labelTemplate
// ).ToList();
string[] clientCodes = new string[] { clientCode, "STANDARD" };
labelTemplates = (from labelTemplate in erp2008.Label_template where clientCodes.Contains(labelTemplate.cCusCode) select labelTemplate
).ToList();
//labelTemplates = (from labelTemplate in erp2008.Label_template where labelTemplate.cCusCode == clientCode || labelTemplate.cCusCode == "STANDARD" select labelTemplate
// ).ToList();
return(labelTemplates);
}
}
public int FindOrderSumQty(string orderCode, string typeCode)
{
using (ERP2008Entities erp2008 = new ERP2008Entities())
{
int sum = 0;
try
{
var query =
(from labels in erp2008.t_labels
where labels.orderCode == orderCode && labels.typeCode == typeCode
select labels.qty
).Sum();
if (query != null)
{
sum = (int)query;
}
}
catch (Exception)
{
sum = 0;
}
return(sum);
}
}