/// <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));
}
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));
}
