public static void UpdateData(DataObject.SysProduct obj) { SqlConnection conn = Common.Connection.SqlConnect(); String Update = "UPDATE SYS_PRODUCT SET ORG_ID = @ORG_ID, Product_Code = @Product_Code, "; Update += "Product_Name = @Product_Name, Product_Unit = @Product_Unit, Product_Amount = @Product_Amount Where ID = @ID"; SqlCommand cmd = new SqlCommand(Update); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@ORG_ID", obj.ORG_ID); cmd.Parameters.AddWithValue("@Product_Code", obj.Product_Code); cmd.Parameters.AddWithValue("@Product_Name", obj.Product_Name); cmd.Parameters.AddWithValue("@Product_Unit", obj.Product_Unit); cmd.Parameters.AddWithValue("@Product_Amount", obj.Product_Amount); cmd.Parameters.AddWithValue("@ID", obj.ID); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static void InsertData(DataObject.SysProduct obj) { String Insert = "INSERT INTO SYS_PRODUCT (ORG_ID,Product_Code,Product_Name,Product_Unit,Product_Amount,Create_User,Create_Date) VALUES "; Insert += "(@ORG_ID,@Product_Code,@Product_Name,@Product_Unit,@Product_Amount,@Create_User,@Create_Date)"; SqlConnection conn = Common.Connection.SqlConnect(); SqlCommand cmd = new SqlCommand(Insert); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@ORG_ID", obj.ORG_ID); cmd.Parameters.AddWithValue("@Product_Code", obj.Product_Code); cmd.Parameters.AddWithValue("@Product_Name", obj.Product_Name); cmd.Parameters.AddWithValue("@Product_Unit", obj.Product_Unit); cmd.Parameters.AddWithValue("@Product_Amount", obj.Product_Amount); cmd.Parameters.AddWithValue("@Create_User", obj.Create_User); cmd.Parameters.AddWithValue("@Create_Date", obj.Create_Date); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static List <DataObject.SysProduct> GetDataByProduct(string productCode) { List <DataObject.SysProduct> lstSysProduct = new List <DataObject.SysProduct>(); String Select = ""; SqlCommand cmd = null; SqlConnection conn = Common.Connection.SqlConnect(); if (productCode != null && productCode != "") { Select = "Select * from SYS_PRODUCT Where Product_Code = @Product_Code"; cmd = new SqlCommand(Select); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@Product_Code", productCode); } conn.Open(); using (SqlDataReader oReader = cmd.ExecuteReader()) { while (oReader.Read()) { DataObject.SysProduct obj = new DataObject.SysProduct(); obj.ID = Int32.Parse(oReader["ID"].ToString()); obj.ORG_ID = Int32.Parse(oReader["ORG_ID"].ToString()); obj.Product_Code = oReader["Product_Code"].ToString(); obj.Product_Name = oReader["Product_Name"].ToString(); obj.Product_Unit = oReader["Product_Unit"].ToString(); obj.Product_Amount = float.Parse(oReader["Product_Amount"].ToString()); obj.Create_User = oReader["Create_User"].ToString(); if (oReader["Create_Date"].ToString() != "" && oReader["Create_Date"].ToString() != null) { String createDate = String.Format("{0:dd/MM/yyyy}", oReader["Create_Date"].ToString()); obj.Create_Date = DateTime.Parse(createDate); } lstSysProduct.Add(obj); } } conn.Close(); return(lstSysProduct); }
public void Update(DataObject.SysProduct obj) { Servies.SysProductServices.UpdateData(obj); }
public void Insert(DataObject.SysProduct obj) { Servies.SysProductServices.InsertData(obj); }