///// <summary>
///// 各站点发料数量分析
///// </summary>
///// <returns></returns>
//public DataTable GetSiteAnalysis(PageSearchRequest psr)
//{
// var where = new Where<TbSignforDuiZhang>();
// where.And(d => d.Examinestatus == "审核完成");
// if (!string.IsNullOrEmpty(psr.ProjectId))
// {
// where.And(d => d.ProjectId==psr.ProjectId);
// }
// var ret = Db.Context.From<TbSignforDuiZhang>().Select(
// TbCompany._.CompanyFullName.As("SiteName"),
// TbSignforDuiZhang._.SiteCode,
// TbSignforDuiZhang._.HavingAmount.Sum()
// ).LeftJoin<TbCompany>((a,c)=>a.SiteCode==c.CompanyCode)
// .Where(where).GroupBy(TbSignforDuiZhang._.SiteCode, TbCompany._.CompanyFullName).ToDataTable();
// return ret;
//}
///// <summary>
///// 各加工类型发料数量分析
///// </summary>
///// <returns></returns>
//public DataTable GetMachiningTypeAnalysis(PageSearchRequest psr)
//{
// var where = new Where<TbSignforDuiZhang>();
// where.And(d => d.Examinestatus == "审核完成");
// if (!string.IsNullOrEmpty(psr.ProjectId))
// {
// where.And(d => d.ProjectId == psr.ProjectId);
// }
// var ret = Db.Context.From<TbSignforDuiZhang>().Select(
// TbSignforDuiZhang._.MachiningType,
// TbSignforDuiZhang._.HavingAmount.Sum()
// ).Where(where).GroupBy(TbSignforDuiZhang._.MachiningType).ToDataTable();
// return ret;
//}
#endregion
#region 新增/编辑数据
/// <summary>
/// 新增数据
/// </summary>
public AjaxResult Insert(TbSignforDuiZhang model, List <TbSignforDuiZhangDetail> items, bool isApi = false)
{
if (model == null)
{
return(AjaxResult.Warning("参数错误"));
}
model.Examinestatus = "未发起";
model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode;
try
{
using (DbTrans trans = Db.Context.BeginTransaction())
{
//添加信息
Repository <TbSignforDuiZhang> .Insert(trans, model, isApi);
Repository <TbSignforDuiZhangDetail> .Insert(trans, items, isApi);
trans.Commit();
return(AjaxResult.Success());
}
}
catch (Exception ex)
{
return(AjaxResult.Error(ex.ToString()));
}
}
/// <summary>
/// 修改数据
/// </summary>
public AjaxResult Update(TbSignforDuiZhang model, List <TbSignforDuiZhangDetail> items, bool isApi = false)
{
if (model == null)
{
return(AjaxResult.Warning("参数错误"));
}
var anyRet = AnyInfo(model.ID);
if (anyRet.state.ToString() != ResultType.success.ToString())
{
return(anyRet);
}
try
{
using (DbTrans trans = Db.Context.BeginTransaction())//使用事务
{
//修改信息
Repository <TbSignforDuiZhang> .Update(trans, model, p => p.ID == model.ID, isApi);
if (items.Count > 0)
{
//删除历史明细信息
Repository <TbSignforDuiZhangDetail> .Delete(p => p.SigninNuber == model.SigninNuber);
//添加明细信息
Repository <TbSignforDuiZhangDetail> .Insert(trans, items, isApi);
}
trans.Commit();//提交事务
return(AjaxResult.Success());
}
}
catch (Exception ex)
{
return(AjaxResult.Error(ex.ToString()));
}
}
