/// <summary>
/// 是否这个计划已经建立进料检验
///得到这个 SAMPLEName
/// 核查这个 料号是否有建立判断
///条件成立创建计划
/// </summary>
/// <param name="recieve"></param>
/// <param name="general"></param>
/// <param name="msg"></param>
/// <returns></returns>
public bool InsertRecieve(DOCReceive recieve, ReceiveGeneral general, out string msg)
{
Console.WriteLine("gate InsertRecieve");
msg = "Create failed";
DataTable dt = gate.DbHelper.ExecuteStoredProcedure("QC02_IsCan_CreateReceive",
new string[] { "UserID", "PlanID", "LotNo", "SampleName" },
new object[] { recieve.UserID, recieve.GatePlanID, recieve.LOT_NO, recieve.SampleName }).Tables[0];
if (dt.Rows.Count < 0)
{
return(false);
}
Console.WriteLine(dt.Rows.Count);
msg = dt.Rows[0]["MSG"].ToString();
Console.WriteLine(msg);
if (!string.IsNullOrEmpty(msg))
{
return(false);
}
string _sampleName = dt.Rows[0]["SampleName"].ToString();
string _versionID = dt.Rows[0]["VersionID"].ToString();
Console.WriteLine("VoucherID:" + recieve.VoucherID);
recieve.UserID = DB.User;
recieve.SampleName = _sampleName;
recieve.GradeVersion = _versionID;
// recieve.SheetDate = System.DateTime.Now;
Console.WriteLine(JsonConvert.SerializeObject(recieve));
return(db.Save(recieve));
}
/// <summary>
/// 建立进料检验
/// </summary>
public bool InsertRecieve(DOCReceive recieve, ReceiveGeneral general, out string msg)
{
try
{
Console.WriteLine("--MIGOReceive InsertRecieve()--" + DateTime.Now.ToString());
msg = "Create failed";
//根据物料，样品查找等级版本
DataTable dt = gate.DbHelper.ExecuteStoredProcedure("MMJY_GetVersionID",
new string[] { "UserID", "LotNo", "SampleName" },
new object[] { DB.User, general.LOT_NO, general.SampleName }).Tables[0];
if (dt.Rows.Count < 0)
{
return(false);
}
Console.WriteLine(dt.Rows.Count);
//
msg = dt.Rows[0]["MSG"].ToString();
Console.WriteLine(msg);
if (!string.IsNullOrEmpty(msg))
{
return(false);
}
string _VersionID = dt.Rows[0]["VersionID"].ToString();
//CreateVoucherID
string _VoucherID = CreateVoucherID(general.SampleName, DateTime.Now);
Console.WriteLine("VoucherID:" + _VoucherID);
if (string.IsNullOrEmpty(_VoucherID))
{
msg = "CreateVoucherID failed";
return(false);
}
general.VoucherID = _VoucherID;
general.UserID = DB.User;
general.GradeVersion = _VersionID;
general.SheetDate = DateTime.Now;
general.Grade = "";
general.Stamp = DateTime.Now;
general.DateOfSample = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
// general.State = "1";
Console.WriteLine(JsonConvert.SerializeObject(general));
return(db.Save(general));
}
catch (Exception e)
{
log.Error(e);
throw new Exception(e.Message);
}
}
public void butAddGatePlan_Click(object sender, EventArgs e)
{
DOCReceive receive = new DOCReceive();
ReceiveGeneral receiveGeneral = new ReceiveGeneral();
string msg = string.Empty;
if (string.IsNullOrEmpty(_GatePlanFrm.SampleName))
{
WriteTips(6, "SampleName is null", false);
return;
}
DataRow row = _GatePlanFrm.GetSelectPlan;
if (row != null)
{
receive.GatePlanID = row["VoucherID"].ToString();
receive.Grade = "--";
receive.State = "1";
receive.SampleName = _GatePlanFrm.SampleName;
receive.LOT_NO = _GatePlanFrm.LotNo;
receive.TableName = row["TableName"].ToString();
if (string.IsNullOrEmpty(row["FirstTime"].ToString()))
{
WriteTips(6, "The Truck didn't come in", false);
return;
}
receive.SheetDate = Convert.ToDateTime(row["FirstTime"].ToString());
receive.Remark = string.Format("{0}|{1}", row["VehicleNO"].ToString(), row["StorageNO"].ToString());
if (biz.InsertReceive(receive, receiveGeneral, out msg))
{
if (!string.IsNullOrEmpty(msg))
{
WriteTips(6, msg, false);
}
else
{
QueryGatePlan();
}
}
else
{
WriteTips(6, msg, false);
}
}
else
{
WriteTips(6, "Please select row", false);
}
}
/// <summary>
/// 一般车辆 物料无PTA ,判断是否有等级规则
/// 多次过磅车辆 煤 EG 等
/// 用户自定义的创建 原辅料的检查单，基本信息在 RecieveGeneral
/// table
/// </summary>
/// <param name="Receive"></param>
/// <param name="Doc"></param>
/// <param name="msg"></param>
/// <returns></returns>
public bool InsertReceive(DOCReceive receive, ReceiveGeneral general, out string msg)
{
string TableName = "MIGO";
if (!string.IsNullOrEmpty(receive.TableName))
{
Console.WriteLine("receive" + receive.TableName);
string voucherid = CreateVoucherIDByReceive();
receive.VoucherID = voucherid;
Console.WriteLine(receive.VoucherID + receive.TableName);
TableName = receive.TableName;
}
IReceiveOperation receiveDAL = Recieve_Facotry.CreateRecive(TableName);
ReceiveOperation taskOperation = new ReceiveOperation(receiveDAL);
return(taskOperation.InsertRecieve(receive, general, out msg));
}
/// <summary>
/// 创建混样的检验批
/// </summary>
/// <param name="wrgg"></param>
/// <returns></returns>
public bool CreateWRGGProfile(ReceiveMIGODraf[] wrgs, ReceiveGeneral general, out string msg)
{
msg = string.Empty;
try
{
Console.WriteLine("--MIGOReceive InsertRecieve()--" + DateTime.Now.ToString());
#region Find VersionID base On Material
DataTable dt = gate.DbHelper.ExecuteStoredProcedure("MMJY_GetVersionID",
new string[] { "UserID", "LotNo", "SampleName" },
new object[] { DB.User, general.LOT_NO, general.SampleName }).Tables[0];
if (dt.Rows.Count < 0)
{
return(false);
}
Console.WriteLine(dt.Rows.Count);
msg = dt.Rows[0]["MSG"].ToString();
Console.WriteLine(msg);
if (!string.IsNullOrEmpty(msg))
{
return(false);
}
string _VersionID = dt.Rows[0]["VersionID"].ToString();
#endregion
string _VoucherID = CreateVoucherID(general.SampleName, DateTime.Now);
Console.WriteLine("VoucherID:" + _VoucherID);
if (string.IsNullOrEmpty(_VoucherID))
{
msg = "CreateVoucherID failed";
return(false);
}
Console.WriteLine("VoucherID:" + _VoucherID);
if (string.IsNullOrEmpty(_VoucherID))
{
msg = "CreateVoucherID failed";
return(false);
}
general.VoucherID = _VoucherID;
general.UserID = DB.User;
general.GradeVersion = _VersionID;
// general.SheetDate = DateTime.Now;
// general.Grade = "";
// general.State = "1";
general.Stamp = DateTime.Now;
Console.WriteLine(JsonConvert.SerializeObject(general));
if (db.Save(general))
{
int i = 0;
foreach (ReceiveMIGODraf wrg in wrgs)
{
ReceiveMIGODraf wrgg = new ReceiveMIGODraf();
wrgg.VoucherID = wrg.VoucherID;
wrgg.RVoucherID = _VoucherID;
wrgg.UserId = DB.User;
wrgg.Stamp = System.DateTime.Now;
db.Save(wrgg);
i++;
}
if (i == wrgs.Length)
{
return(true);
}
else
{
msg = "Save failed";
return(false);
}
}
else
{
msg = "save ReceiveGeneral failed";
return(false);
}
}
catch (Exception e)
{
log.Error(e);
throw new Exception(e.Message);
}
}
/// <summary>
/// 根据现在的申请单接收 并创建 原辅料的检验批
/// </summary>
/// <param name="wrgs"></param>
/// <param name="general"></param>
/// <param name="msg"></param>
/// <returns></returns>
public bool CreateWRGGProfile(ReceiveMIGODraf[] wrgs, ReceiveGeneral general, out string msg)
{
return(proxy.CreateWRGGProfile(wrgs, general, out msg));
}
public bool InsertReceive(DOCReceive receive, ReceiveGeneral general, out string msg)
{
return(proxy.InsertReceive(receive, general, out msg));
}
public bool InsertRecieve(DOCReceive recieve, ReceiveGeneral general, out string msg)
{
return(m_ReceiveOperation.InsertRecieve(recieve, general, out msg));
}
void butReceive_Click(object sender, EventArgs e)
{
string[] strs = _SerchPlanView.dtSelectBarCodes4Query;
rawFrm.SampleDes = _SerchPlanView.SampleDes;
rawFrm.SampleName = _SerchPlanView.RSampleName;
rawFrm.LotNO = _SerchPlanView.RLotNO;
rawFrm.GradeVersion = GetGradeVersion(rawFrm.LotNO, rawFrm.SampleName);
#region Recive by Isaac 2018-11-29
//Create by Isaac EBELN, EBELP, Quantity 2018-11-29
rawFrm.Quantity = _SerchPlanView.Quantity;
rawFrm.EBELN = _SerchPlanView.EBELN;
rawFrm.EBELP = _SerchPlanView.EBELP;
rawFrm.GR_NO = _SerchPlanView.GR_NO;
rawFrm.ReceiveNum = _SerchPlanView.ReceiveNum;
rawFrm.GR_Unit = _SerchPlanView.GR_Unit;
rawFrm.Vendor = _SerchPlanView.Vendor;
#endregion
rawFrm.ShowDialog();
if (rawFrm.RValue)
{
ReceiveGeneral general = new ReceiveGeneral();
general.SampleName = rawFrm.SampleName;
general.LOT_NO = rawFrm.LotNO;
#region Create By Isaac
//Creat by IS 2018-11-29
general.SampleQuantity = rawFrm.ReceiveNum;
general.GradeVersion = rawFrm.GradeVersion;
general.GR_NO = rawFrm.GR_NO;
general.SheetDate = rawFrm.SheetDate;
general.GR_Unit = rawFrm.GR_Unit;
general.Vendor = rawFrm.Vendor;
general.Quatity = rawFrm.Quantity;
general.EBELN = rawFrm.EBELN;
general.EBELP = rawFrm.EBELP;
general.DateOfSample = rawFrm.DateOfSample;
#endregion
general.State = "1";
general.Grade = "";
ReceiveMIGODraf[] drfs = new ReceiveMIGODraf[strs.Length];
int i = 0;
foreach (string str in strs)
{
ReceiveMIGODraf draf = new ReceiveMIGODraf();
draf.VoucherID = str;
drfs[i] = draf;
i++;
}
string msg = string.Empty;
if (!biz.CreateWRGGProfile(drfs, general, out msg))
{
WriteTips(8, msg, false);
}
Query();
rawFrm.ResetForm();
}
}
public bool CreateWRGGProfile(ReceiveMIGODraf[] wrgs, ReceiveGeneral general, out string msg)
{
MIGOReceive receive = new MIGOReceive();
return(receive.CreateWRGGProfile(wrgs, general, out msg));
}
