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