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