public static EntityObject_MCE_B_ASSETS_CONTRACT_PAY Get(EntityObject_MCE_B_ASSETS_CONTRACT_PAY obj, IDbTransaction trans) { //平台自动生成代码 string sSql = "select PERIODS, BASE_ID, PLAN_PAY_DATE, COMMENTS, STATE, MONEY, ID, ACTUAL_PAY_DATE from MCE_B_ASSETS_CONTRACT_PAY where ID = :ID "; #region Parameters Block OracleParameter[] parameters = new OracleParameter[1]; parameters[0] = new OracleParameter(); parameters[0].ParameterName = ":ID"; parameters[0].Size = 36; parameters[0].OracleType = System.Data.OracleClient.OracleType.Char; parameters[0].Value = obj.ID; #endregion #region Push Block EntityObject_MCE_B_ASSETS_CONTRACT_PAY dataObj = null; ArrayList objArray = new ArrayList(); IDataReader sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, trans); while (sqlReader.Read()) { dataObj = new EntityObject_MCE_B_ASSETS_CONTRACT_PAY(); if (!sqlReader.IsDBNull(0)) { dataObj.PERIODS = sqlReader.GetDecimal(0); } if (!sqlReader.IsDBNull(1)) { dataObj.BASE_ID = sqlReader.GetString(1); } if (!sqlReader.IsDBNull(2)) { dataObj.PLAN_PAY_DATE = sqlReader.GetDateTime(2); } if (!sqlReader.IsDBNull(3)) { dataObj.COMMENTS = sqlReader.GetString(3); } if (!sqlReader.IsDBNull(4)) { dataObj.STATE = sqlReader.GetDecimal(4); } if (!sqlReader.IsDBNull(5)) { dataObj.MONEY = sqlReader.GetDecimal(5); } if (!sqlReader.IsDBNull(6)) { dataObj.ID = sqlReader.GetString(6); } if (!sqlReader.IsDBNull(7)) { dataObj.ACTUAL_PAY_DATE = sqlReader.GetDateTime(7); } objArray.Add(dataObj); } sqlReader.Close(); #endregion EntityObject_MCE_B_ASSETS_CONTRACT_PAY[] objs = new EntityObject_MCE_B_ASSETS_CONTRACT_PAY[objArray.Count]; objArray.CopyTo(0, objs, 0, objs.Length); return(objs.Length == 0 ? null:objs[0]); }
public BizLogicMsg Contract_Pay2(List <string> listID) { if (LocalMode) { BizLogicMsg msg = new BizLogicMsg(); using (IDbConnection connection = IDALProvider.IDAL.PopConnection()) { using (IDbTransaction transaction = connection.BeginTransaction()) { try { foreach (string strID in listID) { EntityObject_MCE_B_ASSETS_CONTRACT_PAY obj = new EntityObject_MCE_B_ASSETS_CONTRACT_PAY(); obj.ID = strID; obj = HelperObject_MCE_B_ASSETS_CONTRACT_PAY.Get(obj); if (obj != null) { if (obj.STATE == 1) { throw new Exception("已经付款的数据不能再付款."); } obj.STATE = 1; obj.ACTUAL_PAY_DATE = DateTime.Now; HelperObject_MCE_B_ASSETS_CONTRACT_PAY.Update(obj, transaction); } } //平台自动生成代码 transaction.Commit(); } catch (Exception expt) { transaction.Rollback(); msg = new BizLogicMsg(false, expt.Message); Error(expt); } finally { IDALProvider.IDAL.PushConnection(connection); } } } return(msg); } else { using (ServiceManager <ServiceContract_MCE_B_ASSETS_CONTRACT> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_CONTRACT>(ServiceUri)) { return(smgr.Service.Contract_Pay2(listID)); } } }
public static int Update(EntityObject_MCE_B_ASSETS_CONTRACT_PAY obj, IDbTransaction trans) { //平台自动生成代码 #region Parameters Block OracleParameter[] parameters = null; #endregion string sSql = "update MCE_B_ASSETS_CONTRACT_PAY set "; sSql += PrepareUpdate(obj, out parameters, true); sSql += " where ID = :U_ID "; return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans)); }
public static int Save(EntityObject_MCE_B_ASSETS_CONTRACT_PAY obj, IDbTransaction trans) { //平台自动生成代码 obj.ID = Guid.NewGuid().ToString(); string sSql = "insert into MCE_B_ASSETS_CONTRACT_PAY( PERIODS, BASE_ID, PLAN_PAY_DATE, COMMENTS, STATE, MONEY, ID, ACTUAL_PAY_DATE) values ( :PERIODS, :BASE_ID, :PLAN_PAY_DATE, :COMMENTS, :STATE, :MONEY, :ID, :ACTUAL_PAY_DATE)"; #region Parameters Block OracleParameter[] parameters = new OracleParameter[8]; parameters[0] = new OracleParameter(); parameters[0].ParameterName = ":PERIODS"; parameters[0].Size = 22; parameters[0].OracleType = System.Data.OracleClient.OracleType.Number; parameters[0].Value = obj.PERIODS; parameters[1] = new OracleParameter(); parameters[1].ParameterName = ":BASE_ID"; parameters[1].Size = 36; parameters[1].OracleType = System.Data.OracleClient.OracleType.Char; parameters[1].Value = obj.BASE_ID == null ? String.Empty:obj.BASE_ID; parameters[2] = new OracleParameter(); parameters[2].ParameterName = ":PLAN_PAY_DATE"; parameters[2].Size = 7; parameters[2].OracleType = System.Data.OracleClient.OracleType.DateTime; parameters[2].Value = obj.PLAN_PAY_DATE; parameters[3] = new OracleParameter(); parameters[3].ParameterName = ":COMMENTS"; parameters[3].Size = 200; parameters[3].OracleType = System.Data.OracleClient.OracleType.VarChar; parameters[3].Value = obj.COMMENTS == null ? String.Empty:obj.COMMENTS; parameters[4] = new OracleParameter(); parameters[4].ParameterName = ":STATE"; parameters[4].Size = 22; parameters[4].OracleType = System.Data.OracleClient.OracleType.Number; parameters[4].Value = obj.STATE; parameters[5] = new OracleParameter(); parameters[5].ParameterName = ":MONEY"; parameters[5].Size = 22; parameters[5].OracleType = System.Data.OracleClient.OracleType.Number; parameters[5].Value = obj.MONEY; parameters[6] = new OracleParameter(); parameters[6].ParameterName = ":ID"; parameters[6].Size = 36; parameters[6].OracleType = System.Data.OracleClient.OracleType.Char; parameters[6].Value = obj.ID == null ? String.Empty:obj.ID; parameters[7] = new OracleParameter(); parameters[7].ParameterName = ":ACTUAL_PAY_DATE"; parameters[7].Size = 7; parameters[7].OracleType = System.Data.OracleClient.OracleType.DateTime; parameters[7].Value = obj.ACTUAL_PAY_DATE; #endregion return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans)); }
public static int Delete(EntityObject_MCE_B_ASSETS_CONTRACT_PAY obj, IDbTransaction trans) { //平台自动生成代码 string sSql = "delete from MCE_B_ASSETS_CONTRACT_PAY where ID = :ID "; #region Parameters Block OracleParameter[] parameters = new OracleParameter[1]; parameters[0] = new OracleParameter(); parameters[0].ParameterName = ":ID"; parameters[0].Size = 36; parameters[0].OracleType = System.Data.OracleClient.OracleType.Char; parameters[0].Value = obj.ID; #endregion return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans)); }
public static int Update(EntityObject_MCE_B_ASSETS_CONTRACT_PAY obj, CauseObject_MCE_B_ASSETS_CONTRACT_PAY cause, IDbTransaction trans) { //平台自动生成代码 #region Parameters Block List <OracleParameter> list = new List <OracleParameter>(); OracleParameter[] parameters = null; #endregion string sSql = "update MCE_B_ASSETS_CONTRACT_PAY set "; sSql += PrepareUpdate(obj, out parameters, false); list.AddRange(parameters); sSql += " where 1=1 "; sSql += PrepareCause(cause, out parameters); list.AddRange(parameters); parameters = list.ToArray(); return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans)); }
public static string PrepareUpdate(EntityObject_MCE_B_ASSETS_CONTRACT_PAY obj, out OracleParameter[] parameters, bool appendpk) { //平台自动生成代码 List <string> strBuf = new List <string>(); ArrayList paramList = new ArrayList(); OracleParameter param = null; #region Push Block if (!obj.IsNotUpdate("PERIODS")) { strBuf.Add(" MCE_B_ASSETS_CONTRACT_PAY.PERIODS = :U_PERIODS"); param = new OracleParameter(); param.ParameterName = ":U_PERIODS"; param.OracleType = System.Data.OracleClient.OracleType.Number; param.Size = 22; param.Value = obj.PERIODS; paramList.Add(param); } if (!obj.IsNotUpdate("BASE_ID")) { strBuf.Add(" MCE_B_ASSETS_CONTRACT_PAY.BASE_ID = :U_BASE_ID"); param = new OracleParameter(); param.ParameterName = ":U_BASE_ID"; param.OracleType = System.Data.OracleClient.OracleType.Char; param.Size = 36; param.Value = string.IsNullOrEmpty(obj.BASE_ID) ? string.Empty : obj.BASE_ID; paramList.Add(param); } if (!obj.IsNotUpdate("PLAN_PAY_DATE")) { strBuf.Add(" MCE_B_ASSETS_CONTRACT_PAY.PLAN_PAY_DATE = :U_PLAN_PAY_DATE"); param = new OracleParameter(); param.ParameterName = ":U_PLAN_PAY_DATE"; param.OracleType = System.Data.OracleClient.OracleType.DateTime; param.Size = 7; param.Value = obj.PLAN_PAY_DATE; paramList.Add(param); } if (!obj.IsNotUpdate("COMMENTS")) { strBuf.Add(" MCE_B_ASSETS_CONTRACT_PAY.COMMENTS = :U_COMMENTS"); param = new OracleParameter(); param.ParameterName = ":U_COMMENTS"; param.OracleType = System.Data.OracleClient.OracleType.VarChar; param.Size = 200; param.Value = string.IsNullOrEmpty(obj.COMMENTS) ? string.Empty : obj.COMMENTS; paramList.Add(param); } if (!obj.IsNotUpdate("STATE")) { strBuf.Add(" MCE_B_ASSETS_CONTRACT_PAY.STATE = :U_STATE"); param = new OracleParameter(); param.ParameterName = ":U_STATE"; param.OracleType = System.Data.OracleClient.OracleType.Number; param.Size = 22; param.Value = obj.STATE; paramList.Add(param); } if (!obj.IsNotUpdate("MONEY")) { strBuf.Add(" MCE_B_ASSETS_CONTRACT_PAY.MONEY = :U_MONEY"); param = new OracleParameter(); param.ParameterName = ":U_MONEY"; param.OracleType = System.Data.OracleClient.OracleType.Number; param.Size = 22; param.Value = obj.MONEY; paramList.Add(param); } if (!obj.IsNotUpdate("ACTUAL_PAY_DATE")) { strBuf.Add(" MCE_B_ASSETS_CONTRACT_PAY.ACTUAL_PAY_DATE = :U_ACTUAL_PAY_DATE"); param = new OracleParameter(); param.ParameterName = ":U_ACTUAL_PAY_DATE"; param.OracleType = System.Data.OracleClient.OracleType.DateTime; param.Size = 7; param.Value = obj.ACTUAL_PAY_DATE; paramList.Add(param); } //pk here if (appendpk) { param = new OracleParameter(); param.ParameterName = ":U_ID"; param.OracleType = System.Data.OracleClient.OracleType.Char; param.Size = 36; param.Value = obj.ID; paramList.Add(param); } #endregion parameters = new OracleParameter[paramList.Count]; paramList.CopyTo(parameters); return(string.Join(", ", strBuf.ToArray())); }
public BizLogicMsg Continue_Ext2(string strID) { if (LocalMode) { BizLogicMsg msg = new BizLogicMsg(); using (IDbConnection connection = IDALProvider.IDAL.PopConnection()) { using (IDbTransaction transaction = connection.BeginTransaction()) { try { EntityObject_MCE_B_ASSETS_CONTRACT obj = new EntityObject_MCE_B_ASSETS_CONTRACT(); obj.ID = strID; obj = HelperObject_MCE_B_ASSETS_CONTRACT.Get(obj); if (obj != null) { obj.CONTRACT_STATE = 2; HelperObject_MCE_B_ASSETS_CONTRACT.Update(obj, transaction); string strCode = BizLogicObject_MCE_B_ASSETS.Proxy.Generate_Bill_Code("MceContract"); obj.CODE = strCode; obj.STATE = 1; obj.CONTRACT_STATE = 1; HelperObject_MCE_B_ASSETS_CONTRACT.Save(obj, transaction); DisplayObject_MCE_B_ASSETS_CONTRACT_D[] list_D = BizLogicObject_MCE_B_ASSETS_CONTRACT_D.Proxy.Query(new CauseObject_MCE_B_ASSETS_CONTRACT_D() { BASE_ID = strID }); if (list_D != null && list_D.Length > 0) { foreach (DisplayObject_MCE_B_ASSETS_CONTRACT_D item_D in list_D) { EntityObject_MCE_B_ASSETS_CONTRACT_D obj_D = new EntityObject_MCE_B_ASSETS_CONTRACT_D(); obj_D.ID = item_D.ID; obj_D = HelperObject_MCE_B_ASSETS_CONTRACT_D.Get(obj_D); if (obj_D != null) { obj_D.BASE_ID = obj.ID; HelperObject_MCE_B_ASSETS_CONTRACT_D.Save(obj_D, transaction); } } } DisplayObject_MCE_B_ASSETS_CONTRACT_PAY[] list_P = BizLogicObject_MCE_B_ASSETS_CONTRACT_PAY.Proxy.Query(new CauseObject_MCE_B_ASSETS_CONTRACT_PAY() { BASE_ID = strID }); if (list_P != null && list_P.Length > 0) { foreach (DisplayObject_MCE_B_ASSETS_CONTRACT_PAY item_P in list_P) { EntityObject_MCE_B_ASSETS_CONTRACT_PAY obj_P = new EntityObject_MCE_B_ASSETS_CONTRACT_PAY(); obj_P.ID = item_P.ID; obj_P = HelperObject_MCE_B_ASSETS_CONTRACT_PAY.Get(obj_P); if (obj_P != null) { obj_P.BASE_ID = obj.ID; HelperObject_MCE_B_ASSETS_CONTRACT_PAY.Save(obj_P, transaction); } } } CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE(); pCOM_FILE.REF_TAB_ID = strID; pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_CONTRACT"; DisplayObject_COM_FILE[] list_F = HelperObject_COM_FILE.Query(pCOM_FILE); if (list_F != null && list_F.Length > 0) { foreach (DisplayObject_COM_FILE item_F in list_F) { EntityObject_COM_FILE obj_F = new EntityObject_COM_FILE(); obj_F.ID = item_F.ID; obj_F = HelperObject_COM_FILE.Get(obj_F); if (obj_F != null) { obj_F.REF_TAB_ID = obj.ID; HelperObject_COM_FILE.Save(obj_F, transaction); } } } } //平台自动生成代码 transaction.Commit(); } catch (Exception expt) { transaction.Rollback(); msg = new BizLogicMsg(false, expt.Message); Error(expt); } finally { IDALProvider.IDAL.PushConnection(connection); } } } return(msg); } else { using (ServiceManager <ServiceContract_MCE_B_ASSETS_CONTRACT> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_CONTRACT>(ServiceUri)) { return(smgr.Service.Continue_Ext2(strID)); } } }
public BizLogicMsg Save_Ext2(JsonMCE_Contract json) { if (LocalMode) { BizLogicMsg msg = new BizLogicMsg(); using (IDbConnection connection = IDALProvider.IDAL.PopConnection()) { using (IDbTransaction transaction = connection.BeginTransaction()) { try { EntityObject_MCE_B_ASSETS_CONTRACT entity = new EntityObject_MCE_B_ASSETS_CONTRACT(); if (!string.IsNullOrEmpty(json.ID)) { entity.ID = json.ID; entity = HelperObject_MCE_B_ASSETS_CONTRACT.Get(entity); if (entity == null) { throw new Exception("获取数据出错."); } } entity.CODE = json.CODE; entity.NAME = json.NAME; if (!string.IsNullOrEmpty(json.SIGN_DATE)) { entity.SIGN_DATE = DateTime.Parse(json.SIGN_DATE); } if (!string.IsNullOrEmpty(json.EXPIRE_DATE)) { entity.EXPIRE_DATE = DateTime.Parse(json.EXPIRE_DATE); } entity.TYPE_ID = json.TYPE_ID; entity.FIRST_PARTY = json.FIRST_PARTY; entity.SECOND_PARTY = json.SECOND_PARTY; entity.SECOND_LINK_PERSON = json.SECOND_LINK_PERSON; entity.SECOND_LINK_PHONE = json.SECOND_LINK_PHONE; if (!string.IsNullOrEmpty(json.MONEY)) { entity.MONEY = decimal.Parse(json.MONEY); } entity.ARCHIVE_NO = json.ARCHIVE_NO; if (!string.IsNullOrEmpty(json.CHECK_DATE)) { entity.CHECK_DATE = DateTime.Parse(json.CHECK_DATE); } entity.ARCHIVIST = json.ARCHIVIST; entity.INPUT_PERSON = json.INPUT_PERSON; entity.CONTRACT_CONTENT = json.CONTRACT_CONTENT; entity.STATE = 1; if (string.IsNullOrEmpty(json.ID)) { entity.CONTRACT_STATE = 1; entity.CREATE_TIME = DateTime.Now; entity.CREATE_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID; int amount = HelperObject_MCE_B_ASSETS_CONTRACT.Save(entity, transaction); } else { entity.MODIFY_TIME = DateTime.Now; entity.MODIFY_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID; int amount = HelperObject_MCE_B_ASSETS_CONTRACT.Update(entity, transaction); CauseObject_MCE_B_ASSETS_CONTRACT_D pCONTRACT_D = new CauseObject_MCE_B_ASSETS_CONTRACT_D(); pCONTRACT_D.BASE_ID = json.ID; HelperObject_MCE_B_ASSETS_CONTRACT_D.Delete(pCONTRACT_D, transaction); CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE(); pCOM_FILE.REF_TAB_ID = entity.ID; pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_CONTRACT"; HelperObject_COM_FILE.Delete(pCOM_FILE, transaction); DisplayObject_MCE_B_ASSETS_CONTRACT_PAY[] list_Pay = BizLogicObject_MCE_B_ASSETS_CONTRACT_PAY.Proxy.Query(new CauseObject_MCE_B_ASSETS_CONTRACT_PAY() { BASE_ID = entity.ID }); if (list_Pay != null && list_Pay.Length > 0) { foreach (DisplayObject_MCE_B_ASSETS_CONTRACT_PAY item_Pay in list_Pay) { var v_Pay = json.listPay.Find(l => l.ID == item_Pay.ID); if (v_Pay == null) { HelperObject_MCE_B_ASSETS_CONTRACT_PAY.Delete(item_Pay, transaction); } } } } if (json.children != null && json.children.Count > 0) { foreach (JsonMCE_Contract_D item in json.children) { EntityObject_MCE_B_ASSETS_CONTRACT_D entity_D = new EntityObject_MCE_B_ASSETS_CONTRACT_D(); entity_D.BASE_ID = entity.ID; entity_D.ASSET_ID = item.ASSET_ID; HelperObject_MCE_B_ASSETS_CONTRACT_D.Save(entity_D, transaction); } } if (json.listPay != null && json.listPay.Count > 0) { foreach (JsonMCE_Contract_Pay item in json.listPay) { EntityObject_MCE_B_ASSETS_CONTRACT_PAY entity_D = new EntityObject_MCE_B_ASSETS_CONTRACT_PAY(); if (!string.IsNullOrEmpty(item.ID)) { entity_D.ID = item.ID; entity_D = HelperObject_MCE_B_ASSETS_CONTRACT_PAY.Get(entity_D); if (entity_D == null) { throw new Exception("获取数据出错."); } } entity_D.BASE_ID = entity.ID; entity_D.PERIODS = item.PERIODS; if (!string.IsNullOrEmpty(item.MONEY)) { entity_D.MONEY = decimal.Parse(item.MONEY); } if (!string.IsNullOrEmpty(item.PLAN_PAY_DATE)) { entity_D.PLAN_PAY_DATE = DateTime.Parse(item.PLAN_PAY_DATE); } if (string.IsNullOrEmpty(item.ID)) { entity_D.STATE = 2; HelperObject_MCE_B_ASSETS_CONTRACT_PAY.Save(entity_D, transaction); } else { HelperObject_MCE_B_ASSETS_CONTRACT_PAY.Update(entity_D, transaction); } } } if (json.listAttach != null && json.listAttach.Count > 0) { foreach (JsonMCEMT_APPLY_MTN_ATTACH item in json.listAttach) { Ipedf.Web.Entity.EntityObject_COM_FILE entityPicFile = new Ipedf.Web.Entity.EntityObject_COM_FILE(); entityPicFile.REF_TAB_NAME = "MCE_B_ASSETS_CONTRACT"; entityPicFile.CLIENT_NAME = item.CLIENT_NAME; entityPicFile.STATE = 1; entityPicFile.CREATE_TIME = item.CREATE_TIME; entityPicFile.CREATE_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID; entityPicFile.REF_TAB_ID = entity.ID; entityPicFile.SERVER_NAME = item.SERVER_NAME; entityPicFile.IS_IMPORT = 0; Ipedf.Web.DataAccess.HelperObject_COM_FILE.Save(entityPicFile, transaction); } } msg.Message = entity.ID; transaction.Commit(); } catch (Exception expt) { transaction.Rollback(); msg = new BizLogicMsg(false, expt.Message); Error(expt); } finally { IDALProvider.IDAL.PushConnection(connection); } } } return(msg); } else { using (ServiceManager <ServiceContract_MCE_B_ASSETS_CONTRACT> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_CONTRACT>(ServiceUri)) { return(smgr.Service.Save_Ext2(json)); } } }