public static ResultEN Insert_Equip(EquiptmentEN en) { // SqlCommand sqlCmd = new SqlCommand(); // sqlCmd.CommandText = "insert into " + tb_name_type +" ()"; List <ClassFieldValue> fields = new List <ClassFieldValue>(); fields.Add(new ClassFieldValue("Name", en.Name)); fields.Add(new ClassFieldValue("Fullname", en.Fullname)); fields.Add(new ClassFieldValue("Equip_type_id", en.Equip_type_id)); fields.Add(new ClassFieldValue("Number", en.EquipNo)); fields.Add(new ClassFieldValue("SN", en.SN)); fields.Add(new ClassFieldValue("SupplierName", en.SupplierName)); fields.Add(new ClassFieldValue("ReceiptTax", en.ReceiptTax)); fields.Add(new ClassFieldValue("BuyDate", en.BuyDate)); fields.Add(new ClassFieldValue("CostBuy", en.CostBuy)); fields.Add(new ClassFieldValue("CostRent", en.CostRent)); fields.Add(new ClassFieldValue("ExpireDate", en.ExpireDate)); fields.Add(new ClassFieldValue("CreatedBy", HttpContext.Current.User.Identity.Name)); fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now)); ResultEN res = new ResultEN(); res = ClassMain.Insert(tb_name_master, fields); return(res); }
public static ResultEN Update_Equip(EquiptmentEN en) { List <ClassFieldValue> fields = new List <ClassFieldValue>(); fields.Add(new ClassFieldValue("Name", en.Name)); fields.Add(new ClassFieldValue("Fullname", en.Fullname)); fields.Add(new ClassFieldValue("Equip_type_id", en.Equip_type_id)); fields.Add(new ClassFieldValue("Number", en.EquipNo)); fields.Add(new ClassFieldValue("SN", en.SN)); fields.Add(new ClassFieldValue("SupplierName", en.SupplierName)); fields.Add(new ClassFieldValue("ReceiptTax", en.ReceiptTax)); fields.Add(new ClassFieldValue("BuyDate", en.BuyDate)); fields.Add(new ClassFieldValue("CostBuy", en.CostBuy)); fields.Add(new ClassFieldValue("CostRent", en.CostRent)); fields.Add(new ClassFieldValue("ExpireDate", en.ExpireDate)); fields.Add(new ClassFieldValue("UpdatedBy", HttpContext.Current.User.Identity.Name)); fields.Add(new ClassFieldValue("UpdatedDate", DateTime.Now)); ResultEN res = new ResultEN(); List <ClassFieldValue> fieldWhere = new List <ClassFieldValue>(); fieldWhere.Add(new ClassFieldValue("ID", en.ID)); res = ClassMain.Update(tb_name_master, fields, fieldWhere); return(res); }
protected void datagrid_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "select") { mode = "edit"; btnAdd.Visible = false; ClearText(); int id = Convert.ToInt32(e.CommandArgument); this.SelectedID = id; EquiptmentEN en = ClassEuipt.SearchEquipByID(id); this.SelectedEquip = en; setControl(en); divDetail.Visible = true; btnSave.Visible = true; btnDelete.Visible = true; btnCencel.Visible = true; } else { } }
public static ResultEN Delete_Type(EquiptmentEN en) { ResultEN res = new ResultEN(); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandText = "Delete From " + tb_name_master + " WHERE ID = " + en.ID; sqlCmd.CommandType = CommandType.Text; res.result = ClassMain.ExecuteComand(sqlCmd); return(res); }
private void Save() { ResultEN res = new ResultEN(); EquiptmentEN en = new EquiptmentEN(); switch (mode) { case "add": SetItem(en); res = ClassEuipt.Insert_Equip(en); break; case "edit": en = this.SelectedEquip; SetItem(en); res = ClassEuipt.Update_Equip(en); break; default: break; } //if (mode == "add") //{ // EquiptmentEN en = new EquiptmentEN(); // SetItem(en); // res = ClassEuipt.Insert_Equip(en); //} //else //{ // EquiptmentEN en = this.SelectedEquip; // SetItem(en); // res = ClassEuipt.Update_Equip(en); //} if (res.result) { MessageShow("บันทึกเรียบร้อยแล้ว"); BindGrid(); BindTree(); SetDefult(); this.SelectedItem = null; } }
private void SetItem(EquiptmentEN en) { en.Name = txtName.Text; en.Fullname = txtFullName.Text; en.EquipNo = txtEquipNo.Text; en.ReceiptTax = txtReceiptTax.Text; en.SupplierName = txtSupplierName.Text; en.ExpireDate = Utilities.ConvertoDate(txtExpireDate.Text); en.BuyDate = Utilities.ConvertoDate(txtBuyDate.Text); en.CostBuy = Convert.ToDecimal(txtCostBuy.Text); en.CostRent = Convert.ToDecimal(txtCostRent.Text); en.SN = txtSN.Text; en.Equip_type_id = Convert.ToInt32(hidID.Value); }
private void setControl(EquiptmentEN en) { txtBuyDate.Text = en.BuyDate.ToString("dd/MM/yyyy"); txtCostBuy.Text = en.CostBuy.ToString(); txtCostRent.Text = en.CostRent.ToString(); txtExpireDate.Text = en.ExpireDate.ToString("dd/MM/yyyy"); txtFullName.Text = en.Fullname; txtName.Text = en.Name; txtEquipNo.Text = en.EquipNo; txtReceiptTax.Text = en.ReceiptTax; txtSN.Text = en.SN; txtSupplierName.Text = en.SupplierName; txtTypeName.Text = en.equipType.TypeName; hidID.Value = en.Equip_type_id.ToString(); }
public static EquiptmentEN SearchEquipByID(int ID) { StringBuilder Sql = new StringBuilder(); Sql.AppendLine("select e.*, t.ID as TypeID, t.TypeName"); Sql.AppendLine("from " + tb_name_master + " e "); Sql.AppendLine("inner join " + tb_name_type + " t on e.Equip_type_id = t.ID"); Sql.AppendLine(""); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandText = Sql.ToString(); DataTable dt = ClassMain.ExecuteComandTable(sqlCmd); EquiptmentEN en = new EquiptmentEN(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; en.ID = Convert.ToInt32(dr["ID"]); en.EquipNo = Convert.ToString(dr["Number"]); en.Name = Convert.ToString(dr["Name"]); en.Fullname = Convert.ToString(dr["Fullname"]); en.CostBuy = Convert.ToDecimal(dr["CostBuy"]); en.CostRent = Convert.ToDecimal(dr["CostRent"]); en.BuyDate = Convert.ToDateTime(dr["BuyDate"]); en.Equip_type_id = Convert.ToInt32(dr["Equip_type_id"]); en.ExpireDate = Convert.ToDateTime(dr["ExpireDate"]); en.ReceiptTax = Convert.ToString(dr["ReceiptTax"]); en.SupplierName = Convert.ToString(dr["SupplierName"]); en.SN = Convert.ToString(dr["SN"]); en.equipType = new EquipmentTypeEN(); en.equipType.ID = Convert.ToInt32(dr["TypeID"]); en.equipType.TypeName = Convert.ToString(dr["TypeName"]); return(en); } else { return(null); } }