void gridView1_DoubleClick(object sender, EventArgs e)
{
int rowCount = gridView1.SelectedRowsCount;
if (rowCount != 1)
{
return;
}
Dictionary <string, string> paramenters = new Dictionary <string, string>();
DataRow row = gridView1.GetDataRow(gridView1.GetSelectedRows()[0]);
foreach (DataColumn c in row.Table.Columns)
{
paramenters.Add(c.ColumnName, row[c.ColumnName] == null ? "" : row[c.ColumnName].ToString());
}
if (eventShowDetails != null)
{
GetPlan = new DOCPlan
{
VoucherID = paramenters["VoucherID"],
SampleName = paramenters["SampleName"],
//Purpose = paramenters["Purpose"],
ProdDate = Convert.ToDateTime(paramenters["ProdDate"]),
SampleID = paramenters["SampleID"],
LOT_NO = paramenters["LOT_NO"],
LINE = paramenters["LINE"],
//CompanyOffer = paramenters["CompanyOfferSample"] ,
//CompanyProd = paramenters["CompanyProduce"]
};
eventShowDetails(sender, e);
}
}
public bool InsertPlan(DOCPlan doc, ref string VoucherID, out string msg)
{
Console.WriteLine("DOCPlanDAL-InsertPlan():" + DateTime.Now.ToString());
VoucherID = string.Empty;
msg = string.Empty;
try
{
//1. VoucherID By SampleName and ProdDate
VoucherID = CreateVoucherID(doc.SampleName, doc.ProdDate);
//3.Create VoucherID
doc.VoucherID = VoucherID;
doc.State = "1";
//得到等级的版本 成品一定要有等级规格
string versionID = string.Empty;
msg = CheckGradeVersion(doc.SampleName, doc.LOT_NO, out versionID);
if (!string.IsNullOrEmpty(msg))
{
return(false);
}
Console.WriteLine(versionID);
doc.GradeVersion = versionID;
doc.UserID = Shawoo.GenuineChannels.GenuineUtility.CurrentSession["UID"].ToString();
return(db.Insert(doc));
}
catch (Exception e)
{
log.Error(e);
throw new Exception(e.Message);
}
}
private void AddPOLYSSP(string sampleName, string materialNo, bool isSampleId)
{
AddPOLYSSP _AddPOLYSSP = new AddPOLYSSP(sampleName, materialNo, isSampleId);
_AddPOLYSSP.LineList = GetLines(sampleName);
_AddPOLYSSP.CreateTypeLoad = GetPlanType();
CultureLanuage.ApplyResourcesFrom(_AddPOLYSSP, "QC21", "AddPOLYSSP");
_AddPOLYSSP.ShowDialog();
if (_AddPOLYSSP.rValue)
{
string msg = _AddPOLYSSP.ReadyWork;
if (string.IsNullOrEmpty(msg))
{
DOCPlan _DOC = _AddPOLYSSP.GetDocPlan;
string VoucherID = "";
if (biz.InsertPlan(_DOC, ref VoucherID, out msg))
{
WriteTips(5, "Add VoucherID DOC :successful!");
_QC21View.dtGrid = GetPlan();
}
else
{
WriteTips(5, msg, false);
}
}
else
{
WriteTips(5, msg);
}
}
}
public bool InsertPlanByAdd(DOCPlan doc, int addID, out string voucherID)
{
Console.WriteLine("PlanAddService--InsertPlanByAdd " + DateTime.Now.ToString());
bool result = false;
string labAddr = "";
string LabAddCommand = @"SELECT LabID FROM Samples where SampleName = @SampleName";
try
{
labAddr = acQC.SelectScalar <string>(LabAddCommand, new object[] { doc.SampleName });
voucherID = "P" + labAddr + DateTime.Now.ToString("yyMMdd");
}
catch
{
voucherID = "";
return(false);
}
//
string planCount = "SELECT ISNULL(Max(substring(VoucherID,9,4))+1,1) FROM PLANS WHERE SUBSTRING(VoucherID,1,8) = @PRE";
try
{
voucherID += (acQC.SelectScalar <int>(planCount, new object[] { voucherID })).ToString().PadLeft(4, '0');
Console.WriteLine("VoucherID:" + voucherID);
// doc.createType = 1;
doc.VoucherID = voucherID;
doc.PlanAddID = addID;
doc.HasChart = "1";
Console.WriteLine(JsonConvert.SerializeObject(doc));
if (db.Insert(doc))
{
acQC.DbHelper.ExecuteNonQuery("UPDATE PlanAdd SET State = '2' WHERE VoucherID = @VoucherID", new object[] { addID });
return(true);
}
return(false);
}
catch (Exception ex)
{
log.Error(ex);
throw new Exception(ex.Message);
}
}
void btAccept_Click(object sender, EventArgs e)
{
if (PlanAddID == -1)
{
WriteTips(8, "NO SELECT ROW", false);
return;
}
Console.WriteLine("btAccept_Click");
Console.WriteLine(PlanAddID.ToString() + "|" + SampleName + "|" + LOT_NO + "|" + LINE + "|" + ProdDate.ToString() + "|" + SampleID);
string voucherid = "";
DOCPlan panAdd = new DOCPlan();
panAdd.SampleName = SampleName;
panAdd.LOT_NO = LOT_NO;
panAdd.LINE = LINE;
panAdd.ProdDate = ProdDate;
panAdd.SheetDate = SheetDate;
panAdd.State = "1";
panAdd.Grade = "A";
panAdd.SampleID = SampleID;
panAdd.createType = CreateType;
panAdd.companyProd = CompanyProd;
panAdd.companyOffer = CompanyOffer;
panAdd.GradeVersion = GradeVersion;
if (_planAddBiz.InsertPlanByAdd(panAdd, PlanAddID, out voucherid))
{
QueryAddPlan();
WriteTips(8, "add VoucherID:" + voucherid, true);
}
else
{
WriteTips(8, "Receipt of test documents failed", false);
}
}
public List <DOCPlan> GetMultipleSelectionProducts()
{
List <DOCPlan> dOCPlans = new List <DOCPlan>();
// Add the selected rows to the list.
Int32[] selectedRowHandles = gridView1.GetSelectedRows();
for (int i = 0; i < selectedRowHandles.Length; i++)
{
int selectedRowHandle = selectedRowHandles[i];
if (selectedRowHandle >= 0)
{
var currentDoc = gridView1.GetDataRow(selectedRowHandle);
DOCPlan doc = new DOCPlan();
doc.SampleName = SampleName;
doc.LOT_NO = LotNO;
doc.LINE = currentDoc["Line"].ToString();
doc.Grade = "A";
doc.grades = currentDoc["Grades"].ToString();
doc.SampleID = currentDoc["BarCode"].ToString();
dOCPlans.Add(doc);
}
}
return(dOCPlans);
}
public bool InsertPlanByAdd(DOCPlan DOC, int AddID, out string VoucherID)
{
return(proxy.InsertPlanByAdd(DOC, AddID, out VoucherID));
}
public void EditPlanADD(DOCPlan PlanADD)
{
_QA23Dialog.Plan = PlanADD;
_QA23Dialog.ShowDialog();
}
public bool InsertPlan(DOCPlan doc, ref string VoucherID, out string msg)
{
return(proxy.InsertPlan(doc, ref VoucherID, out msg));
}
