/// <summary> /// GetData /// 제품 데이터와 해당 제품의 원부자재 목록 가져오기 /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet GetData(DBTranSet req) { try { if (req.TranList[0].Parameter.GetValue("PURC_ID").ToStringNullToEmpty().IsNullOrEmpty() && req.TranList[0].Parameter.GetValue("PURC_NO").IsNullOrEmpty() == false) { var id = DaoFactory.Instance.QueryForObject <string>("GetPurcIdByPurcNo", req.TranList[0].Parameter); req.TranList[0].Parameter.SetValue("PURC_ID", id); } var data = DaoFactory.Instance.QueryForObject <PurcTranDataModel>("GetPurcTran", req.TranList[0].Parameter); var list = DaoFactory.Instance.QueryForList <PurcTranItemDataModel>("GetPurcTranItem", req.TranList[0].Parameter); req.TranList = new DBTranData[] { new DBTranData() { Data = data }, new DBTranData() { Data = list } }; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet GetSaleDashboard(DBTranSet req) { try { var data1 = DaoFactory.Instance.QueryForList <DataMap>("GetSaleDaily", req.TranList[0].Parameter); var data2 = DaoFactory.Instance.QueryForList <DataMap>("GetSaleMonthly", req.TranList[0].Parameter); req.TranList = new DBTranData[] { new DBTranData() { Data = data1 }, new DBTranData() { Data = data2 } }; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet ProcedureCall(DBTranSet reqset) { try { if (reqset.TranList == null || reqset.TranList.Length == 0) { throw new Exception("처리요청이 없습니다."); } foreach (DBTranData req in reqset.TranList) { if (req.Parameter == null) { req.Parameter = new DataMap(); } req.Parameter.SetValue("INS_USER", reqset.UserId); DaoFactory.Instance.QueryForObject <int>(req.SqlId, req.Parameter); } return(reqset); } catch (Exception ex) { reqset.ErrorNumber = ex.HResult; reqset.ErrorMessage = ex.Message; return(reqset); } }
public static DBTranSet GetData(DBTranSet req) { try { var data = DaoFactory.Instance.QueryForObject <ProdTranDataModel>("GetProdTranData", req.TranList[0].Parameter); var list = DaoFactory.Instance.QueryForList <DataMap>("GetProdMaterials", req.TranList[0].Parameter); req.TranList = new DBTranData[] { new DBTranData() { Data = data }, new DBTranData() { Data = list } }; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet GetData(DBTranSet req) { try { var saletran = DaoFactory.Instance.QueryForObject <SaleTranDataModel>("GetSaleTran", req.TranList[0].Parameter); var saleitem = DaoFactory.Instance.QueryForList <SaleTranItemDataModel>("GetSaleTranItem", req.TranList[0].Parameter); req.TranList = new DBTranData[] { new DBTranData() { Data = saletran }, new DBTranData() { Data = saleitem } }; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
/// <summary> /// Delete /// 데이터 삭제(Delete) /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet Delete(DBTranSet req) { try { var map = DaoFactory.Instance.QueryForObject <PurcTranDataModel>("GetPurcTran", req.TranList[0].Parameter); if (map != null) { //삭제 전에 재고 반영한다. DaoFactory.Instance.QueryForObject <int>("BatchInventory", new DataMap() { { "TRAN_ID", req.TranList[0].Parameter.GetValue("PURC_ID") }, { "TRAN_TP", "PC" }, { "REG_TP", "DD" }, { "ITEM_ID", 0 }, { "INS_USER", req.TranList[0].Parameter.GetValue("INS_USER") } }); //구매내역을 삭제한다. DaoFactory.Instance.Delete("DeletePurcTran", req.TranList[0].Parameter); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
/// <summary> /// GetData /// 제품 데이터와 해당 제품의 원부자재 목록 가져오기 /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet GetData(DBTranSet req) { try { var customerData = DaoFactory.Instance.QueryForObject <DataMap>("SelectCustomer", req.TranList[0].Parameter); var phonesData = DaoFactory.Instance.QueryForList <DataMap>("SelectCustomerPhones", req.TranList[0].Parameter); var addressData = DaoFactory.Instance.QueryForList <DataMap>("SelectCustomerAddress", req.TranList[0].Parameter); req.TranList = new DBTranData[] { new DBTranData() { Data = customerData }, new DBTranData() { Data = phonesData }, new DBTranData() { Data = addressData } }; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet GetCodeHelpLookup(DBTranSet reqset) { try { if (reqset.TranList == null || reqset.TranList.Length == 0) { throw new Exception("처리요청이 정확하지 않습니다."); } foreach (DBTranData req in reqset.TranList) { IList <DataMap> list; var parentCode = req.Parameter.GetValue("PARENT_CODE").ToStringNullToEmpty().ToCamelCase(); switch (parentCode) { case "Module": case "View": case "Menu": case "Group": case "Role": case "Help": case "Code": case "CodeGroup": case "Customer": case "Product": case "AllProduct": case "ProdProduct": case "Material": case "Purcitem": case "Saleitem": case "Department": case "Employee": case "Project": case "Work": case "Task": case "MasterPlanResource": case "MasterPlan": case "System": list = DaoFactory.Instance.QueryForList <DataMap>(string.Format("GetCodeHelp{0}List", parentCode), req.Parameter); break; default: list = DaoFactory.Instance.QueryForList <DataMap>("GetCodeHelp", req.Parameter); break; } req.Data = ConvertUtils.DataMapListToDataTable(list, req.SqlId); } return(reqset); } catch (Exception ex) { reqset.ErrorNumber = ex.HResult; reqset.ErrorMessage = ex.Message; return(reqset); } }
public static DBTranSet Execute(this DBTranSet reqset) { try { reqset.UserId = GlobalVar.Settings.GetValue("USER_ID").ToIntegerNullToZero(); return((new DBTranController()).Execute(reqset)); } catch { throw; } }
/// <summary> /// CheckLoginUser /// 로그인 체크 /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet CheckLoginUser(DBTranSet req) { try { req.TranList[0].Parameter.SetValue("USER_ID", null); var data = DaoFactory.Instance.QueryForObject <LoginUserDataModel>("GetLoginUser", req.TranList[0].Parameter); if (data == null) { req.ErrorNumber = -1; req.ErrorMessage = "해당 아이디로 사용자를 찾을 수 없습니다."; return(req); } if (data.USE_YN != "Y") { req.ErrorNumber = -2; req.ErrorMessage = "사용 가능한 아이디가 아닙니다. 확인 후 다시 시도하세요!!!"; return(req); } if (data.IS_PW_CHECK != 1) { req.ErrorNumber = -3; req.ErrorMessage = "비밀번호가 정확하지 않습니다. 확인 후 다시 시도하세요!!!"; return(req); } req.TranList[0].Parameter.SetValue("USER_ID", data.USER_ID); try { DaoFactory.Instance.Insert("InsertLoginLog", req.TranList[0].Parameter); } catch (Exception ex) { throw new Exception("로그인로그 저장 중 오류가 발생하였습니다.\r\n" + ErrorUtils.GetMessage(ex)); } req.TranList[0].Data = data; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
/// <summary> /// GetStyles /// 스타일 정보 /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet GetStyles(DBTranSet req) { try { var list = DaoFactory.Instance.QueryForList <DataMap>("GetStyles", req.TranList[0].Parameter); req.TranList[0].Data = ConvertUtils.DataMapListToDataTable(list, req.TranList[0].SqlId); return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet GetInventoryList(DBTranSet req) { try { var list = DaoFactory.Instance.QueryForList <InventoryListModel>("GetInventoryList", req.TranList[0].Parameter); req.TranList[0].Data = list; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet GetData(DBTranSet req) { try { var data = DaoFactory.Instance.QueryForObject <ProdTranDataModel>("GetProdTranData", req.TranList[0].Parameter); req.TranList[0].Data = data; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet ChangePassword(DBTranSet req) { try { DataMap map = req.TranList[0].Data as DataMap; map.SetValue("INS_USER", req.UserId); var data = DaoFactory.Instance.QueryForObject <LoginUserDataModel>("GetLoginUser", map); if (data == null) { req.ErrorNumber = -1; req.ErrorMessage = "해당 아이디로 사용자를 찾을 수 없습니다."; return(req); } if (data.USE_YN != "Y") { req.ErrorNumber = -2; req.ErrorMessage = "사용 가능한 아이디가 아닙니다. 확인 후 다시 시도하세요!!!"; return(req); } if (data.IS_PW_CHECK != 1) { req.ErrorNumber = -3; req.ErrorMessage = "비밀번호가 정확하지 않습니다. 확인 후 다시 시도하세요!!!"; return(req); } map.SetValue("USER_ID", data.USER_ID); map.SetValue("LOGIN_PW", map.GetValue("CHG_LOGIN_PW")); DaoFactory.Instance.Update("ChangePassword", map); req.ErrorNumber = 0; req.ErrorMessage = "SUCCESS"; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
/// <summary> /// Delete /// 데이터 삭제(Delete) /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet Delete(DBTranSet reqset) { try { if (reqset.TranList == null || reqset.TranList.Length == 0) { throw new Exception("처리요청이 없습니다."); } foreach (DBTranData req in reqset.TranList) { DataMap parameter = null; if (req.Data == null) { continue; } if (req.Data.GetType() == typeof(DataMap)) { parameter = (req.Data as DataMap); } else if (req.Data.GetType() == typeof(DataTable)) { parameter = (req.Data as DataTable).ToDataMap(); } else { continue; } parameter.SetValue("INS_USER", reqset.UserId); var map = DaoFactory.Instance.QueryForObject <DataMap>(string.Format("Select{0}", req.SqlId), parameter); if (map != null) { DaoFactory.Instance.Insert("Delete{0}", parameter); } } return(reqset); } catch (Exception ex) { reqset.ErrorNumber = ex.HResult; reqset.ErrorMessage = ex.Message; return(reqset); } }
/// <summary> /// SaveBookmark /// 북마크 저장 /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet SaveBookmark(DBTranSet req) { try { var map = DaoFactory.Instance.QueryForObject <DataMap>("SelectBookmark", req.TranList[0].Parameter); if (map == null || map.GetValue("USER_ID") == null) { DaoFactory.Instance.Insert("InsertBookmark", req.TranList[0].Parameter); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
/// <summary> /// Delete /// 데이터 삭제(Delete) /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet Delete(DBTranSet req) { try { var map = DaoFactory.Instance.QueryForObject <DataMap>("SelectCustomer", req.TranList[0].Parameter); if (map != null) { DaoFactory.Instance.Insert("DeleteCustomer", req.TranList[0].Parameter); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet ClearPassword(DBTranSet req) { try { DataMap data = req.TranList[0].Data as DataMap; data.SetValue("INS_USER", req.UserId); DaoFactory.Instance.Update("ClearPassword", data); req.ErrorNumber = 0; req.ErrorMessage = "SUCCESS"; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public DBTranSet Execute(DBTranSet req) { var namespaceName = string.Format("JW.AUBE.Service.Services.{0}Service", req.ServiceId); var methodName = req.ProcessId; try { Logger.Info(string.Format("DBTranController=> {0}.{1}", namespaceName, methodName)); var result = (DBTranSet)TypeUtils.InvokeMethodByParam(assemblyName, namespaceName, methodName, req); return(result); } catch (Exception ex) { Logger.Error("DBTranController=> " + ex.Message); req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
/// <summary> /// GetFormData /// 화면정보 가져오기 /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet GetFormData(DBTranSet req) { try { var data = DaoFactory.Instance.QueryForObject <DataMap>("GetViewData", req.TranList[0].Parameter); List <DataMap> list = new List <DataMap>(); if (data != null) { list.Add(data); } req.TranList[0].Data = ConvertUtils.DataMapListToDataTable(list, "GetFormData"); return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
/// <summary> /// Logout /// 로그아웃 /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet Logout(DBTranSet req) { try { try { DaoFactory.Instance.Update("UpdateLogout", req.TranList[0].Parameter); } catch (Exception ex) { throw new Exception("로그아웃 정보 저장 중 오류가 발생하였습니다.\r\n" + ErrorUtils.GetMessage(ex)); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet GetColumnList(DBTranSet reqset) { try { if (reqset.TranList == null || reqset.TranList.Length == 0) { throw new Exception("처리요청이 없습니다."); } foreach (DBTranData req in reqset.TranList) { req.Parameter.SetValue("INS_USER", reqset.UserId); req.Data = DaoFactory.Instance.QueryForList <ColumnListModel>(req.SqlId, req.Parameter); } return(reqset); } catch (Exception ex) { reqset.ErrorNumber = ex.HResult; reqset.ErrorMessage = ex.Message; return(reqset); } }
public static DBTranSet GetSaleStat(DBTranSet req) { try { var data1 = DaoFactory.Instance.QueryForList <DataMap>("GetSaleProductList", req.TranList[0].Parameter); var data2 = DaoFactory.Instance.QueryForList <DataMap>("GetSaleCustomerList", req.TranList[0].Parameter); var data3 = DaoFactory.Instance.QueryForList <DataMap>("GetSaleCategoryList", req.TranList[0].Parameter); var data4 = DaoFactory.Instance.QueryForList <DataMap>("GetSalePayTypeList", req.TranList[0].Parameter); req.TranList = new DBTranData[] { new DBTranData() { Data = data1 }, new DBTranData() { Data = data2 }, new DBTranData() { Data = data3 }, new DBTranData() { Data = data4 } }; return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet Save(DBTranSet req) { bool isTran = false; try { if (req == null) { throw new Exception("처리할 요청이 정확하지 않습니다."); } if (req.TranList == null || req.TranList.Length == 0) { throw new Exception("처리할 데이터가 없습니다."); } DaoFactory.Instance.BeginTransaction(); isTran = true; try { object prod_id = null; if (req.TranList.Length > 0) { if (req.TranList[0].Data == null) { throw new Exception("저장할 데이터가 존재하지 않습니다."); } DataMap data = (req.TranList[0].Data as DataTable).ToDataMapList()[0]; if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "INSERT") { //생산트랜 저장 prod_id = DaoFactory.Instance.Insert("InsertProdTran", data); //재고반영 DaoFactory.Instance.QueryForObject <int>("BatchInventory", new DataMap() { { "TRAN_ID", prod_id }, { "TRAN_TP", "PR" }, { "REG_TP", "II" }, { "INS_USER", data.GetValue("INS_USER") } }); } else if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "UPDATE") { prod_id = data.GetValue("PROD_ID"); //수정 전 재고반영(-) DaoFactory.Instance.QueryForObject <int>("BatchInventory", new DataMap() { { "TRAN_ID", prod_id }, { "TRAN_TP", "PR" }, { "REG_TP", "UD" }, { "INS_USER", data.GetValue("INS_USER") } }); //생산수정 DaoFactory.Instance.Update("UpdateProdTran", data); //수정 후 재고반영(+) DaoFactory.Instance.QueryForObject <int>("BatchInventory", new DataMap() { { "TRAN_ID", prod_id }, { "TRAN_TP", "PR" }, { "REG_TP", "UI" }, { "INS_USER", data.GetValue("INS_USER") } }); } else if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "DELETE") { prod_id = data.GetValue("PROD_ID"); //재고반영 DaoFactory.Instance.QueryForObject <int>("BatchInventory", new DataMap() { { "TRAN_ID", prod_id }, { "TRAN_TP", "PR" }, { "REG_TP", "DD" }, { "INS_USER", data.GetValue("INS_USER") } }); //생산트랜삭제 DaoFactory.Instance.Update("DeleteProdTran", data); } req.TranList[0].ErrorNumber = 0; req.TranList[0].ErrorMessage = "SUCCESS"; req.TranList[0].ReturnValue = prod_id; } if (isTran) { DaoFactory.Instance.CommitTransaction(); } } catch (Exception ex) { if (isTran) { DaoFactory.Instance.RollBackTransaction(); } throw new Exception(ex.Message); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
/// <summary> /// Save /// 데이터 저장(Insert, Update) /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet Save(DBTranSet req) { bool isTran = false; string keyField = string.Empty; object keyValue = null; bool isKey = false; try { if (req.IsTransaction) { DaoFactory.Instance.BeginTransaction(); isTran = true; } try { foreach (DBTranData data in req.TranList) { if (data.Data == null) { continue; } if (data.Data.GetType() == typeof(DataTable) && (data.Data as DataTable).Rows.Count == 0) { continue; } IList <DataMap> list = null; if (data.Data.GetType() == typeof(DataTable)) { list = (data.Data as DataTable).ToDataMapList(); } else if (data.Data.GetType() == typeof(DataMap)) { list = new List <DataMap>(); list.Add((data.Data as DataMap)); } else { continue; } foreach (DataMap map in list) { map.SetValue("INS_USER", req.UserId); if (isKey && data.IsMaster == false && keyField.ToStringNullToEmpty() != "" && keyValue.ToStringNullToEmpty() != "") { map.SetValue(keyField, keyValue); } if (map.GetValue("ROWSTATE").ToStringNullToEmpty() == "INSERT") { keyValue = DaoFactory.Instance.Insert(string.Format("Insert{0}", data.SqlId), map); } else if (map.GetValue("ROWSTATE").ToStringNullToEmpty() == "UPDATE") { DaoFactory.Instance.Update(string.Format("Update{0}", data.SqlId), map); if (data.KeyField.ToStringNullToEmpty() != "") { keyValue = map.GetValue(data.KeyField); } } else if (map.GetValue("ROWSTATE").ToStringNullToEmpty() == "DELETE") { DaoFactory.Instance.Update(string.Format("Delete{0}", data.SqlId), map); if (data.KeyField.ToStringNullToEmpty() != "") { keyValue = map.GetValue(data.KeyField); } } else if (map.GetValue("ROWSTATE").ToStringNullToEmpty() == "UPSERT") { DaoFactory.Instance.Insert(string.Format("Upsert{0}", data.SqlId), map); if (data.KeyField.ToStringNullToEmpty() != "") { keyValue = map.GetValue(data.KeyField); } } if (data.IsMaster && data.KeyField.ToStringNullToEmpty() != "") { isKey = true; keyField = data.KeyField; } } data.ReturnValue = keyValue; data.ReturnMessage = "SUCCESS"; } if (req.IsTransaction && isTran) { DaoFactory.Instance.CommitTransaction(); } } catch (Exception ex) { if (req.IsTransaction && isTran) { DaoFactory.Instance.RollBackTransaction(); } throw new Exception(ex.Message); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet Save(DBTranSet req) { bool isTran = false; try { if (req == null) { throw new Exception("처리할 요청이 정확하지 않습니다."); } if (req.TranList == null || req.TranList.Length == 0) { throw new Exception("처리할 데이터가 없습니다."); } DaoFactory.Instance.BeginTransaction(); isTran = true; try { if (req.TranList.Length > 0) { if (req.TranList[0].Data == null) { throw new Exception("저장할 데이터가 존재하지 않습니다."); } DataMap data = (req.TranList[0].Data as DataTable).ToDataMapList()[0]; if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "INSERT") { DaoFactory.Instance.Insert("InsertCostPrice", data); } else if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "UPDATE") { DaoFactory.Instance.Update("UpdateCostPrice", data); } else if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "DELETE") { DaoFactory.Instance.Update("DeleteCostPrice", data); } req.TranList[0].ErrorNumber = 0; req.TranList[0].ErrorMessage = "SUCCESS"; req.TranList[0].ReturnValue = null; } if (isTran) { DaoFactory.Instance.CommitTransaction(); } } catch (Exception ex) { if (isTran) { DaoFactory.Instance.RollBackTransaction(); } throw new Exception(ex.Message); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet SaveSalesPrice(DBTranSet req) { bool isTran = false; try { if (req == null) { throw new Exception("처리할 요청이 정확하지 않습니다."); } if (req.TranList == null || req.TranList.Length == 0) { throw new Exception("처리할 데이터가 없습니다."); } DaoFactory.Instance.BeginTransaction(); isTran = true; try { object product_id = null; object reg_id = null; if (req.TranList.Length > 0) { if (req.TranList[0].Data == null) { throw new Exception("상품정보를 저장할 데이터가 존재하지 않습니다."); } DataMap data = req.TranList[0].Data as DataMap; data.SetValue("INS_USER", req.UserId); product_id = data.GetValue("PRODUCT_ID"); if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "INSERT") { reg_id = DaoFactory.Instance.Insert("InsertSalesPrice", data); } else if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "UPDATE") { reg_id = data.GetValue("REG_ID"); DaoFactory.Instance.Update("UpdateSalesPrice", data); } else if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "DELETE") { reg_id = data.GetValue("REG_ID"); DaoFactory.Instance.Update("DeleteSalesPrice", data); } req.TranList[0].ErrorNumber = 0; req.TranList[0].ErrorMessage = "SUCCESS"; req.TranList[0].ReturnValue = reg_id; } if (isTran) { DaoFactory.Instance.CommitTransaction(); } } catch (Exception ex) { if (isTran) { DaoFactory.Instance.RollBackTransaction(); } throw new Exception(ex.Message); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet Save(DBTranSet req) { bool isTran = false; try { if (req == null) { throw new Exception("처리할 요청이 정확하지 않습니다."); } if (req.TranList == null || req.TranList.Length == 0) { throw new Exception("처리할 데이터가 없습니다."); } DaoFactory.Instance.BeginTransaction(); isTran = true; try { object product_id = null; object reg_id = null; string product_code = string.Empty; //상품정보 저장 if (req.TranList.Length > 0) { if (req.TranList[0].Data == null) { throw new Exception("상품정보를 저장할 데이터가 존재하지 않습니다."); } DataMap data = req.TranList[0].Data as DataMap; data.SetValue("INS_USER", req.UserId); if (string.IsNullOrEmpty(data.GetValue("PRODUCT_CODE").ToStringNullToEmpty())) { product_code = CommonDataUtils.GetProductCode(data.GetValue("PRODUCT_TYPE").ToString()); data.SetValue("PRODUCT_CODE", product_code); } if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "INSERT") { product_id = DaoFactory.Instance.Insert("InsertProduct", data); } else if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "UPDATE") { DaoFactory.Instance.Update("UpdateProduct", data); product_id = data.GetValue("PRODUCT_ID"); } else if (data.GetValue("ROWSTATE").ToStringNullToEmpty() == "DELETE") { DaoFactory.Instance.Update("DeleteProduct", data); product_id = data.GetValue("PRODUCT_ID"); } req.TranList[0].ErrorNumber = 0; req.TranList[0].ErrorMessage = "SUCCESS"; req.TranList[0].ReturnValue = product_id; } //원부자재정보 저장 if (req.TranList.Length > 1) { if (req.TranList[1].Data != null && (req.TranList[1].Data as DataTable).Rows.Count > 0) { IList <DataMap> list = (req.TranList[1].Data as DataTable).ToDataMapList(); foreach (DataMap map in list) { map.SetValue("PRODUCT_ID", product_id); map.SetValue("INS_USER", req.UserId); if (map.GetValue("ROWSTATE").ToStringNullToEmpty() == "INSERT") { reg_id = DaoFactory.Instance.Insert("InsertProductMaterial", map); } else if (map.GetValue("ROWSTATE").ToStringNullToEmpty() == "UPDATE") { DaoFactory.Instance.Update("UpdateProductMaterial", map); reg_id = map.GetValue("REG_ID"); } else if (map.GetValue("ROWSTATE").ToStringNullToEmpty() == "DELETE") { DaoFactory.Instance.Update("DeleteProductMaterial", map); reg_id = map.GetValue("REG_ID"); } } req.TranList[1].ErrorNumber = 0; req.TranList[1].ErrorMessage = "SUCCESS"; req.TranList[1].ReturnValue = product_id; } } if (isTran) { DaoFactory.Instance.CommitTransaction(); } } catch (Exception ex) { if (isTran) { DaoFactory.Instance.RollBackTransaction(); } throw new Exception(ex.Message); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
/// <summary> /// Save /// 데이터 저장(Insert, Update) /// </summary> /// <param name="req">WasRequest</param> /// <returns>WasRequest</returns> public static DBTranSet Save(DBTranSet req) { bool isTran = false; try { if (req == null) { throw new Exception("처리할 요청이 정확하지 않습니다."); } if (req.TranList == null || req.TranList.Length == 0) { throw new Exception("처리할 데이터가 없습니다."); } DaoFactory.Instance.BeginTransaction(); isTran = true; try { string rowState = string.Empty; object customer_id = null; object biz_reg_id = null; object biz_address_id = null; //거래처정보 저장 if (req.TranList.Length > 0) { if (req.TranList[0].Data == null || (req.TranList[0].Data as DataTable).Rows.Count == 0) { throw new Exception("거래처정보를 저장할 데이터가 존재하지 않습니다."); } DataMap data = (req.TranList[0].Data as DataTable).ToDataMapList()[0]; data.SetValue("INS_USER", req.UserId); rowState = data.GetValue("ROWSTATE").ToStringNullToEmpty(); //주소등록 if (rowState == "INSERT" || rowState == "UPDATE") { var addr = DaoFactory.Instance.QueryForObject("GetAddressId", new DataMap() { { "ADDRESS_ID", data.GetValue("ADDRESS_ID") } }); if (addr.ToStringNullToEmpty().IsNullOrEmpty()) { if (!data.GetValue("POST_NO").ToStringNullToEmpty().IsNullOrEmpty() || !data.GetValue("ZONE_NO").ToStringNullToEmpty().IsNullOrEmpty() || !data.GetValue("ADDRESS1").ToStringNullToEmpty().IsNullOrEmpty() || !data.GetValue("ADDRESS2").ToStringNullToEmpty().IsNullOrEmpty()) { biz_address_id = DaoFactory.Instance.Insert("InsertAddress", data); if (biz_address_id.ToStringNullToEmpty().IsNullOrEmpty()) { throw new Exception("사업자정보의 주소를 저장하는 중 오류가 발생하였습니다."); } data.SetValue("ADDRESS_ID", biz_address_id); } } else { DaoFactory.Instance.Update("UpdateAddress", data); } var bizId = DaoFactory.Instance.QueryForObject("GetBizRegId", new DataMap() { { "BIZ_REG_ID", data.GetValue("BIZ_REG_ID") } }); if (bizId.ToStringNullToEmpty().IsNullOrEmpty()) { if (!data.GetValue("BIZ_REG_NO").ToStringNullToEmpty().IsNullOrEmpty()) { biz_reg_id = DaoFactory.Instance.Insert("InsertBizRegCe", data); if (biz_reg_id.ToStringNullToEmpty().IsNullOrEmpty()) { throw new Exception("사업자정보를 저장하지 못했습니다."); } data.SetValue("BIZ_REG_ID", biz_reg_id); } } else { DaoFactory.Instance.Update("UpdateBizRegCe", data); } } if (rowState == "INSERT") { customer_id = DaoFactory.Instance.Insert("InsertCustomer", data); if (customer_id.ToStringNullToEmpty().IsNullOrEmpty()) { throw new Exception("거래처정보를 저장하지 못했습니다."); } } else if (rowState == "UPDATE") { DaoFactory.Instance.Update("UpdateCustomer", data); customer_id = data.GetValue("CUSTOMER_ID"); } else if (rowState == "DELETE") { DaoFactory.Instance.Update("DeleteCustomer", data); customer_id = data.GetValue("CUSTOMER_ID"); } req.TranList[0].ErrorNumber = 0; req.TranList[0].ErrorMessage = "SUCCESS"; req.TranList[0].ReturnValue = customer_id; } if (isTran) { DaoFactory.Instance.CommitTransaction(); } } catch (Exception ex) { if (isTran) { DaoFactory.Instance.RollBackTransaction(); } throw new Exception(ex.Message); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }
public static DBTranSet SaveCustomerAddress(DBTranSet req) { bool isTran = false; try { if (req == null) { throw new Exception("처리할 요청이 정확하지 않습니다."); } if (req.TranList == null || req.TranList.Length == 0) { throw new Exception("처리할 데이터가 없습니다."); } DaoFactory.Instance.BeginTransaction(); isTran = true; try { string rowState = string.Empty; object reg_id = null; object address_id = null; if (req.TranList.Length > 0) { if (req.TranList[0].Data == null || (req.TranList[0].Data as DataTable).Rows.Count == 0) { throw new Exception("저장할 데이터가 존재하지 않습니다."); } foreach (DataRow row in (req.TranList[0].Data as DataTable).Rows) { DataMap map = row.ToDataMap(); if (map == null || map.Count == 0) { continue; } map.SetValue("INS_USER", req.UserId); rowState = map.GetValue("ROWSTATE").ToString(); if (rowState == "INSERT" || rowState == "UPDATE") { var addr = DaoFactory.Instance.QueryForObject("GetAddressId", new DataMap() { { "ADDRESS_ID", map.GetValue("ADDRESS_ID") } }); if (addr.ToStringNullToEmpty().IsNullOrEmpty()) { if (!map.GetValue("POST_NO").ToStringNullToEmpty().IsNullOrEmpty() || !map.GetValue("ZONE_NO").ToStringNullToEmpty().IsNullOrEmpty() || !map.GetValue("ADDRESS1").ToStringNullToEmpty().IsNullOrEmpty() || !map.GetValue("ADDRESS2").ToStringNullToEmpty().IsNullOrEmpty()) { address_id = DaoFactory.Instance.Insert("InsertAddress", map); if (address_id.ToStringNullToEmpty().IsNullOrEmpty()) { throw new Exception("주소를 저장하는 중 오류가 발생하였습니다."); } map.SetValue("ADDRESS_ID", address_id); } } else { DaoFactory.Instance.Update("UpdateAddress", map); } } if (rowState == "INSERT") { reg_id = DaoFactory.Instance.Insert("InsertCustomerAddress", map); if (reg_id.ToStringNullToEmpty().IsNullOrEmpty()) { throw new Exception("거래처 주소정보를 저장하지 못했습니다."); } } else if (rowState == "UPDATE") { DaoFactory.Instance.Update("UpdateCustomerAddress", map); reg_id = map.GetValue("REG_ID"); } else if (rowState == "DELETE") { DaoFactory.Instance.Update("DeleteCustomer", map); reg_id = map.GetValue("REG_ID"); } req.TranList[0].ErrorNumber = 0; req.TranList[0].ErrorMessage = "SUCCESS"; req.TranList[0].ReturnValue = reg_id; } } if (isTran) { DaoFactory.Instance.CommitTransaction(); } } catch (Exception ex) { if (isTran) { DaoFactory.Instance.RollBackTransaction(); } throw new Exception(ex.Message); } return(req); } catch (Exception ex) { req.ErrorNumber = ex.HResult; req.ErrorMessage = ex.Message; return(req); } }