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); }
public static ResultEN Update(CustomerEN en) { ResultEN res = new ResultEN(); List <ClassFieldValue> fields = new List <ClassFieldValue>(); fields.Add(new ClassFieldValue("UpdatedBy", HttpContext.Current.User.Identity.Name)); fields.Add(new ClassFieldValue("UpdatedDate", DateTime.Now)); SetField(fields, en); List <ClassFieldValue> fieldscon = new List <ClassFieldValue>(); fieldscon.Add(new ClassFieldValue("C_ID", en.C_ID)); res = ClassMain.Update(tb_name, fields, fieldscon); return(res); }
public static ResultEN UpdatePosition_Emp(JobPosition_EmpEN en) { ResultEN res = new ResultEN(); List <ClassFieldValue> fields = new List <ClassFieldValue>(); fields.Add(new ClassFieldValue("cost", en.cost)); fields.Add(new ClassFieldValue("UpdatedDate", DateTime.Now)); fields.Add(new ClassFieldValue("UpdatedBy", HttpContext.Current.User.Identity.Name)); List <ClassFieldValue> fieldscon = new List <ClassFieldValue>(); fieldscon.Add(new ClassFieldValue("Emp_id", en.empid)); fieldscon.Add(new ClassFieldValue("Pos_id", en.posid)); res = ClassMain.Update(tb_name_jopEmp, fields, fieldscon); return(res); }
public static ResultEN Update_Type(EquipmentTypeEN en) { // SqlCommand sqlCmd = new SqlCommand(); // sqlCmd.CommandText = "insert into " + tb_name_type +" ()"; List <ClassFieldValue> fields = new List <ClassFieldValue>(); fields.Add(new ClassFieldValue("TypeName", en.TypeName)); fields.Add(new ClassFieldValue("ParentID", en.ParentID)); fields.Add(new ClassFieldValue("UpdatedBy", HttpContext.Current.User.Identity.Name)); fields.Add(new ClassFieldValue("UpdatedDate", DateTime.Now)); ResultEN res = new ResultEN(); // ClassMain cls = new ClassMain(); List <ClassFieldValue> fieldWhere = new List <ClassFieldValue>(); fieldWhere.Add(new ClassFieldValue("ID", en.ID)); res = ClassMain.Update(tb_name_type, fields, fieldWhere); return(res); }