public string AddInstrument(string instrumentName, string sOperator, string specification, string manufacturer, string serialNo, int planId, string remark, string accessToKen)
{
try
{
UserModel user = null;
string Checkresult = CheckAccess(accessToKen, sOperator, ref user);
if (Checkresult != "OK")
{
return(Checkresult);
}
AssetCheckPlanDetailModel model = new AssetCheckPlanDetailModel();
model.InstrumentName = instrumentName;
model.Checkor = user.UserName;
model.CreateUser = user.UserName;
model.CreateDate = DateTime.Now;
model.CheckDate = DateTime.Now;
model.Specification = specification;
model.Manufacturer = manufacturer;
model.SerialNo = serialNo;
model.PlanId = planId;
model.Remark = remark;
model.Statuse = Constants.AssetsCheckStatus.盘盈.GetHashCode();
ServiceProvider.AssetCheckPlanDetailService.Add(model);
return(ToolsLib.Utility.CommonUtils.JsonSerialize(new { Msg = "OK" }));
}
catch (Exception ex)
{
log.Error(ex);
return(ToolsLib.Utility.CommonUtils.JsonSerialize(new { Msg = ex.Message }));
}
}
/// <summary>
/// 保存实体数据.
/// </summary>
public void Save(AssetCheckPlanDetailModel model)
{
if (model.PlanDetailId == 0)
{
DBProvider.AssetCheckPlanDetailDAO.Add(model);
}
else
{
DBProvider.AssetCheckPlanDetailDAO.Update(model);
}
}
/// <summary>
/// 根据仪器标识和计划标识判断是否已经在盘点计划内
/// </summary>
/// <param name="instrumentId"></param>
/// <returns></returns>
public bool IsExist(int instrumentId, int planId)
{
bool result = false;
AssetCheckPlanDetailModel model = DBProvider.AssetCheckPlanDetailDAO.GetByInstrumentIdAndPlanId(instrumentId, planId);
if (model != null)
{
result = true;
}
return(result);
}
/// <summary>
/// 批量导入资产
/// </summary>
/// <param name="dt"></param>
/// <param name="sucessMsg"></param>
/// <returns></returns>
public string BatchImportAssetsForCheckPlan(int planId, DataTable dt, ref string sucessMsg)
{
StringBuilder result = new StringBuilder();
int sucessCount = 0;
foreach (DataRow dr in dt.Rows)
{
try
{
if (string.IsNullOrWhiteSpace(dr["条码"].ToString()))
{
result.AppendLine("条码格式不正确：【" + dr["条码"] + "】");
continue;
}
Common.Models.InstrumentModel model = ServiceProvider.InstrumentService.GetByBarCode(dr["条码"].ToString().Trim());
if (model == null)
{
result.AppendLine("系统找不到该条码：【" + dr["条码"] + "】");
continue;
}
bool isExist = ServiceProvider.AssetCheckPlanDetailService.IsExist(model.InstrumentId, planId);
if (isExist)
{
//result.AppendLine("系统已存在该条码：【" + dr["条码"] + "】");
continue;
}
AssetCheckPlanDetailModel detailModel = new AssetCheckPlanDetailModel();
detailModel.PlanId = planId;
detailModel.Statuse = Common.Constants.AssetsCheckStatus.盘亏.GetHashCode();
detailModel.InstrumentId = model.InstrumentId;
detailModel.InstrumentName = model.InstrumentName;
detailModel.BelongDepart = model.BelongDepart;
detailModel.Specification = model.Specification;
detailModel.Manufacturer = model.Manufacturer;
detailModel.SerialNo = model.SerialNo;
detailModel.ManageNo = model.ManageNo;
detailModel.AssetsNo = model.AssetsNo;
detailModel.CreateUser = LoginHelper.LoginUser.UserName;
detailModel.BarCode = model.BarCode;
ServiceProvider.AssetCheckPlanDetailService.Save(detailModel);
sucessCount++;
}
catch (Exception ex)
{
}
}
sucessMsg = "共导入" + sucessCount + "条记录";
return(result.ToString());
}
/// <summary>
/// 更新一条数据.
/// </summary>
public void Update(AssetCheckPlanDetailModel model)
{
DBProvider.dbMapper.Update("AssetCheck_PlanDetail.Update", model);
}
/// <summary>
/// 增加一条数据.
/// </summary>
public void Add(AssetCheckPlanDetailModel model)
{
DBProvider.dbMapper.Insert("AssetCheck_PlanDetail.Insert", model);
}
public void Add(AssetCheckPlanDetailModel model)
{
DBProvider.AssetCheckPlanDetailDAO.Add(model);
}
