/// <summary>
/// 导出组织机构
/// </summary>
/// <param name="context"></param>
private void OnExportOrgDepmt(HttpContext context)
{
var bll = new OrgDepmt();
var dt = bll.GetExportData("", null);
HttpClientHelper.Export(context, dt);
}
public ResResultModel SaveOrgDepmt(OrgDepmtFmModel model)
{
try
{
if (model == null)
{
return(ResResult.Response(false, "未获取到任何参数"));
}
if (string.IsNullOrWhiteSpace(model.Coded) || string.IsNullOrWhiteSpace(model.Named))
{
return(ResResult.Response(false, "编码或名称不能为空字符串"));
}
var Id = Guid.Empty;
var parentId = Guid.Empty;
if (model.Id != null && !string.IsNullOrWhiteSpace(model.Id.ToString()))
{
Guid.TryParse(model.Id.ToString(), out Id);
}
if (model.ParentId != null && !string.IsNullOrWhiteSpace(model.ParentId.ToString()))
{
Guid.TryParse(model.ParentId.ToString(), out parentId);
}
var bll = new OrgDepmt();
int effect = 0;
var modelInfo = new OrgDepmtInfo();
modelInfo.Id = Id;
modelInfo.ParentId = parentId;
modelInfo.Coded = model.Coded;
modelInfo.Named = model.Named;
modelInfo.Remark = model.Remark;
modelInfo.Sort = model.Sort;
modelInfo.LastUpdatedDate = DateTime.Now;
modelInfo.UserId = Guid.Parse(SecurityService.GetUserId().ToString());
if (modelInfo.Id.Equals(Guid.Empty))
{
modelInfo.Id = Guid.NewGuid();
effect = bll.InsertByOutput(modelInfo);
}
else
{
effect = bll.Update(modelInfo);
}
if (effect < 1)
{
return(ResResult.Response(false, "操作失败，数据库操作异常"));
}
return(ResResult.Response(true, "操作成功", modelInfo.Id));
}
catch (Exception ex)
{
return(ResResult.Response(false, "操作异常：" + ex.Message + ""));
}
}
public ResResultModel GetOrgDepmtTree()
{
try
{
var bll = new OrgDepmt();
return(ResResult.Response(true, "", bll.GetTreeJson()));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
public ResResultModel DeleteOrgDepmt(Guid Id)
{
try
{
if (Id.Equals(Guid.Empty))
{
return(ResResult.Response(false, "参数值无效"));
}
var bll = new OrgDepmt();
return(ResResult.Response(bll.Delete(Id) > 0, ""));
}
catch (Exception ex)
{
return(ResResult.Response(false, "操作异常：" + ex.Message + ""));
}
}
public ResResultModel GetOrgDepmtTreeByCompanyId(object companyId)
{
try
{
var gId = Guid.Empty;
if (companyId != null)
{
Guid.TryParse(companyId.ToString(), out gId);
}
var bll = new OrgDepmt();
return(ResResult.Response(true, "", bll.GetTreeByCompany(gId)));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
private void ImportByAssetInStore(HttpContext context, HttpPostedFile file)
{
//NpoiHelper npoi = new NpoiHelper();
//var dt = npoi.GetExcelData(Path.GetExtension(file.FileName), file.InputStream);
var dt = new DataTable();
var drc = dt.Rows;
if (drc.Count == 0)
{
context.Response.Write(ResResult.ResJsonString(false, "导入的数据不能为空字符串", ""));
return;
}
Category cBll = new Category();
OrgDepmt odBll = new OrgDepmt();
Region rBll = new Region();
decimal d = decimal.MinValue;
DateTime time = DateTime.MinValue;
var list = new List <AssetInStoreInfo>();
foreach (DataRow dr in drc)
{
if (string.IsNullOrWhiteSpace(dr["资产条码"].ToString()) || string.IsNullOrWhiteSpace(dr["资产名称"].ToString()) || string.IsNullOrWhiteSpace(dr["资产类别编码"].ToString()) || string.IsNullOrWhiteSpace(dr["使用公司编码"].ToString()) || string.IsNullOrWhiteSpace(dr["存放地点"].ToString()) || string.IsNullOrWhiteSpace(dr["所属公司编码"].ToString()) || string.IsNullOrWhiteSpace(dr["购入时间"].ToString()))
{
throw new ArgumentException("带有“*”的列为必填项，请正确操作");
}
var model = new AssetInStoreInfo();
model.Barcode = dr["资产条码"].ToString();
model.Named = dr["资产名称"].ToString();
var categoryModel = cBll.GetModelByCode(dr["资产类别编码"].ToString().Trim());
if (categoryModel == null)
{
throw new ArgumentException("资产类别编码“" + dr["资产类别编码"].ToString().Trim() + "”对应的数据不存在或已被删除");
}
model.CategoryId = categoryModel.Id;
if (!decimal.TryParse(dr["金额"].ToString(), out d))
{
throw new ArgumentException("金额“" + dr["金额"].ToString() + "”不正确");
}
model.Price = d;
model.SpecModel = dr["规格型号"].ToString();
model.Unit = dr["计量单位"].ToString();
var useCompanyModel = odBll.GetModelByCode(dr["使用公司编码"].ToString());
if (useCompanyModel == null)
{
throw new ArgumentException("使用公司编码“" + dr["使用公司编码"].ToString() + "”对应的数据不存在或已被删除");
}
var orgdModel = odBll.GetModelByCode(dr["使用部门编码"].ToString());
if (orgdModel == null)
{
throw new ArgumentException("使用部门编码“" + dr["使用部门编码"].ToString() + "”对应的数据不存在或已被删除");
}
model.UseCompanyId = useCompanyModel.Id;
model.UseDepmtId = orgdModel.Id;
var rModel = rBll.GetModelByCode(dr["区域编码"].ToString());
if (rModel == null)
{
throw new ArgumentException("区域编码“" + dr["区域编码"].ToString() + "”对应的数据不存在或已被删除");
}
model.RegionId = rModel.Id;
var ownedCompanyModel = odBll.GetModelByCode(dr["所属公司编码"].ToString());
if (ownedCompanyModel == null)
{
throw new ArgumentException("所属公司编码“" + dr["所属公司编码"].ToString() + "”对应的数据不存在或已被删除");
}
model.OwnedCompanyId = ownedCompanyModel.Id;
model.UsePerson = dr["使用人"].ToString();
model.StoreLocation = dr["存放地点"].ToString();
model.Manager = dr["管理员姓名"].ToString();
if (!DateTime.TryParse(dr["购入时间"].ToString(), out time))
{
throw new ArgumentException("购入时间“" + dr["购入时间"].ToString() + "”不正确");
}
model.BuyDate = time;
model.Supplier = dr["供应商"].ToString();
model.Remark = dr["备注"].ToString();
model.SNCode = dr["SN号"].ToString();
model.UseExpireMonth = 1200;
model.PictureId = Guid.Empty;
model.LastUpdatedDate = DateTime.Now;
list.Add(model);
}
AssetInStore aisBll = new AssetInStore();
var index = 0;
var userId = WebCommon.GetUserId();
foreach (var model in list)
{
model.UserId = userId;
if (aisBll.Insert(model) < 1)
{
throw new ArgumentException(string.Format("{0}", index > 0 ? "部分数据已经成功导入，但是执行到第“" + index + "”行时发生异常" : "数据导入失败，行“" + index + "”发生异常"));
}
index++;
}
context.Response.Write(ResResult.ResJsonString(true, "导入成功", ""));
}
/// <summary>
/// 导入资产信息
/// </summary>
/// <param name="context"></param>
private void OnImportProduct(HttpContext context)
{
var files = context.Request.Files;
if (files.Count == 0)
{
throw new ArgumentException(MC.M_UploadFileNotExist);
}
var appCode = context.Request.Form["AppCode"];
var userId = WebCommon.GetUserId();
var orgId = new Staff().GetOrgId(userId);
var bll = new Product();
var orgBll = new OrgDepmt();
var spBll = new StoragePlace();
var cBll = new Category();
int effect = 0;
var currTime = DateTime.Now;
foreach (string item in files.AllKeys)
{
HttpPostedFile file = files[item];
if (file == null || file.ContentLength == 0)
{
continue;
}
var dt = ExcelHelper.Import(file.InputStream);
if (dt == null || dt.Rows.Count == 0)
{
throw new CustomException(MC.M_UploadFileDataNotExist);
}
//var id = Guid.Empty;
var drc = dt.Rows;
foreach (DataRow dr in drc)
{
var currInfo = new ProductInfo();
#region 请求参数集
if (dr["资产分类编码"] != null)
{
currInfo.CategoryCode = dr["资产分类编码"].ToString().Trim();
}
if (dr["资产分类"] != null)
{
currInfo.CategoryName = dr["资产分类"].ToString().Trim();
}
if (string.IsNullOrWhiteSpace(currInfo.CategoryCode) || string.IsNullOrWhiteSpace(currInfo.CategoryName))
{
throw new CustomException(MC.GetString(MC.Request_InvalidArgument, "资产编码、资产名称"));
}
var oldCategoryInfo = cBll.GetModel(currInfo.CategoryCode, currInfo.CategoryName);
if (oldCategoryInfo == null)
{
throw new CustomException(MC.GetString(MC.P_InvalidError, string.Format("资产分类编码“{0}”、资产分类为“{1}”", currInfo.CategoryCode, currInfo.CategoryName)));
}
currInfo.CategoryId = oldCategoryInfo.Id;
//if (dr["资产编码"] != null) currInfo.Coded = dr["资产编码"].ToString().Trim();
if (dr["资产名称"] != null)
{
currInfo.Named = dr["资产名称"].ToString().Trim();
}
//if (bll.IsExist(currInfo.Coded, currInfo.Named)) continue;
var sCoded = bll.GetRndCode(oldCategoryInfo.Coded, 8);
currInfo.Coded = sCoded;
var qty = 0;
if (dr["数量"] != null)
{
int.TryParse(dr["数量"].ToString(), out qty);
}
currInfo.Qty = 1;
if (qty < 1)
{
throw new CustomException(string.Format("数量为“{0}”", qty));
}
if (dr["规格型号"] != null)
{
currInfo.SpecModel = dr["规格型号"].ToString().Trim();
}
var price = 0m;
if (dr["单价"] != null && decimal.TryParse(dr["单价"].ToString(), out price))
{
currInfo.Price = price;
}
var amount = 0m;
if (dr["金额"] != null && decimal.TryParse(dr["金额"].ToString(), out amount))
{
currInfo.Amount = amount;
}
if (dr["计量单位"] != null)
{
currInfo.MeterUnit = dr["计量单位"].ToString().Trim();
}
var pieceQty = 0;
//if (dr["件数"] != null && int.TryParse(dr["件数"].ToString(),out pieceQty)) currInfo.PieceQty = pieceQty;
if (dr["资产属性"] != null)
{
currInfo.Pattr = dr["资产属性"].ToString().Trim();
}
if (dr["资产来源"] != null)
{
currInfo.SourceFrom = dr["资产来源"].ToString().Trim();
}
if (dr["供应商"] != null)
{
currInfo.Supplier = dr["供应商"].ToString().Trim();
}
var buyDate = DateTime.MinValue;
if (dr["购入日期"] != null)
{
DateTime.TryParse(dr["购入日期"].ToString(), out buyDate);
}
if (buyDate == DateTime.MinValue)
{
buyDate = DateTime.Parse("1754-01-01");
}
currInfo.BuyDate = buyDate;
var enableDate = DateTime.MinValue;
if (dr["启用日期"] != null && DateTime.TryParse(dr["启用日期"].ToString(), out enableDate))
{
currInfo.EnableDate = enableDate.ToString("yyyy-MM-dd");
}
if (dr["使用期限"] != null)
{
currInfo.UseDateLimit = dr["使用期限"].ToString().Trim();
}
if (dr["使用部门"] != null)
{
currInfo.UseOrgName = dr["使用部门"].ToString().Trim();
}
if (dr["使用部门编码"] != null)
{
currInfo.UseOrgCode = dr["使用部门编码"].ToString().Trim();
}
if (!string.IsNullOrEmpty(currInfo.UseOrgCode) || !string.IsNullOrEmpty(currInfo.UseOrgName))
{
var useOrgInfo = orgBll.GetModel(currInfo.UseOrgCode, currInfo.UseOrgName);
if (useOrgInfo == null)
{
throw new CustomException(MC.GetString(MC.P_InvalidError, string.Format("使用部门编码“{0}”、使用部门“{1}”", currInfo.UseOrgCode, currInfo.UseOrgName)));
}
currInfo.UseDepmtId = useOrgInfo.Id;
}
if (dr["实物管理部门"] != null)
{
currInfo.MgrOrgName = dr["实物管理部门"].ToString().Trim();
}
if (dr["实物管理部门编码"] != null)
{
currInfo.MgrOrgCode = dr["实物管理部门编码"].ToString().Trim();
}
if (!string.IsNullOrEmpty(currInfo.MgrOrgCode) || !string.IsNullOrEmpty(currInfo.MgrOrgName))
{
var mgrOrgInfo = orgBll.GetModel(currInfo.MgrOrgCode, currInfo.MgrOrgName);
if (mgrOrgInfo == null)
{
throw new CustomException(MC.GetString(MC.P_InvalidError, string.Format("实物管理部门编码“{0}”、实物管理部门“{1}”", currInfo.MgrOrgCode, currInfo.MgrOrgName)));
}
currInfo.MgrDepmtId = mgrOrgInfo.Id;
}
if (dr["存放地点"] != null)
{
currInfo.StoragePlaceName = dr["存放地点"].ToString().Trim();
}
if (dr["存放地点编码"] != null)
{
currInfo.StoragePlaceCode = dr["存放地点编码"].ToString().Trim();
}
if (!string.IsNullOrEmpty(currInfo.StoragePlaceCode) || !string.IsNullOrEmpty(currInfo.StoragePlaceName))
{
var storagePlaceInfo = spBll.GetModel(currInfo.StoragePlaceCode, currInfo.StoragePlaceName);
if (storagePlaceInfo == null)
{
throw new CustomException(MC.GetString(MC.P_InvalidError, string.Format("存放地点编码“{0}”、存放地点“{1}”", currInfo.StoragePlaceCode, currInfo.StoragePlaceName)));
}
currInfo.StoragePlaceId = storagePlaceInfo.Id;
}
if (dr["使用人"] != null)
{
currInfo.UsePersonName = dr["使用人"].ToString().Trim();
}
#endregion
currInfo.AppCode = appCode;
currInfo.UserId = userId;
currInfo.DepmtId = orgId;
currInfo.RecordDate = currTime;
currInfo.LastUpdatedDate = currTime;
effect += bll.Insert(currInfo);
if (qty > 1)
{
for (var i = 1; i < qty; i++)
{
currInfo.Coded = bll.GetRndCode(sCoded, 11);
effect += bll.Insert(currInfo);
}
}
}
}
if (effect < 1)
{
context.Response.Write(ResResult.ResJsonString(false, MC.M_Save_Error, ""));
}
else
{
context.Response.Write(ResResult.ResJsonString(true, MC.M_Save_Ok, effect));
}
}
/// <summary>
/// 导入组织机构
/// </summary>
/// <param name="context"></param>
private void OnImportOrgDepmt(HttpContext context)
{
var files = context.Request.Files;
if (files.Count == 0)
{
throw new ArgumentException(MC.M_UploadFileNotExist);
}
var appCode = context.Request.Form["AppCode"];
var userId = WebCommon.GetUserId();
var orgId = new Staff().GetOrgId(userId);
var bll = new OrgDepmt();
int effect = 0;
var categories = bll.GetList();
foreach (string item in files.AllKeys)
{
HttpPostedFile file = files[item];
if (file == null || file.ContentLength == 0)
{
continue;
}
var dt = ExcelHelper.Import(file.InputStream);
if (dt == null || dt.Rows.Count == 0)
{
throw new ArgumentException(MC.M_UploadFileDataNotExist);
}
var currTime = DateTime.Now;
var sEmpty = string.Empty;
var drc = dt.Rows;
foreach (DataRow dr in drc)
{
#region 请求参数集
string coded = string.Empty;
if (dr["资产分类编码"] != null)
{
coded = dr["资产分类编码"].ToString().Trim();
}
string named = string.Empty;
if (dr["资产分类名称"] != null)
{
named = dr["资产分类名称"].ToString().Trim();
}
string parentCode = string.Empty;
if (dr["所属上级分类编码"] != null)
{
parentCode = dr["所属上级分类编码"].ToString().Trim();
}
string parentName = string.Empty;
if (dr["所属上级分类"] != null)
{
parentName = dr["所属上级分类"].ToString().Trim();
}
int sort = 0;
if (dr["排序"] != null)
{
int.TryParse(dr["排序"].ToString(), out sort);
}
if (string.IsNullOrWhiteSpace(coded) || string.IsNullOrWhiteSpace(named))
{
continue;
}
var id = Guid.NewGuid();
var parentId = Guid.Empty;
if (string.IsNullOrWhiteSpace(parentCode))
{
parentCode = named;
}
var parentInfo = bll.GetModel(parentCode, parentName);
var step = id.ToString();
var ids = new List <Guid>();
if (parentInfo != null)
{
parentId = parentInfo.Id;
bll.GetStep(categories, parentId, ref ids);
if (ids.Count > 0)
{
Array.Reverse(ids.ToArray());
step += "," + string.Join(",", ids.ToArray());
}
}
var currInfo = new OrgDepmtInfo(id, appCode, userId, orgId, parentId, coded, named, step, sort, sEmpty, currTime, currTime);
effect += bll.Insert(currInfo);
#endregion
}
}
if (effect < 1)
{
context.Response.Write(ResResult.ResJsonString(false, MC.M_Save_Error, ""));
}
else
{
context.Response.Write(ResResult.ResJsonString(true, MC.M_Save_Ok, effect));
}
}
