public ResResultModel SavePandianDown(PdaPandianFmModel model)
{
try
{
var userId = WebCommon.GetUserId();
if (userId.Equals(Guid.Empty))
{
return(ResResult.Response((int)ResCode.未登录, MC.Login_NotExist, ""));
}
var gId = Guid.Empty;
if (!Guid.TryParse(model.Id.ToString(), out gId))
{
return(ResResult.Response(false, "参数不正确", ""));
}
var bll = new Pandian();
if (bll.UpdateIsDown(gId) < 1)
{
return(ResResult.Response(false, MC.M_Save_Error, ""));
}
return(ResResult.Response(true, MC.M_Save_Ok, ""));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
public ResResultModel SavePandianDown(PdaPandianFmModel model)
{
try
{
object userId = null;
SecurityService.DoCheckLogin(model.AppKey, model.UserName, out userId);
var gId = Guid.Empty;
if (!Guid.TryParse(model.Id.ToString(), out gId))
{
return(ResResult.Response(false, "参数不正确", ""));
}
var bll = new Pandian();
if (bll.UpdateIsDown(gId) < 1)
{
return(ResResult.Response(false, "下载失败，请稍后再重试！", ""));
}
return(ResResult.Response(true, "调用成功", ""));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
public ResResultModel GetPandianList(PdaPandianModel model)
{
try
{
object userId = null;
SecurityService.DoCheckLogin(model.AppKey, model.UserName, out userId);
if (model.PageIndex < 1)
{
model.PageIndex = 1;
}
if (model.PageSize < 10)
{
model.PageSize = 10;
}
int totalRecord = 0;
var sqlWhere = new StringBuilder(100);
var parms = new ParamsHelper();
sqlWhere.AppendFormat("and CHARINDEX(AllowUsers,'{0}') > -1 ", userId.ToString());
if (model.PandianId != null)
{
var pandianId = Guid.Empty;
Guid.TryParse(model.PandianId.ToString(), out pandianId);
if (!pandianId.Equals(Guid.Empty))
{
sqlWhere.Append("and Id = @PandianId ");
var parm = new SqlParameter("@PandianId", SqlDbType.UniqueIdentifier);
parm.Value = pandianId;
parms.Add(parm);
}
}
var bll = new Pandian();
var list = bll.GetListByJoin(model.PageIndex, model.PageSize, out totalRecord, sqlWhere.ToString(), parms.ToArray());
if (totalRecord == 0)
{
return(ResResult.Response(true, "", "{\"total\":0,\"rows\":[]}"));
}
var pdaList = new List <PdaPandianInfo>();
foreach (var item in list)
{
pdaList.Add(new PdaPandianInfo {
Id = item.Id, Name = item.Named, SCreateDate = item.CreateDate.ToString("yyyy年MM月dd日"), CreateUserName = item.UserName, IsDown = item.IsDown, TotalQty = item.TotalQty
});
}
var dgData = "{\"total\":" + pdaList.Count + ",\"rows\":" + JsonConvert.SerializeObject(pdaList) + "}";
return(ResResult.Response(true, "", dgData));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
public ResResultModel GetPandianList(PdaPandianModel model)
{
try
{
var userId = WebCommon.GetUserId();
if (userId.Equals(Guid.Empty))
{
return(ResResult.Response((int)ResCode.未登录, MC.Login_NotExist, ""));
}
if (model.PageIndex < 1)
{
model.PageIndex = 1;
}
if (model.PageSize < 10)
{
model.PageSize = 10;
}
int totalRecord = 0;
var sqlWhere = new StringBuilder(300);
var parms = new ParamsHelper();
Auth.CreateSearchItem(ref sqlWhere, ref parms, new string[] { "pd.DepmtId" });
sqlWhere.AppendFormat("and pd.Status < {0} ", (int)EnumPandianStatus.已完成);
if (model.PandianId != null)
{
var pandianId = Guid.Empty;
Guid.TryParse(model.PandianId.ToString(), out pandianId);
if (!pandianId.Equals(Guid.Empty))
{
sqlWhere.Append("and Id = @PandianId ");
var parm = new SqlParameter("@PandianId", SqlDbType.UniqueIdentifier);
parm.Value = pandianId;
parms.Add(parm);
}
}
var bll = new Pandian();
var list = bll.GetListByJoin(model.PageIndex, model.PageSize, out totalRecord, sqlWhere.ToString(), parms.ToArray());
if (totalRecord == 0)
{
return(ResResult.Response(true, "", "{\"total\":0,\"rows\":[]}"));
}
var dgData = "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}";
return(ResResult.Response(true, "", dgData));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
public ResResultModel SavePandianProduct(PandianProductFmModel model)
{
try
{
var bll = new PandianProduct();
int effect = -1;
var oldInfo = bll.GetModel(model.PandianId, model.ProductId, model.CustomerId);
if (oldInfo == null)
{
throw new ArgumentException(MC.Data_NotExist);
}
oldInfo.UserId = WebCommon.GetUserId();
oldInfo.Qty = model.Qty;
oldInfo.FailQty = oldInfo.StayQty - model.Qty;
oldInfo.UpdatedZones = model.Zones;
oldInfo.UpdatedStockLocations = HttpUtility.UrlDecode(model.StockLocations);
if (oldInfo.Qty > 0)
{
if (oldInfo.FailQty == 0)
{
oldInfo.Status = EnumData.EnumOrderStatus.已完成.ToString();
}
else
{
oldInfo.Status = EnumData.EnumOrderStatus.待完成.ToString();
}
}
oldInfo.LastUpdatedDate = DateTime.Now;
effect = bll.Update(oldInfo);
effect += new Pandian().UpdateStatus(oldInfo.PandianId, EnumData.EnumOrderStatus.待完成.ToString());
if (effect < 1)
{
return(ResResult.Response(false, MC.M_Save_Error, ""));
}
return(ResResult.Response(true, "", ""));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
public ResResultModel GetPandianList(ListModel model)
{
try
{
if (model.PageIndex < 1)
{
model.PageIndex = 1;
}
if (model.PageSize < 1)
{
model.PageSize = 10;
}
var bll = new Pandian();
var list = bll.GetListByJoin(model.PageIndex, model.PageSize, "", null);
return(ResResult.Response(true, "", JsonConvert.SerializeObject(list)));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
public ResResultModel SavePandianAsset(PdaPandianAssetFmModel model)
{
object userId = null;
SecurityService.DoCheckLogin(model.AppKey, model.UserName, out userId);
if (model == null)
{
return(ResResult.Response(false, "请求参数集为空字符串", ""));
}
var pandianId = Guid.Empty;
if (model.PandianId == null || !Guid.TryParse(model.PandianId.ToString(), out pandianId))
{
return(ResResult.Response(false, "参数PandianId值为“" + model.PandianId + "”无效", ""));
}
if (model.ItemList == null || model.ItemList.Count == 0)
{
return(ResResult.Response(false, "请求参数集为空字符串", ""));
}
var pdaBll = new PandianAsset();
var aisBll = new AssetInStore();
var pdBll = new Pandian();
var effect = 0;
foreach (var item in model.ItemList)
{
PandianAssetInfo pdaModel = null;
AssetInStoreInfo assetModel = null;
var assetId = Guid.Empty;
if (item.AssetId != null)
{
Guid.TryParse(item.AssetId.ToString(), out assetId);
}
if (assetId == Guid.Empty)
{
if (string.IsNullOrWhiteSpace(item.Barcode))
{
continue;
}
if (pdaBll.IsExist(item.Barcode))
{
assetModel = aisBll.GetModelByBarcode(item.Barcode);
if (assetModel != null)
{
CreateAssetInStoreInfo(item, ref assetModel, ref pdaModel);
pdaModel.AssetId = assetModel.Id;
pdaModel.PandianId = pandianId;
assetModel.UserId = Guid.Parse(userId.ToString());
pdaModel.UserId = assetModel.UserId;
effect += aisBll.Update(assetModel);
effect += pdaBll.Update(pdaModel);
}
}
else
{
CreateAssetInStoreInfo(item, ref assetModel, ref pdaModel);
assetModel.Id = Guid.NewGuid();
pdaModel.AssetId = assetModel.Id;
pdaModel.PandianId = pandianId;
assetModel.UserId = Guid.Parse(userId.ToString());
pdaModel.UserId = assetModel.UserId;
effect += aisBll.InsertByOutput(assetModel);
effect += pdaBll.Insert(pdaModel);
}
}
else
{
assetModel = aisBll.GetModel(assetId);
pdaModel = pdaBll.GetModel(pandianId, assetId);
CreateAssetInStoreInfo(item, ref assetModel, ref pdaModel);
pdaModel.UserId = Guid.Parse(userId.ToString());
effect += pdaBll.Update(pdaModel);
}
}
if (effect < 1)
{
return(ResResult.Response(false, "操作失败", ""));
}
return(ResResult.Response(true, "调用成功", ""));
}
public ResResultModel SavePandianAsset(PdaPandianAssetFmModel model)
{
try
{
if (model == null)
{
return(ResResult.Response(false, "请求参数集为空字符串", ""));
}
var userId = WebCommon.GetUserId();
if (userId.Equals(Guid.Empty))
{
return(ResResult.Response((int)ResCode.未登录, MC.Login_NotExist, ""));
}
var depmtId = new Staff().GetOrgId(userId);
var pandianId = Guid.Empty;
if (!Guid.TryParse(model.PandianId, out pandianId))
{
return(ResResult.Response(false, "参数PandianId值为“" + model.PandianId + "”无效", ""));
}
var currTime = DateTime.Now;
var gEmpty = Guid.Empty;
var minDate = DateTime.Parse("1754-01-01");
var pdaBll = new PandianAsset();
var pBll = new Product();
var pdBll = new Pandian();
var effect = 0;
foreach (var item in model.ItemList)
{
var assetId = Guid.Empty;
if (!string.IsNullOrEmpty(item.AssetId))
{
Guid.TryParse(item.AssetId, out assetId);
}
var categoryId = Guid.Empty;
if (!string.IsNullOrEmpty(item.CategoryId))
{
Guid.TryParse(item.CategoryId, out categoryId);
}
var useDepmtId = Guid.Empty;
if (!string.IsNullOrEmpty(item.UseDepmtId))
{
Guid.TryParse(item.UseDepmtId, out useDepmtId);
}
var mgrDepmtId = Guid.Empty;
if (!string.IsNullOrEmpty(item.MgrDepmtId))
{
Guid.TryParse(item.MgrDepmtId, out mgrDepmtId);
}
var storeLocationId = Guid.Empty;
if (!string.IsNullOrEmpty(item.StoreLocationId))
{
Guid.TryParse(item.StoreLocationId, out storeLocationId);
}
ProductInfo productInfo = null;
if (item.Status == (int)EnumPandianAssetStatus.盘盈)
{
#region 盘盈
productInfo = new ProductInfo(GlobalConfig.SiteCode, userId, depmtId, Guid.NewGuid(), categoryId, item.Barcode, item.AssetName, item.Barcode, item.SpecModel, 1, 0, 0, item.Unit, 0, string.Empty, string.Empty, string.Empty, minDate, "1754-01-01", string.Empty, useDepmtId, item.UsePerson, mgrDepmtId, storeLocationId, string.Empty, item.Status, 0, true, currTime, currTime);
effect += pBll.InsertByOutput(productInfo);
var pandianAssetInfo = new PandianAssetInfo(pandianId, productInfo.Id, productInfo.AppCode, productInfo.UserId, productInfo.DepmtId, gEmpty, gEmpty, gEmpty, string.Empty, 0, item.Remark, item.Status, currTime, currTime);
pdaBll.Insert(pandianAssetInfo);
#endregion
}
else
{
#region 非盘盈
productInfo = pBll.GetModel(assetId);
var pandianAssetInfo = pdaBll.GetModel(pandianId, assetId);
if (!useDepmtId.Equals(Guid.Empty) && !useDepmtId.Equals(productInfo.UseDepmtId))
{
pandianAssetInfo.LastUseDepmtId = useDepmtId;
}
if (!mgrDepmtId.Equals(Guid.Empty) && !mgrDepmtId.Equals(productInfo.MgrDepmtId))
{
pandianAssetInfo.LastMgrDepmtId = mgrDepmtId;
}
if (!storeLocationId.Equals(Guid.Empty) && !storeLocationId.Equals(productInfo.StoragePlaceId))
{
pandianAssetInfo.LastStoragePlaceId = storeLocationId;
}
if (!string.IsNullOrEmpty(item.UsePerson) && item.UsePerson != productInfo.UsePersonName)
{
pandianAssetInfo.LastUsePerson = item.UsePerson;
}
pandianAssetInfo.Status = item.Status;
effect += pdaBll.Update(pandianAssetInfo);
#endregion
}
}
if (effect < 1)
{
return(ResResult.Response(false, "操作失败", ""));
}
return(ResResult.Response(true, "调用成功", ""));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
