// POST: api/UpdatePartStatus
public string Post(HttpRequestMessage value)
{
try
{
string message = HttpContext.Current.Server.UrlDecode(value.Content.ReadAsStringAsync().Result).Substring(5);
JArray partStatusDetails = JArray.Parse(message);
foreach (JObject partObject in partStatusDetails)
{
Model.Part ps = new Model.Part();
int part_id = (int)partObject["Part_ID"];
ps = (from p in db.Parts
where p.Part_ID == part_id
select p).First();
ps.Part_Status_ID = (int)partObject["Part_Status_ID"];
}
db.SaveChanges();
return("true|Part Statuses successfully updated on the system.");
}
catch (Exception e)
{
ExceptionLog.LogException(e, "UpdatePartStatusController POST");
return("false|An error has occured updating the Part Statuses on the system.");
}
}
// POST: api/Part
public string Post(HttpRequestMessage value)
{
try
{
Model.Part part = new Model.Part();
string message = HttpContext.Current.Server.UrlDecode(value.Content.ReadAsStringAsync().Result).Substring(5);
JObject partStatusDetails = JObject.Parse(message);
int key = db.Parts.Count() == 0 ? 1 : (from t in db.Parts
orderby t.Part_ID descending
select t.Part_ID).First() + 1;
part.Part_ID = key;
part.Part_Serial = (string)partStatusDetails["Part_Serial"];
part.Part_Status_ID = (int)partStatusDetails["Part_Status_ID"];
part.Date_Added = DateTime.Now;
part.Cost_Price = (decimal)partStatusDetails["Cost_Price"];
part.Part_Stage = (int)partStatusDetails["Part_Stage"];
part.Parent_ID = 0;
part.Part_Type_ID = (int)partStatusDetails["Part_Type_ID"];
db.Parts.Add(part);
db.SaveChanges();
return("true|Part #" + key + " successfully added to system.");
}
catch (Exception e)
{
ExceptionLog.LogException(e, "PartController POST");
return("false|An error has occured adding the Part to the system.");
}
}
/// <summary>
/// 挑選料件
/// </summary>
/// <param name="PartNumber">料件編號</param>
/// <returns></returns>
public Model.Part FindPartByPartNumber(string PartNumber)
{
string strCmd = @"SELECT PartOID, PartNumber, PartName, PartSpec, SupplierCode, PartUnitOID,
UnitPrice, CreatedDate, PictureAdress, PictureDescription
FROM Part
where PartNumber = @PartNumber";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SqlHelper.CreateParameter("@PartNumber", SqlDbType.NVarChar, 10, PartNumber));
DataTable dt = SqlHelper.AdapterFill(strCmd, parameters);
if (dt.Rows.Count == 0)
{
return(null);
}
Model.Part pt = this.GetPart(dt.Rows[0]);
return(pt);
}
void SetShowData(string pn)
{
//string partNumber = Convert.ToString(Util.GetSessionValueThenRemove("PartNumber"));
PartDao pDao = new PartDao();
this.PartData = pDao.FindPartByPartNumber(pn);
this.lblPartNumber.Text = PartData.PartNumber;
this.lblPartName.Text = PartData.PartName;
this.lblPartSpec.Text = PartData.PartSpec;
this.lblUnitPrice.Text = PartData.UnitPrice.ToString();
this.lblSupplierName.Text = PartData.GetSupplierInfo().SupplierName;
SourceListDao slDao = new SourceListDao();
this.sourceLists = slDao.FindSourceListByPartNumber(PartData.PartNumber);
var q = from sl in sourceLists
select new { Value = sl.SourceListOID, Display = $"批量：{sl.Batch,4} - 折扣：{Math.Round(sl.Discount * 10, 1)}折 - 單價：{Math.Round(PartData.UnitPrice.Value * sl.Batch * sl.Discount, 0)}" };
this.cbSourceList.DataSource = q.ToList();
this.cbSourceList.DisplayMember = "Display";
this.cbSourceList.ValueMember = "Value";
}
private Model.Part GetPart(DataRow dr)
{
if (dr == null)
{
return(null);
}
Model.Part pt = new Model.Part();
pt.PartOID = Convert.ToInt32(dr["PartOID"]);
pt.PartNumber = Convert.ToString(dr["PartNumber"]);
pt.PartName = Convert.ToString(dr["PartName"]);
pt.PartSpec = Convert.ToString(dr["PartSpec"]);
pt.SupplierCode = Convert.ToString(dr["SupplierCode"]);
pt.PartUnitOID = Convert.ToInt32(dr["PartUnitOID"]);
if (!SqlHelper.IsNull(dr["UnitPrice"]))
{
pt.UnitPrice = Convert.ToInt32(dr["UnitPrice"]);
}
pt.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
pt.PictureAdress = Convert.ToString(dr["PictureAdress"]);
pt.PictureDescription = Convert.ToString(dr["PictureDescription"]);
return(pt);
}
