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 Insert_Equipment_SET(ref Equipment_SET en) { ResultEN res = new ResultEN(); // int? _Id = GetID("Equipment_SET", "SET_ID"); List <ClassFieldValue> fields = new List <ClassFieldValue>(); //en.SET_ID = _Id.Value; fields = SetField_SET(fields, en); res = ClassMain.Insert("Equipment_SET", fields, "SET_ID"); return(res); }
public static ResultEN InsertPosition_Emp(JobPosition_EmpEN en) { ResultEN res = new ResultEN(); List <ClassFieldValue> fields = new List <ClassFieldValue>(); fields.Add(new ClassFieldValue("Emp_id", en.empid)); fields.Add(new ClassFieldValue("Pos_id", en.posid)); fields.Add(new ClassFieldValue("cost", en.cost)); fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now)); fields.Add(new ClassFieldValue("CreatedBy", HttpContext.Current.User.Identity.Name)); res = ClassMain.Insert(tb_name_jopEmp, fields); return(res); }
public static ResultEN Insert(CustomerEN en) { ResultEN res = new ResultEN(); // Gen Employee code string C_ID = GetC_ID(); List <ClassFieldValue> fields = new List <ClassFieldValue>(); en.C_ID = C_ID; //fields.Add(new ClassFieldValue("C_ID", C_ID)); fields.Add(new ClassFieldValue("CreatedBy", HttpContext.Current.User.Identity.Name)); fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now)); SetField(fields, en); res = ClassMain.Insert(tb_name, fields); return(res); }
public static ResultEN Insert_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("CreatedBy", HttpContext.Current.User.Identity.Name)); fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now)); ResultEN res = new ResultEN(); // ClassMain cls = new ClassMain(); res = ClassMain.Insert(tb_name_type, fields); return(res); }
public static ResultEN Insert(EmployeeEN en) { ResultEN res = new ResultEN(); // Gen Employee code System.Globalization.CultureInfo cultureinfo = new System.Globalization.CultureInfo("en-US"); string code = "E" + DateTime.Now.Date.Year.ToString(cultureinfo); string runno = GetRunno(); code += runno; List <ClassFieldValue> fields = new List <ClassFieldValue>(); fields.Add(new ClassFieldValue("Emp_id", code)); fields.Add(new ClassFieldValue("CreatedBy", HttpContext.Current.User.Identity.Name)); fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now)); SetField(fields, en); res = ClassMain.Insert(tb_name, fields); return(res); }