public long Insert_Imsn1(Imsn request)
{
long Result = -1;
//int intResult = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
Result = db.Update <Imgr2>(
new
{
UserDefine1 = request.SerialNos
},
p => p.TrxNo == int.Parse(request.Imgr2TrxNo) && p.LineItemNo == int.Parse(request.ReceiptLineItemNo)
);
//string[] sns = request.SerialNos.Split(',');
//foreach (string sn in sns)
//{
// intResult = db.Scalar<int>(
// "Select count(*) From Imsn1 Where ReceiptNoteNo={0} And ReceiptLineItemNo={1} And SerialNo={2}",
// request.ReceiptNoteNo, request.ReceiptLineItemNo, sn
// );
// if (intResult < 1)
// {
// db.Insert(new Imsn1 { ReceiptNoteNo = request.ReceiptNoteNo, ReceiptLineItemNo = request.ReceiptLineItemNo, SerialNo = sn });
// Result = 1;
// }
//}
}
}
catch { throw; }
return(Result);
}
public long Insert_Imsn1(Imsn request)
{
long Result = -1;
int intResult = -1;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
if (request.imsn1.IssueNoteNo.Length > 0)
{
intResult = db.Scalar <int>(
"Select count(*) From Imsn1 Where IssueNoteNo={0} And IssueLineItemNo={1} And SerialNo={2}",
request.imsn1.IssueNoteNo, request.imsn1.IssueLineItemNo, request.imsn1.SerialNo
);
if (intResult < 1)
{
db.Insert(new Imsn1 {
IssueNoteNo = request.imsn1.IssueNoteNo, IssueLineItemNo = request.imsn1.IssueLineItemNo, SerialNo = request.imsn1.SerialNo
});
Result = 1;
}
}
else
{
intResult = db.Scalar <int>(
"Select count(*) From Imsn1 Where ReceiptNoteNo={0} And ReceiptLineItemNo={1} And SerialNo={2}",
request.imsn1.ReceiptNoteNo, request.imsn1.ReceiptLineItemNo, request.imsn1.SerialNo
);
if (intResult < 1)
{
db.Insert(new Imsn1 {
ReceiptNoteNo = request.imsn1.ReceiptNoteNo, ReceiptLineItemNo = request.imsn1.ReceiptLineItemNo, SerialNo = request.imsn1.SerialNo
});
Result = 1;
}
}
}
}
catch { throw; }
return(Result);
}
public List <Imsn1> Get_Imsn1_List(Imsn request)
{
List <Imsn1> Result = null;
try
{
using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
{
Result = db.Select <Imsn1>(
"Select * From Imsn1 " +
"Left Join Imgi1 On Imsn1.IssueNoteNo = Imgi1.GoodsIssueNoteNo " +
"Left Join Imgi2 On Imgi1.TrxNo = Imgi2.TrxNo " +
"Where Imsn1.IssueLineItemNo = Imgi2.LineItemNo And Imgi1.GoodsIssueNoteNo={0}",
request.IssueNoteNo
);
}
}
catch { throw; }
return(Result);
}