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); }
private void Save() { Equipment_SET Equipment_SETone = new Equipment_SET(); List <Equipment_SET_detail> lstEquipment_SET_detail = null; //GridView grid_Detail = grid_Detail; if (this.grid_Detail != null && this.grid_Detail.Rows.Count > 0) { lstEquipment_SET_detail = new List <Equipment_SET_detail>(); foreach (GridViewRow item in grid_Detail.Rows) { Equipment_SET_detail en = new Equipment_SET_detail(); en.Equip_ID = Convert.ToInt32(item.Cells[Enum_grid_Detail.ID.GetHashCode()].Text); //ID en.cost = Convert.ToDecimal(item.Cells[Enum_grid_Detail.CostRent.GetHashCode()].Text); //CostRent lstEquipment_SET_detail.Add(en); } } if (VSEnum_Mode == Enum_Mode.Add) { Equipment_SETone.Price = Convert.ToDecimal(this.txtPrice.Text); Equipment_SETone.SETName = this.txtSetName.Text; Equipment_SETone.Description = this.txtDescription.Text; } else if (VSEnum_Mode == Enum_Mode.Edit) { //Equipment_SET[] Equipment_SETs = null; //ClassSet.GetDate_Equipment_SET(out Equipment_SETs, VSSet_Id); lstEquipment_SET_detail.ToList().ForEach(x => x.SET_ID = VSSet_Id.Value); //SSEquipments } else if (VSEnum_Mode == Enum_Mode.Delete) { } //Call Save int?SET_ID = ClassSet.SetData_Equipment(Equipment_SETone, lstEquipment_SET_detail, VSEnum_Mode.GetHashCode()); if (SET_ID != null) { initial(SET_ID); string message = "บันทึกเรียบร้อยแล้ว"; MessageShow(message); ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "ToggleScript", "Alert(" + message + ")", true); } }
public static int?SetData_Equipment(Equipment_SET Equipment_SETone, List <Equipment_SET_detail> lstEquipment_SET_detail, int Mode) { int? SET_ID = null; bool result = false; ResultEN ResultENs = new ResultEN(); if (Equipment_SETone != null) { if (Mode == 1)//insert { ResultENs = Insert_Equipment_SET(ref Equipment_SETone); SET_ID = ResultENs != null && ResultENs.result ? Convert.ToInt32(ResultENs.returnValue) : (int?)null; } else if (Mode == 2)//update { var _SET_ID = lstEquipment_SET_detail.Select(x => (int?)x.SET_ID).Distinct().ToArray(); ResultENs = Delete_Equipment_SET_detail(_SET_ID); if (ResultENs.result == true) { SET_ID = _SET_ID.FirstOrDefault(); ResultENs.returnValue = _SET_ID.FirstOrDefault(); } } else if (Mode == 3)//delete { } else { //break; } } if (ResultENs != null && ResultENs.result == true) { if (lstEquipment_SET_detail != null && lstEquipment_SET_detail.Any()) { lstEquipment_SET_detail.ForEach(x => x.SET_ID = Convert.ToInt32(ResultENs.returnValue)); foreach (var item in lstEquipment_SET_detail) { ResultENs = Insert_Equipment_SET_detail(item); if (ResultENs.result == false) { result = false; } else { result = true; } } } } if (result) { SET_ID = ResultENs != null && ResultENs.result ? SET_ID : (int?)null; } return(SET_ID); }
private static List <ClassFieldValue> SetField_SET(List <ClassFieldValue> fields, Equipment_SET en) { //fields.Add(new ClassFieldValue("SET_ID", en.SET_ID)); fields.Add(new ClassFieldValue("SETName", en.SETName)); fields.Add(new ClassFieldValue("Price", en.Price)); fields.Add(new ClassFieldValue("Description", en.Description)); return(fields); }