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));
}
}
}
