public static T_Agree ToModel(this T_AgreeModel node)
{
return(new T_Agree()
{
Id = node.Id,
AgreeDate = DateTime.Now,
AgreeName = node.AgreeName,
AgreeNo = node.AgreeNo,
AgreeUserId = node.AgreeUserId,
AgreeUserName = node.AgreeUserName,
ApprovalUserId = node.ApprovalUserId,
ApprovalUserIds = node.ApprovalUserIds,
ApprovalUserName = node.ApprovalUserName,
ApprovalUserNames = node.ApprovalUserNames,
CostTotal = node.CostTotal,
Discount = node.Discount,
GrandTotal = node.GrandTotal,
Gst = node.Gst,
PriceTotal = node.PriceTotal,
ProjectId = node.ProjectId,
Status = node.Status,
Remark = node.Remark,
AgreeIndex = node.AgreeIndex,
});
}
/// <summary>
/// 复杂查询
/// </summary>
/// <param name="model">查询对象</param>
/// <param name="Orders">排序字典key:排序的字段,value:asc升序/desc降序</param>
/// <param name="PageSize">每页行数，默认15</param>
/// <param name="PageIndex">当前页码，默认100</param>
/// <returns></returns>
public DataGrid <T_AgreeModel> Search(T_AgreeModel model, Dictionary <string, string> Orders = null, int PageSize = 15, int PageIndex = 100)
{
Expression <Func <T_Agree, bool> > where = null; //最终查询条件
var lambdaList = new List <Expression <Func <T_Agree, bool> > >(); //lambda查询条件集合
int total = 0; //总行数
if (model.StatusList != null && model.StatusList.Count() > 0)
{
lambdaList.Add(c => model.StatusList.Any(a => c.Status == a));
}
if (model.ProjectId != null && model.ProjectId > 0)
{
lambdaList.Add(c => c.ProjectId == model.ProjectId);
}
//将集合表达式树转换成Expression表达式树
MyVisitor <T_Agree, T_Agree> visitor = new MyVisitor <T_Agree, T_Agree>();
where = visitor.Modify(lambdaList);
var list = dal.Search(out total, where, Orders, PageSize, PageIndex).DTOList().ToList();
var result = new DataGrid <T_AgreeModel>()
{
rows = list,
total = total
};
return(result);
}
public static T_AgreeModel DTO(this T_Agree node)
{
if (node == null)
{
return(null);
}
var model = new T_AgreeModel()
{
Id = node.Id,
AgreeDate = node.AgreeDate,
AgreeName = node.AgreeName,
AgreeNo = node.AgreeNo,
AgreeUserId = node.AgreeUserId,
AgreeUserName = node.AgreeUserName,
ApprovalUserId = node.ApprovalUserId,
ApprovalUserIds = node.ApprovalUserIds,
ApprovalUserName = node.ApprovalUserName,
ApprovalUserNames = node.ApprovalUserNames,
CostTotal = node.CostTotal,
Discount = node.Discount,
GrandTotal = node.GrandTotal,
Gst = node.Gst,
GstTotal = node.GstTotal,
PriceTotal = node.PriceTotal,
ProjectId = node.ProjectId,
Status = node.Status,
Remark = node.Remark,
AgreeIndex = node.AgreeIndex,
Project = node.Project != null?node.Project.DTO() : null,
AgreeList = node.AgreeList.Count() > 0 ? node.AgreeList.OrderBy(b => b.Category).Select(s => s.DTO()).ToList() : null,
};
return(model);
}
/// <summary>
///审批协议,这方法后面需要修改成事务。
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int ApporvalsProject(T_AgreeModel model)
{
int i = 0;
int k = 0;
//先获取
var node = this.GetById(model.Id);
if (model.Status == 1)
{
//先获得协议号，先看有没有获得过协议号
// number = number + 55; // 字母A-Z编码在65-90
int AgreementNo = 0; //合同号
int index = 0; //项目中的第几个合同
T_CompanyBLL companybll = new T_CompanyBLL();
T_ProjectBLL projectbll = new T_ProjectBLL();
var projectnode = projectbll.GetById(model.ProjectId);
T_Agree maxagree = dal.Filter(o => o.ProjectId == model.ProjectId && o.Status == 1).OrderByDescending(b => b.AgreeIndex).FirstOrDefault();
if (maxagree != null)
{
AgreementNo = maxagree.AgreeIndex > 0 ? int.Parse(maxagree.AgreeNo.Substring(0, maxagree.AgreeNo.Length - 1)) : int.Parse(maxagree.AgreeNo);
index = int.Parse(maxagree.AgreeIndex.ToString()) + 1;
}
else
{
T_Company company = companybll.GetById((int)projectnode.CompanyId);
AgreementNo = (int)company.AgreementNo;
company.AgreementNo = AgreementNo + 1;
k = companybll.Edit(company);
}
if (projectnode != null)
{
projectnode.Status = 1;
k = projectbll.Edit(projectnode);
}
if (node != null)
{
node.Status = model.Status;
node.AgreeDate = DateTime.Now;
node.AgreeIndex = index;
node.AgreeNo = index == 0 ? AgreementNo.ToString() : AgreementNo.ToString() + Helper.Method.Chr(64 + index);
i = this.Edit(node);
}
}
else
{
if (node != null)
{
node.Status = model.Status;
node.AgreeDate = DateTime.Now;
i = this.Edit(node);
}
}
return(i);
}
/// <summary>
/// 签署协议,这方法后面需要修改成事务。
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AgreeProject(T_AgreeModel model)
{
int i = 0;
int k = 0;
//先获取
var node = this.GetById(model.Id);
if (node != null)
{
node.CostTotal = model.CostTotal;
node.PriceTotal = model.PriceTotal;
node.Discount = model.Discount;
node.Gst = model.Gst;
node.GstTotal = model.GstTotal;
node.Status = model.Status;
node.GrandTotal = model.GrandTotal;
i = this.Edit(node);
}
//T_ProjectBLL project=new T_ProjectBLL();
//var projectnode = project.GetById(model.ProjectId);
//if (projectnode != null)
//{
// projectnode.State =1;
// k = project.Edit(projectnode);
//}
return(i);
}
public int AddData(T_AgreeModel model)
{
T_Agree node = new T_Agree()
{
AgreeDate = DateTime.Now,
AgreeName = model.AgreeName,
ProjectId = model.ProjectId,
Status = 0,
AgreeIndex = 100,
Remark = model.Remark,
};
return(this.Add(node));
}
public int EditData(T_AgreeModel model)
{
int i = 0;
//先获取
var node = this.GetById(model.Id);
if (node != null)
{
node.AgreeDate = DateTime.Now;
node.AgreeName = model.AgreeName;
node.Remark = model.Remark;
i = this.Edit(node);
}
return(i);
}
/// <summary>
/// 根据对象中的主键Id删除
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int DeleteData(T_AgreeModel model)
{
return(this.Delete(model.Id));
}