public string InsertGradeMaterial(GradeMaterial gradematerial)
{
try
{
if (!db.Insert(gradematerial))
{
if (db.Update(gradematerial))
{
return("");
}
else
{
return("Can not Update: " + gradematerial.ID);
}
}
else
{
return("");
}
}
catch (Exception ex)
{
if (db.Update(gradematerial))
{
return("");
}
return(ex.Message);
}
}
public async Task <IActionResult> Post([FromBody] GradeMaterial nGradeMaterial)
{
if (nGradeMaterial != null)
{
nGradeMaterial.CreateDate = DateTime.Now;
nGradeMaterial.Creator = nGradeMaterial.Creator ?? "Someone";
return(new JsonResult(await this.repository.AddAsync(nGradeMaterial), this.DefaultJsonSettings));
}
return(NotFound(new { Error = "Grade Material not found." }));
}
public async Task <IActionResult> PutByNumber(int key, [FromBody] GradeMaterial uGradeMaterial)
{
if (uGradeMaterial != null)
{
uGradeMaterial.ModifyDate = DateTime.Now;
uGradeMaterial.Modifyer = uGradeMaterial.Modifyer ?? "Someone";
return(new JsonResult(await this.repository.UpdateAsync(uGradeMaterial, key), this.DefaultJsonSettings));
}
return(NotFound(new { Error = "Grade Material not found." }));
}
/// <summary>
/// create GradeMateril
/// </summary>
/// <param name="gradematerial"></param>
/// <returns></returns>
public string CreateGradeMaterial(GradeMaterial gradematerial)
{
//修改
string msg = string.Empty;
msg = IsCanCreateNewGrade(gradematerial.SampleName, gradematerial.LOT_NO, gradematerial.Grades);
if (!string.IsNullOrEmpty(msg))
{
return(msg);
}
//gradematerial.UserID = GenuineUtility.CurrentSession["UID"].ToString();
return(InsertGradeMaterial(gradematerial));
}
public IHttpActionResult GradesProcessing(string id)
{
try
{
JsonObject json = new JsonObject();
GradeMaterial gra = biz.GetGradeMaterial(id);
GradeMaterialDto grade = new GradeMaterialDto();
if (!string.IsNullOrEmpty(gra.SampleName) && !string.IsNullOrEmpty(gra.LOT_NO))
{
SampleService sampleDal = new SampleService();
QCSample sample = sampleDal.SelectSample(gra.SampleName);
QCMaterial material = sampleDal.GetMaterial(gra.SampleName, gra.LOT_NO);
json["SampleName"] = sample.SampleName;
json["SampleDescription_EN"] = sample.Description_EN;
json["SampleDescription_CN"] = sample.Description_CN;
json["SampleDescription_TW"] = sample.Description_TW;
json["SampleDescription_VN"] = sample.Description_VN;
json["Status"] = gra.Status;
json["Grade"] = gra.Grades;
json["LOT_NO"] = material.LOT_NO;
json["MaterialDescription_EN"] = material.Description_EN;
json["MaterialDescription_CN"] = material.Description_CN;
json["MaterialDescription_TW"] = material.Description_TW;
json["MaterialDescription_VN"] = material.Description_VN;
json["Version"] = gra.Version;
json["VersionSpc"] = gra.VersionSpc;
json["UserID"] = gra.UserID;
//json["Remark"] = gra.Remark;
DataTable dtGrade = biz.NewestGrades(id);
json["Grades"] = helpbiz.ConvertJson(dtGrade);
return(Ok(json));
}
else
{
return(BadRequest("NO DATA"));
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
Loger.Error(ex);
return(BadRequest(ex.Message + ex.StackTrace));
}
}
public string UpdateGradeMaterial(GradeMaterial gradematerial)
{
return(InsertGradeMaterial(gradematerial));
}
public IHttpActionResult SaveSpecialModifyVersion(GradeMaterialDto material)
{
JsonObject json = new JsonObject();
string msg = string.Empty;
DataTable dt = biz.IsCanSpecial_UpdateVersion(material.SampleName, material.LOT_NO, material.Grades);
if (dt.Rows.Count > 0)
{
// can revise
msg = dt.Rows[0]["MSG"].ToString();
if (!string.IsNullOrEmpty(msg))
{
json["Error"] = msg;
return(Ok(json));
}
int version = int.Parse(dt.Rows[0]["Version"].ToString());
DataTable dtNewest = biz.NewestGrades(dt.Rows[0]["ID"].ToString());
if (dtNewest.Rows.Count < 0)
{
json["Error"] = "NO property Name";
return(Ok(json));
}
DateTime lastversionDate = Convert.ToDateTime(dtNewest.Rows[0]["ValidDate"]);
if (lastversionDate > material.ValidDate)
{
return(BadRequest("Valid Date is Error ,it is min Last Version"));
}
GradeMaterial gm = new GradeMaterial();
gm.ID = Guid.NewGuid().ToString();
gm.SampleName = material.SampleName;
gm.LOT_NO = material.LOT_NO;
gm.Version = version;
gm.Grades = material.Grades == null ? "00" : material.Grades;
gm.UserID = material.UserID;
gm.Stamp = System.DateTime.Now;
gm.Status = "N";
gm.VersionSpc = "V" + gm.Version.ToString().PadLeft(2, '0');
//gm.Remark = material.Remark;
msg = biz.InsertGradeMaterial(gm);
if (!string.IsNullOrEmpty(msg))
{
json["Error"] = msg;
return(Ok(json));
}
List <QCGrades> grades = new List <QCGrades>();
foreach (var g in material.GradesDto)
{
QCGrades grade = new QCGrades();
grade.ID = gm.ID;
grade.PropertyName = g.PropertyName;
grade.Grade = material.Grade;
grade.Enable = g.Enable;
grade.MaxValue = g.MaxValue;
grade.MinValue = g.MinValue;
grade.Prec = g.Prec;
grade.ValueSpec = g.ValueSpec;
grade.ValidTODate = null;
grade.CreateDate = System.DateTime.Now;;
grade.ValidDate = material.ValidDate;
grade.Stamp = System.DateTime.Now;
grade.UserID = material.UserID;
grade.Remark = "revise";
grades.Add(grade);
}
msg = biz.CreateNewVersion(gm.ID.ToString(), gm.Version, grades);
if (!string.IsNullOrEmpty(msg))
{
json["Error"] = msg;
return(Ok(json));
}
//update last verion date
json["ID"] = gm.ID;
json["Version"] = gm.Version;
json["VersionSpc"] = gm.VersionSpc;
json["SampleName"] = material.SampleName;
json["LOT_NO"] = material.LOT_NO;
json["Grades"] = material.Grades;
return(Ok(json));
}
else
{
return(BadRequest("DOn't get Row"));
}
}
public IHttpActionResult UpdateGrade(GradeMaterialDto material)
{
try
{
JsonObject json = new JsonObject();
GradeMaterial gm = new GradeMaterial();
string msg = String.Empty;
gm.SampleName = material.SampleName;
gm.LOT_NO = material.LOT_NO;
gm.Grades = material.Grades == null ? "00" : material.Grades;
gm.ID = material.ID;
gm.Version = material.Version;
gm.Status = "N";
gm.UserID = material.UserID;
gm.VersionSpc = "V" + gm.Version.ToString().PadLeft(2, '0');
gm.Stamp = System.DateTime.Now;
//gm.Remark = material.Remark;
string _id = biz.IsExsitGrade(material.SampleName, material.LOT_NO, material.Grades);
if (!string.IsNullOrEmpty(_id))
{
bool isDelete = biz.DeleteAllGradeByDarf(_id);
if (!isDelete)
{
json["Error"] = "DELETE Failed";
return(Ok(json));
}
}
msg = biz.UpdateGradeMaterial(gm);
if (!string.IsNullOrEmpty(msg))
{
json["Error"] = msg;
return(Ok(json));
}
gm = biz.GetGradeMaterial(gm.ID.ToString());
List <QCGrades> grades = new List <QCGrades>();
foreach (var g in material.GradesDto)
{
QCGrades grade = new QCGrades();
grade.ID = gm.ID;
grade.PropertyName = g.PropertyName;
grade.Grade = material.Grade;
grade.Enable = g.Enable;
grade.MaxValue = g.MaxValue;
grade.MinValue = g.MinValue;
grade.Prec = g.Prec;
grade.ValueSpec = g.ValueSpec;
grade.ValidTODate = null;
grade.CreateDate = System.DateTime.Now;;
grade.ValidDate = material.ValidDate;
grade.Stamp = System.DateTime.Now;
grade.UserID = material.UserID;
grades.Add(grade);
}
msg = biz.CreateNewVersion(gm.ID.ToString(), gm.Version, grades);
if (!string.IsNullOrEmpty(msg))
{
json["Error"] = msg;
return(Ok(json));
}
json["ID"] = gm.ID;
json["Version"] = gm.Version;
json["SampleName"] = material.SampleName;
json["LOT_NO"] = material.LOT_NO;
json["Grades"] = material.Grades;
json["VersionSpc"] = gm.VersionSpc;
return(Ok(json));
}
catch (Exception ex)
{
Console.WriteLine(ex);
Loger.Error(ex);
return(BadRequest(ex.Message + ex.StackTrace));
}
}
