public ResultModel Load(UserModel user,int allotId,NFMT.Common.StatusEnum status = NFMT.Common.StatusEnum.已生效)
{
ResultModel result = new ResultModel();
try
{
string cmdText = string.Format("select crr.* from dbo.Fun_CorpReceivable_Ref crr inner join dbo.Fun_RecAllotDetail rad on crr.DetailId = crr.DetailId and rad.DetailStatus>={0} where crr.AllotId ={1}",(int)status,allotId);
DataTable dt = SqlHelper.ExecuteDataTable(ConnectString,cmdText, null, CommandType.Text);
List<CorpReceivable> corpReceivables = new List<CorpReceivable>();
foreach (DataRow dr in dt.Rows)
{
CorpReceivable corpreceivable = new CorpReceivable();
corpreceivable.RefId = Convert.ToInt32(dr["RefId"]);
if (dr["AllotId"] != DBNull.Value)
{
corpreceivable.AllotId = Convert.ToInt32(dr["AllotId"]);
}
if (dr["DetailId"] != DBNull.Value)
{
corpreceivable.DetailId = Convert.ToInt32(dr["DetailId"]);
}
if (dr["BlocId"] != DBNull.Value)
{
corpreceivable.BlocId = Convert.ToInt32(dr["BlocId"]);
}
if (dr["CorpId"] != DBNull.Value)
{
corpreceivable.CorpId = Convert.ToInt32(dr["CorpId"]);
}
if (dr["RecId"] != DBNull.Value)
{
corpreceivable.RecId = Convert.ToInt32(dr["RecId"]);
}
if (dr["IsShare"] != DBNull.Value)
{
corpreceivable.IsShare = Convert.ToBoolean(dr["IsShare"]);
}
corpReceivables.Add(corpreceivable);
}
result.AffectCount = dt.Rows.Count;
result.Message = "获取列表成功";
result.ResultStatus = 0;
result.ReturnValue = corpReceivables;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return result;
}
public ResultModel GetCorpReceivableByAllotId(UserModel user, int allotId)
{
ResultModel result = new ResultModel();
try
{
string sql = string.Format("select * from Fun_CorpReceivable_Ref where AllotId = {0} and RefStatus = {1}", allotId, (int)Common.StatusEnum.已生效);
DataTable dt = NFMT.DBUtility.SqlHelper.ExecuteDataTable(this.ConnectString, sql, null, CommandType.Text);
if (dt != null && dt.Rows.Count > 0)
{
List<CorpReceivable> corpReceivables = new List<CorpReceivable>();
foreach (DataRow dr in dt.Rows)
{
CorpReceivable corpreceivable = new CorpReceivable();
corpreceivable.RefId = Convert.ToInt32(dr["RefId"]);
if (dr["AllotId"] != DBNull.Value)
{
corpreceivable.AllotId = Convert.ToInt32(dr["AllotId"]);
}
if (dr["DetailId"] != DBNull.Value)
{
corpreceivable.DetailId = Convert.ToInt32(dr["DetailId"]);
}
if (dr["BlocId"] != DBNull.Value)
{
corpreceivable.BlocId = Convert.ToInt32(dr["BlocId"]);
}
if (dr["CorpId"] != DBNull.Value)
{
corpreceivable.CorpId = Convert.ToInt32(dr["CorpId"]);
}
if (dr["RecId"] != DBNull.Value)
{
corpreceivable.RecId = Convert.ToInt32(dr["RecId"]);
}
if (dr["IsShare"] != DBNull.Value)
{
corpreceivable.IsShare = Convert.ToBoolean(dr["IsShare"]);
}
corpReceivables.Add(corpreceivable);
}
result.AffectCount = dt.Rows.Count;
result.Message = "获取列表成功";
result.ResultStatus = 0;
result.ReturnValue = corpReceivables;
}
else
{
result.ResultStatus = -1;
result.Message = "获取列表失败";
}
}
catch (Exception e)
{
result.ResultStatus = -1;
result.Message = e.Message;
}
return result;
}
/// <summary>
/// 有用，创建分配公司关联表
/// </summary>
/// <param name="user"></param>
/// <param name="rec"></param>
/// <param name="details"></param>
/// <param name="corpDetail"></param>
/// <returns></returns>
public ResultModel CreateCorp(UserModel user, Model.ReceivableAllot rec, List<Model.RecAllotDetail> details,Model.CorpReceivable corpDetail)
{
ResultModel result = new ResultModel();
try
{
DAL.CorpReceivableDAL corpRecDAL = new CorpReceivableDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
rec.AllotType = (int)CashInAllotTypeEnum.Corp;
result = this.CreateMain(user, rec, ref details);
if (result.ResultStatus != 0)
return result;
foreach (Model.RecAllotDetail detail in details)
{
Model.CorpReceivable corpD = new CorpReceivable();
corpD.AllotId = detail.AllotId;
corpD.BlocId = corpDetail.BlocId;
corpD.CorpId = corpDetail.CorpId;
corpD.DetailId = detail.DetailId;
corpD.IsShare = corpDetail.IsShare;
corpD.RecId = detail.RecId;
result = corpRecDAL.Insert(user, corpD);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public override IModel CreateModel(SqlDataReader dr)
{
CorpReceivable corpreceivable = new CorpReceivable();
int indexRefId = dr.GetOrdinal("RefId");
corpreceivable.RefId = Convert.ToInt32(dr[indexRefId]);
int indexAllotId = dr.GetOrdinal("AllotId");
if (dr["AllotId"] != DBNull.Value)
{
corpreceivable.AllotId = Convert.ToInt32(dr[indexAllotId]);
}
int indexDetailId = dr.GetOrdinal("DetailId");
if (dr["DetailId"] != DBNull.Value)
{
corpreceivable.DetailId = Convert.ToInt32(dr[indexDetailId]);
}
int indexBlocId = dr.GetOrdinal("BlocId");
if (dr["BlocId"] != DBNull.Value)
{
corpreceivable.BlocId = Convert.ToInt32(dr[indexBlocId]);
}
int indexCorpId = dr.GetOrdinal("CorpId");
if (dr["CorpId"] != DBNull.Value)
{
corpreceivable.CorpId = Convert.ToInt32(dr[indexCorpId]);
}
int indexRecId = dr.GetOrdinal("RecId");
if (dr["RecId"] != DBNull.Value)
{
corpreceivable.RecId = Convert.ToInt32(dr[indexRecId]);
}
int indexIsShare = dr.GetOrdinal("IsShare");
if (dr["IsShare"] != DBNull.Value)
{
corpreceivable.IsShare = Convert.ToBoolean(dr[indexIsShare]);
}
return corpreceivable;
}
public ResultModel UpdateCorp(UserModel user, Model.ReceivableAllot rec, List<Model.RecAllotDetail> details, Model.CorpReceivable corpDetail)
{
ResultModel result = new ResultModel();
try
{
DAL.CorpReceivableDAL corpRecDAL = new CorpReceivableDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
result = this.UpdateMain(user, rec, ref details);
if (result.ResultStatus != 0)
return result;
result = corpRecDAL.Load(user, rec.ReceivableAllotId);
if (result.ResultStatus != 0)
return result;
List<Model.CorpReceivable> corpDetails = result.ReturnValue as List<Model.CorpReceivable>;
if (corpDetails == null || corpDetails.Count == 0)
{
result.ResultStatus = -1;
result.Message = "获取公司明细失败";
return result;
}
corpDetail.BlocId = corpDetails[0].BlocId;
corpDetail.CorpId = corpDetails[0].CorpId;
foreach (Model.RecAllotDetail detail in details)
{
Model.CorpReceivable corpD = new CorpReceivable();
corpD.AllotId = detail.AllotId;
corpD.BlocId = corpDetail.BlocId;
corpD.CorpId = corpDetail.CorpId;
corpD.DetailId = detail.DetailId;
corpD.IsShare = corpDetail.IsShare;
corpD.RecId = detail.RecId;
result = corpRecDAL.Insert(user, corpD);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}