void btnSave_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(view.txtPartNo.Text)) { if (!String.IsNullOrEmpty(view.txtPartName.Text)) { try { Part part = new Part() { BrandID = brandId, PartNo = view.txtPartNo.Text, PartName = view.txtPartName.Text, Model = view.txtModel.Text, GSP = Convert.ToDecimal(view.txtGSP.Text), IMSP = Convert.ToDecimal(view.txtIMSP.Text), Status = 1 }; partModel.createPart(part, user.UserID); view.Close(); } catch (Exception ex) { MessageBox.Show("พบข้อผิดผลาด: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { view.txtPartName.Focus(); } } else { view.txtPartNo.Focus(); } return; }
public static List<Part> getPartsByBrandIdPartNo(int brandId, string partNo) { try { SQLHelper dbhelper = new SQLHelper(); List<MySqlParameter> lstParameter = new List<MySqlParameter>(); lstParameter.Add(new MySqlParameter("_BrandID", brandId)); lstParameter.Add(new MySqlParameter("_PartNo", partNo)); var resultSet = dbhelper.executeSP<DataSet>(lstParameter, "SelectPartByBrandIdPartNo"); List<Part> parts = new List<Part>(); foreach (DataRow drow in resultSet.Tables[0].Rows) { Part part = new Part(); part.PartID = Convert.ToInt32(drow["partId"].ToString()); part.BrandID = Convert.ToInt32(drow["brandId"].ToString()); part.PartNo = drow["partno"].ToString(); part.PartName = drow["partname"].ToString(); part.Model = drow["model"].ToString(); part.GSP = Convert.ToDecimal(drow["gsp"].ToString()); part.IMSP = Convert.ToDecimal(drow["imsp"].ToString()); part.Status = Convert.ToInt32(drow["status"].ToString()); part.LocG = drow["locG"].ToString(); part.LocIM = drow["locIM"].ToString(); part.Comment = drow["comment"].ToString(); part.is_new = false; parts.Add(part); } return parts; } catch (Exception e) { throw e; } }