private void Select()
{
try
{
Node nodeSelect = treeDepartment.SelectedNode;
if (nodeSelect != null)
{
if (nodeSelect.Name.IndexOf("DEPARTMENT_") > -1)
{
if (!nodeSelect.HasChildNodes)
{
DepartmentEntity department = (DepartmentEntity)nodeSelect.Tag;
DepartmentTree.CreateDepartmentUser(nodeSelect, department.Id, "");
}
}
if (nodeSelect.Name.IndexOf("DEPARTMENTUSER_") > -1)
{
if (DepartmentInterface != null)
{
DepartmentUserEntity departmentUser = (DepartmentUserEntity)nodeSelect.Tag;
DepartmentEntity department = (DepartmentEntity)nodeSelect.Parent.Tag;
DepartmentInterface.DepartmentCallBack(departmentUser, department);
this.Close();
}
else
{
MessageBox.Show("调用界面没有定义DepartmentCallBack接口,请联系系统管理员！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
catch (Exception er)
{
MessageBox.Show(er.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public IEnumerable <DrugEntity> GetPageList(string name, string deptid, int page, int pagesize, out int total)
{
var query = this.BaseRepository().IQueryable();
//query = query.Where(x => x.BZId == deptid);
var dpservice = new DepartmentService();
var dept = new DepartmentEntity();
var bzids = new WorkOrderService().GetWorkOrderGroup(deptid).Select(x => x.departmentid).ToList();
if (bzids.Count == 0)
{
query = query.Where(x => x.BZId == deptid);
}
else
{
query = query.Where(x => bzids.Contains(x.BZId));
}
if (!string.IsNullOrEmpty(name))
{
query = query.Where(x => x.DrugName.Contains(name));
}
total = query.Count();
return(query.OrderByDescending(x => x.CreateDate).Skip(pagesize * (page - 1)).Take(pagesize).ToList());
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="queryJson">查询参数</param>
/// <returns>返回列表</returns>
public IEnumerable <ToolTypeEntity> GetList(string deptid)
{
var query = this.BaseRepository().IQueryable();
//Operator user = OperatorProvider.Provider.Current();
if (deptid != null)
{
//string deptid = user.DeptId;
var dpservice = new DepartmentService();
var dept = new DepartmentEntity();
var bzids = new WorkOrderService().GetWorkOrderGroup(deptid).Select(x => x.departmentid).ToList();
if (bzids.Count == 0)
{
query = query.Where(x => x.BZId == deptid);
}
else
{
query = query.Where(x => bzids.Contains(x.BZId));
}
}
return(query.OrderBy(x => x.CreateDate).ToList());
}
/// <summary>
/// Updates the department.
/// </summary>
/// <param name="departmentEntity">The department entity.</param>
/// <returns></returns>
public DepartmentResponse UpdateDepartment(DepartmentEntity departmentEntity)
{
var response = new DepartmentResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!departmentEntity.Validate())
{
foreach (var error in departmentEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
using (var scope = new TransactionScope())
{
response.Message = DepartmentDao.UpdateDepartment(departmentEntity);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
scope.Complete();
}
response.DepartmentId = departmentEntity.DepartmentId;
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
return(response);
}
}
public ActionResult EditDepartment(DepartmentEntity data)
{
data.CreatedBy = ApplicationSession.CurrentUser.Id;
try
{
if (ModelState.IsValid)
{
bool result = _departmentservice.UpdateDepartment(data.Id, data);
if (result)
{
return(Json(new { success = true }));
}
else
{
ModelState.AddModelError("", "Network Error Try Again ");
}
}
}
catch
{
ModelState.AddModelError("", "Unable to Save. Try again, and if the problem persists see your system administrator.");// handle for database troble
}
return(PartialView("_UserEdit", data));
}
public async Task <_ <DepartmentEntity> > Update(DepartmentEntity model)
{
model.Should().NotBeNull("dept update model");
model.Id.Should().NotBeNullOrEmpty("dept update uid");
model.NodeName.Should().NotBeNullOrEmpty("dept update dept name");
var res = new _ <DepartmentEntity>();
var data = await this._deptRepo.QueryOneAsync(x => x.Id == model.Id);
data.Should().NotBeNull();
if (await this._deptRepo.ExistAsync(x => x.NodeName == model.NodeName && x.Id != model.Id))
{
return(res.SetErrorMsg("部门名称已经存在"));
}
data.NodeName = model.NodeName;
data.Description = model.Description;
await this._deptRepo.UpdateAsync(data);
return(res.SetSuccessData(data));
}
public List <DepartmentEntity> FetchAllDepartments(DataAccess dataAccess)
{
List <DepartmentEntity> departments = new List <DepartmentEntity>();
try {
command = new SqlCommand(FECTH_ALL_DEPARTMENTS, dataAccess.GetConnection());
reader = command.ExecuteReader();
while (reader.Read())
{
DepartmentEntity departmentEntity = new DepartmentEntity();
departmentEntity.Id = reader.GetInt32(reader.GetOrdinal("id"));
departmentEntity.Name = reader.GetString(reader.GetOrdinal("name"));
departments.Add(departmentEntity);
}
reader.Close();
} catch (SqlException exc) {
}
eventsCount = departments.Count;
return(departments);
}
/// <summary>
/// 保存部门表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="departmentEntity">机构实体</param>
/// <returns></returns>
public void AddDepartment(string keyValue, DepartmentEntity departmentEntity)
{
_departmentService.AddDepartment(keyValue, departmentEntity);
}
public void SaveDepartment(DepartmentEntity department)
{
SaveEntity(department);
}
/// <summary>
/// 保存部门信息
/// </summary>
/// <param name="Department">部门信息实体</param>
/// <returns></returns>
public int SaveDepartment(DepartmentEntity Department)
{
return(DataAccess.SaveDepartment(Department));
}
/// <summary>
/// 获得指定模块或者编号的单据号（直接使用）
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="moduleId">模块ID</param>
/// <param name="enCode">模板编码</param>
/// <returns>单据号</returns>
public string SetBillCode(string userId, string moduleId, string enCode, IRepository db = null)
{
IRepository dbc = null;
if (db == null)
{
dbc = new RepositoryFactory().BaseRepository();
}
else
{
dbc = db;
}
UserEntity userEntity = db.FindEntity <UserEntity>(userId);
CodeRuleEntity coderuleentity = db.FindEntity <CodeRuleEntity>(t => t.ModuleId == moduleId || t.EnCode == enCode);
//判断种子是否已经产生,如果没有产生种子先插入一条初始种子
CodeRuleSeedEntity initSeed = db.FindEntity <CodeRuleSeedEntity>(t => t.RuleId == coderuleentity.RuleId);
if (initSeed == null)
{
initSeed = new CodeRuleSeedEntity();
initSeed.Create();
initSeed.SeedValue = 1;
initSeed.RuleId = coderuleentity.RuleId;
initSeed.CreateDate = null;
//db.Insert<CodeRuleSeedEntity>(initSeed);
}
//获得模板ID
string billCode = ""; //单据号
string nextBillCode = ""; //单据号
bool isOutTime = false; //是否已过期
if (coderuleentity != null)
{
try
{
int nowSerious = 0;
//取得流水号种子
List <CodeRuleSeedEntity> codeRuleSeedlist = db.IQueryable <CodeRuleSeedEntity>(t => t.RuleId == coderuleentity.RuleId).ToList();
//取得最大种子
CodeRuleSeedEntity maxSeed = db.FindEntity <CodeRuleSeedEntity>(t => t.UserId == null);
#region 处理隔天流水号归0
//首先确定最大种子是否是隔天未归0的
if ((maxSeed.ModifyDate).ToDateString() != DateTime.Now.ToString("yyyy-MM-dd"))
{
isOutTime = true;
maxSeed.SeedValue = 1;
maxSeed.ModifyDate = DateTime.Now;
}
#endregion
if (maxSeed == null)
{
maxSeed = initSeed;
}
List <CodeRuleFormatEntity> codeRuleFormatList = coderuleentity.RuleFormatJson.ToList <CodeRuleFormatEntity>();
foreach (CodeRuleFormatEntity codeRuleFormatEntity in codeRuleFormatList)
{
switch (codeRuleFormatEntity.ItemType.ToString())
{
//自定义项
case "0":
billCode = billCode + codeRuleFormatEntity.FormatStr;
nextBillCode = nextBillCode + codeRuleFormatEntity.FormatStr;
break;
//日期
case "1":
//日期字符串类型
billCode = billCode + DateTime.Now.ToString(codeRuleFormatEntity.FormatStr.Replace("m", "M"));
nextBillCode = nextBillCode + DateTime.Now.ToString(codeRuleFormatEntity.FormatStr.Replace("m", "M"));
break;
//流水号
case "2":
//查找当前用户是否已有之前未用掉的种子
CodeRuleSeedEntity codeRuleSeedEntity = codeRuleSeedlist.Find(t => t.UserId == userId && t.RuleId == coderuleentity.RuleId);
//删除已过期的用户未用掉的种子
if (codeRuleSeedEntity != null && isOutTime)
{
db.Delete <CodeRuleSeedEntity>(codeRuleSeedEntity);
codeRuleSeedEntity = null;
}
//如果没有就取当前最大的种子
if (codeRuleSeedEntity == null)
{
//取得系统最大的种子
int maxSerious = (int)maxSeed.SeedValue;
nowSerious = maxSerious;
codeRuleSeedEntity = new CodeRuleSeedEntity();
codeRuleSeedEntity.Create();
codeRuleSeedEntity.SeedValue = maxSerious;
codeRuleSeedEntity.UserId = userId;
codeRuleSeedEntity.RuleId = coderuleentity.RuleId;
//db.Insert<CodeRuleSeedEntity>(codeRuleSeedEntity);
//处理种子更新
maxSeed.SeedValue += 1;
if (maxSeed.CreateDate != null)
{
db.Update <CodeRuleSeedEntity>(maxSeed);
}
else
{
maxSeed.CreateDate = DateTime.Now;
db.Insert <CodeRuleSeedEntity>(maxSeed);
}
}
else
{
nowSerious = (int)codeRuleSeedEntity.SeedValue;
}
string seriousStr = new string('0', (int)(codeRuleFormatEntity.FormatStr.Length - nowSerious.ToString().Length)) + nowSerious.ToString();
string NextSeriousStr = new string('0', (int)(codeRuleFormatEntity.FormatStr.Length - nowSerious.ToString().Length)) + maxSeed.SeedValue.ToString();
billCode = billCode + seriousStr;
nextBillCode = nextBillCode + NextSeriousStr;
break;
//部门
case "3":
DepartmentEntity departmentEntity = db.FindEntity <DepartmentEntity>(userEntity.DepartmentId);
if (codeRuleFormatEntity.FormatStr == "code")
{
billCode = billCode + departmentEntity.EnCode;
nextBillCode = nextBillCode + departmentEntity.EnCode;
}
else
{
billCode = billCode + departmentEntity.FullName;
nextBillCode = nextBillCode + departmentEntity.FullName;
}
break;
//公司
case "4":
OrganizeEntity organizeEntity = db.FindEntity <OrganizeEntity>(userEntity.OrganizeId);
if (codeRuleFormatEntity.FormatStr == "code")
{
billCode = billCode + organizeEntity.EnCode;
nextBillCode = nextBillCode + organizeEntity.EnCode;
}
else
{
billCode = billCode + organizeEntity.FullName;
nextBillCode = nextBillCode + organizeEntity.FullName;
}
break;
//用户
case "5":
if (codeRuleFormatEntity.FormatStr == "code")
{
billCode = billCode + userEntity.EnCode;
nextBillCode = nextBillCode + userEntity.EnCode;
}
else
{
billCode = billCode + userEntity.Account;
nextBillCode = nextBillCode + userEntity.Account;
}
break;
default:
break;
}
}
coderuleentity.CurrentNumber = nextBillCode;
db.Update <CodeRuleEntity>(coderuleentity);
}
catch (Exception)
{
throw;
}
}
return(billCode);
}
public ActionResult SaveForm(string keyValue, DepartmentEntity departmentEntity)
{
departmentBLL.SaveForm(keyValue, departmentEntity);
return(Success("操作成功。"));
}
public bool Save(DepartmentEntity entity)
{
return(depAccess.Save(entity));
}
public string ImportStandard(string refid, string refname, string deptcode)
{
try
{
if (OperatorProvider.Provider.Current().IsSystem)
{
return("超级管理员无此操作权限");
}
string orgId = OperatorProvider.Provider.Current().OrganizeId;//所属公司
int error = 0;
int success = 0;
string message = "请选择文件格式正确的文件再导入!";
string falseMessage = "";
int count = HttpContext.Request.Files.Count;
if (count > 0)
{
if (HttpContext.Request.Files.Count != 2)
{
return("请按正确的方式导入两个文件.");
}
HttpPostedFileBase file = HttpContext.Request.Files[0];
HttpPostedFileBase file2 = HttpContext.Request.Files[1];
if (string.IsNullOrEmpty(file.FileName) || string.IsNullOrEmpty(file2.FileName))
{
return(message);
}
Boolean isZip1 = file.FileName.Substring(file.FileName.IndexOf('.')).Contains("zip"); //第一个文件是否为Zip格式
Boolean isZip2 = file2.FileName.Substring(file2.FileName.IndexOf('.')).Contains("zip"); //第二个文件是否为Zip格式
if ((isZip1 || isZip2) == false || (isZip1 && isZip2) == true)
{
return(message);
}
string fileName1 = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName);
file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName1));
string fileName2 = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file2.FileName);
file2.SaveAs(Server.MapPath("~/Resource/temp/" + fileName2));
string decompressionDirectory = Server.MapPath("~/Resource/decompression/") + DateTime.Now.ToString("yyyyMMddhhmmssfff") + "\\";
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook();
if (isZip1)
{
UnZip(Server.MapPath("~/Resource/temp/" + fileName1), decompressionDirectory, "", true);
wb.Open(Server.MapPath("~/Resource/temp/" + fileName2));
}
else
{
UnZip(Server.MapPath("~/Resource/temp/" + fileName2), decompressionDirectory, "", true);
wb.Open(Server.MapPath("~/Resource/temp/" + fileName1));
}
Aspose.Cells.Cells cells = wb.Worksheets[0].Cells;
DataTable dt = cells.ExportDataTable(1, 0, cells.MaxDataRow, cells.MaxColumn, false);
for (int i = 0; i < dt.Rows.Count; i++)
{
StdsysFilesEntity standard = new StdsysFilesEntity();
standard.ID = Guid.NewGuid().ToString();
//文件名称
string filename = dt.Rows[i][0].ToString();
//文件编号
string fileno = dt.Rows[i][1].ToString();
//---****值存在空验证*****--
if (string.IsNullOrEmpty(filename) || string.IsNullOrEmpty(dt.Rows[i][2].ToString()))
{
falseMessage += "</br>" + "第" + (i + 1) + "行值存在空,未能导入.";
error++;
continue;
}
bool conbool = false;
//文件路径
string[] filepaths = dt.Rows[i][2].ToString().Split(';');
var filepath = "";
for (int j = 0; j < filepaths.Length; j++)
{
filepath = filepaths[j];
if (string.IsNullOrEmpty(filepath))
{
continue;
}
//---****文件格式验证*****--
if (!(filepath.Substring(filepath.IndexOf('.')).Contains("doc") || filepath.Substring(filepath.IndexOf('.')).Contains("docx") || filepath.Substring(filepath.IndexOf('.')).Contains("pdf")))
{
falseMessage += "</br>" + "第" + (i + 1) + "行指定附件格式不正确,未能导入.";
error++;
conbool = true;
continue;
}
//---****文件是否存在验证*****--
if (!System.IO.File.Exists(decompressionDirectory + filepath))
{
falseMessage += "</br>" + "第" + (i + 1) + "行指定附件不存在,未能导入.";
error++;
conbool = true;
continue;
}
var fileinfo = new FileInfo(decompressionDirectory + filepath);
FileInfoEntity fileInfoEntity = new FileInfoEntity();
string fileguid = Guid.NewGuid().ToString();
fileInfoEntity.Create();
fileInfoEntity.RecId = standard.ID; //关联ID
fileInfoEntity.FileName = filepath;
fileInfoEntity.FilePath = "~/Resource/StandardSystem/" + fileguid + fileinfo.Extension;
fileInfoEntity.FileSize = (Math.Round(decimal.Parse(fileinfo.Length.ToString()) / decimal.Parse("1024"), 2)).ToString();//文件大小（kb）
fileInfoEntity.FileExtensions = fileinfo.Extension;
fileInfoEntity.FileType = fileinfo.Extension.Replace(".", "");
TransportRemoteToServer(Server.MapPath("~/Resource/StandardSystem/"), decompressionDirectory + filepath, fileguid + fileinfo.Extension);
fileinfobll.SaveForm("", fileInfoEntity);
}
if (conbool)
{
continue;
}
standard.FileName = filename;
standard.FileNo = fileno;
standard.RefId = refid;
standard.RefName = refname;
DepartmentEntity deptEntity = deptBll.GetEntityByCode(deptcode);
if (deptEntity != null)
{
standard.PubDepartId = deptEntity.DepartmentId;
standard.PubDepartName = deptEntity.FullName;
}
else
{
standard.PubDepartId = OperatorProvider.Provider.Current().DeptId;
standard.PubDepartName = OperatorProvider.Provider.Current().DeptName;
}
if (!string.IsNullOrEmpty(dt.Rows[i][3].ToString()))
{
standard.PubDate = Convert.ToDateTime(dt.Rows[i][3].ToString());
}
if (!string.IsNullOrEmpty(dt.Rows[i][4].ToString()))
{
standard.ReviseDate = Convert.ToDateTime(dt.Rows[i][4].ToString());
}
if (!string.IsNullOrEmpty(dt.Rows[i][5].ToString()))
{
standard.UseDate = Convert.ToDateTime(dt.Rows[i][5].ToString());
}
standard.Remark = !string.IsNullOrEmpty(dt.Rows[i][6].ToString()) ? dt.Rows[i][6].ToString() : "";
try
{
stdsysfilesbll.SaveForm(standard.ID, standard);
success++;
}
catch
{
error++;
}
}
message = "共有" + dt.Rows.Count + "条记录,成功导入" + success + "条，失败" + error + "条";
message += "</br>" + falseMessage;
}
return(message);
}
catch (Exception e)
{
return("导入的Excel数据格式不正确，请下载标准模板重新填写！");
}
}
public object getSafetyLawList([FromBody] JObject json)
{
try
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string userId = dy.userid;
//获取用户基本信息
OperatorProvider.AppUserId = userId; //设置当前用户
Operator user = OperatorProvider.Provider.Current();
var reqParam = JsonConvert.DeserializeAnonymousType(res, new
{
data = new
{
ORGANIZECODE = string.Empty
}
});
string filename = dy.data.filename; //文件名称
string type = dy.data.type; //类型（1:生产法律法规 2.安全管理制度 3.安全操作规程 4.安全法律法规最新五条数据）
string organizecode = string.IsNullOrEmpty(reqParam.data.ORGANIZECODE) ? user.OrganizeCode : reqParam.data.ORGANIZECODE;
string orgcode = reqParam.data.ORGANIZECODE;
string strwhere = "";
string sql = "";
if (!string.IsNullOrEmpty(filename))
{
strwhere += " and filename like '%" + filename + "%'";
}
string codewhere = "";
if (user.DeptCode == user.OrganizeCode)
{
codewhere = "";
}
else
{
var provdata = departmentBLL.GetList().Where(t => t.Nature == "省级" && !t.FullName.Contains("各电厂") && t.FullName != "区域子公司" && t.DeptCode.StartsWith(user.NewDeptCode.Substring(0, 3)));
DepartmentEntity provEntity = null;
//省级根节点
if (provdata.Count() > 0)
{
provEntity = provdata.FirstOrDefault();
codewhere = string.Format(" or createuserorgcode='{0}'", provEntity.EnCode);
}
}
if (type == "1") //安全生产法律法规
{
if (!string.IsNullOrEmpty(orgcode))
{
if (orgcode == "省级")
{
sql = string.Format(@"select id as fileid,filename,issuedept,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safetylaw where (createuserorgcode='00' {1}) {0} order by createdate desc", strwhere, codewhere);
}
else
{
sql = string.Format(@"select id as fileid,filename,issuedept,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safetylaw where (createuserorgcode='{1}') {0} order by createdate desc", strwhere, orgcode);
}
}
else
{
if (user.RoleName.Contains("省级用户"))
{
sql = string.Format(@"select id as fileid,filename,issuedept,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safetylaw where (createuserorgcode='00' or createuserorgcode='{1}') {0} order by createdate desc", strwhere, user.OrganizeCode);
}
else
{
sql = string.Format(@"select id as fileid,filename,issuedept,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safetylaw where (createuserorgcode='{1}' {2} or createuserorgcode='00') {0} order by createdate desc", strwhere, user.OrganizeCode, codewhere);
}
}
}
if (type == "2")
{
if (!string.IsNullOrEmpty(orgcode))
{
if (orgcode == "省级")
{
sql = string.Format(@"select id as fileid,filename,b.itemname as lawtypecode,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safeinstitution a left join base_dataitemdetail b on a.lawtypecode=b.itemvalue where itemid =(select itemid from base_dataitem where itemcode='InstitutionLaw') and (a.createuserorgcode='00' {1}) {0} order by a.createdate desc", strwhere, codewhere);
}
else
{
sql = string.Format(@"select id as fileid,filename,b.itemname as lawtypecode,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safeinstitution a left join base_dataitemdetail b on a.lawtypecode=b.itemvalue where itemid =(select itemid from base_dataitem where itemcode='InstitutionLaw') and (a.createuserorgcode='{1}') {0} order by a.createdate desc", strwhere, orgcode);
}
}
else
{
//安全管理制度
if (user.RoleName.Contains("省级用户"))
{
sql = string.Format(@"select id as fileid,filename,b.itemname as lawtypecode,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safeinstitution a left join base_dataitemdetail b on a.lawtypecode=b.itemvalue where itemid =(select itemid from base_dataitem where itemcode='InstitutionLaw') and (a.createuserorgcode in (select encode from base_department where deptcode like '{1}%') or a.createuserorgcode='00') {0} order by a.createdate desc", strwhere, organizecode);
}
else
{
sql = string.Format(@"select id as fileid,filename,b.itemname as lawtypecode,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safeinstitution a left join base_dataitemdetail b on a.lawtypecode=b.itemvalue where itemid =(select itemid from base_dataitem where itemcode='InstitutionLaw') and (a.createuserorgcode='{1}' {2} or a.createuserorgcode='00') {0} order by a.createdate desc", strwhere, user.OrganizeCode, codewhere);
}
}
}
if (type == "3")
{
if (!string.IsNullOrEmpty(orgcode))
{
if (orgcode == "省级")
{
sql = string.Format(@"select id as fileid,filename,b.itemname as lawtypecode,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safestandards a left join base_dataitemdetail b on a.lawtypecode=b.itemvalue where itemid =(select itemid from base_dataitem where itemcode='StandardsLaw') and (a.createuserorgcode='00' {1}) {0} order by a.createdate desc", strwhere, codewhere);
}
else
{
sql = string.Format(@"select id as fileid,filename,b.itemname as lawtypecode,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safestandards a left join base_dataitemdetail b on a.lawtypecode=b.itemvalue where itemid =(select itemid from base_dataitem where itemcode='StandardsLaw') and (a.createuserorgcode='{1}') {0} order by a.createdate desc", strwhere, orgcode);
}
}
else
{
if (user.RoleName.Contains("省级用户"))
{
sql = string.Format(@"select id as fileid,filename,b.itemname as lawtypecode,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safestandards a left join base_dataitemdetail b on a.lawtypecode=b.itemvalue where itemid =(select itemid from base_dataitem where itemcode='StandardsLaw') and (a.createuserorgcode in (select encode from base_department where deptcode like '{1}%') or a.createuserorgcode='00') {0} order by a.createdate desc", strwhere, organizecode);
}
else
{
sql = string.Format(@"select id as fileid,filename,b.itemname as lawtypecode,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safestandards a left join base_dataitemdetail b on a.lawtypecode=b.itemvalue where itemid =(select itemid from base_dataitem where itemcode='StandardsLaw') and (a.createuserorgcode='{1}' {2} or a.createuserorgcode='00') {0} order by a.createdate desc", strwhere, user.OrganizeCode, codewhere);
}
}
}
if (type == "4")
{
sql = string.Format(@"select a.* from (select id as fileid,filename,issuedept,to_char(carrydate,'yyyy-mm-dd') as carrydate from bis_safetylaw where createuserorgcode='{1}' {0} order by createdate desc)a where rownum <=5 ", strwhere, user.OrganizeCode);
}
DataTable dt = pbll.GetPerilEngineeringList(sql);
return(new
{
Code = 0,
Count = dt.Rows.Count,
Info = "获取数据成功",
data = dt
});
}
catch (Exception ex)
{
return(new { Code = -1, Count = 0, Info = ex.Message });
}
}
public ActionResult SaveForm(string keyValue, DepartmentEntity entity)
{
departmentIBLL.SaveEntity(keyValue, entity);
return(Success("保存成功！"));
}
public async Task <IActionResult> SaveFormJson(DepartmentEntity entity)
{
TData <string> obj = await departmentBLL.SaveForm(entity);
return(Json(obj));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns>返回分页列表</returns>
public DataTable GetPageDataTable(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["filename"].IsEmpty())
{
pagination.conditionJson += string.Format(" and FileName like '%{0}%'", queryParam["filename"].ToString());
}
if (user.RoleName.Contains("省级用户"))
{
if (!queryParam["orgcode"].IsEmpty())
{
pagination.conditionJson += string.Format(" and createuserorgcode ='{0}'", queryParam["orgcode"].ToString());
}
}
else
{
//0本级,1上级
if (!queryParam["state"].IsEmpty())
{
if (queryParam["state"].ToString() == "0")
{
pagination.conditionJson += string.Format(" and createuserorgcode ='{0}'", user.OrganizeCode);
}
else
{
var provdata = DepartmentService.GetList().Where(t => user.NewDeptCode.StartsWith(t.DeptCode) && t.Nature == "省级" && string.IsNullOrWhiteSpace(t.Description));
if (provdata.Count() > 0)
{
DepartmentEntity provEntity = provdata.FirstOrDefault();
pagination.conditionJson += string.Format(" and createuserorgcode ='{0}'", provEntity.EnCode);
}
}
}
}
//时间范围
if (!queryParam["sTime"].IsEmpty() || !queryParam["eTime"].IsEmpty())
{
string startTime = queryParam["sTime"].ToString();
string endTime = queryParam["eTime"].ToString();
if (queryParam["sTime"].IsEmpty())
{
startTime = "1899-01-01";
}
if (queryParam["eTime"].IsEmpty())
{
endTime = DateTime.Now.ToString("yyyy-MM-dd");
}
pagination.conditionJson += string.Format(" and ReleaseDate between to_date('{0}','yyyy-MM-dd') and to_date('{1}','yyyy-MM-dd')", startTime, endTime);
}
//选择的类型
if (!queryParam["treeCode"].IsEmpty())
{
if (!queryParam["flag"].IsEmpty())
{
if (queryParam["flag"].ToString() == "0")
{
pagination.conditionJson += string.Format(" and LawTypeCode='{0}'", queryParam["treeCode"].ToString());
}
else
{
pagination.conditionJson += string.Format(@" and LawTypeCode like '{0}%'", queryParam["treeCode"].ToString());
}
}
else
{
pagination.conditionJson += string.Format(" and LawTypeCode='{0}'", queryParam["treeCode"].ToString());
}
}
//选中的数据
if (!queryParam["idsData"].IsEmpty())
{
var ids = queryParam["idsData"].ToString();
string idsarr = "";
if (ids.Contains(','))
{
string[] array = ids.TrimEnd(',').Split(',');
foreach (var item in array)
{
idsarr += "'" + item + "',";
}
if (idsarr.Contains(","))
{
idsarr = idsarr.TrimEnd(',');
}
}
pagination.conditionJson += string.Format(" and id in({0})", idsarr);
}
if (!queryParam["code"].IsEmpty())
{
pagination.conditionJson += string.Format(" and ISSUEDEPT in (select departmentid from base_department where encode like '{0}%')", queryParam["code"].ToString());
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
/// <summary>
/// 添加部门
/// </summary>
public int AddDepartment(DepartmentEntity department)
{
return(dal.AddDepartment(department));
}
public bool Update(DepartmentEntity entity)
{
return(depAccess.Update(entity));
}
/// <summary>
/// 修改部门
/// </summary>
public bool EditDepartment(DepartmentEntity department)
{
return(dal.EditDepartment(department));
}
public async Task Create(DepartmentEntity entity)
{
var entry = db.Add(entity);
await context.SaveChangesAsync();
}
/// <summary>
/// Inserts the department.
/// </summary>
/// <param name="department">The department.</param>
/// <returns></returns>
public int InsertDepartment(DepartmentEntity department)
{
const string sql = @"uspInsert_Department";
return(Db.Insert(sql, true, Take(department)));
}
public ActionResult SubmitForm(string keyValue, SafetyCollectEntity entity)
{
Operator curUser = ERCHTMS.Code.OperatorProvider.Provider.Current();
string state = string.Empty;
string flowid = string.Empty;
string moduleName = "竣工安全验收";
// <param name="state">是否有权限审核 1：能审核 0 ：不能审核</param>
ManyPowerCheckEntity mpcEntity = dailyexaminebll.CheckAuditPower(curUser, out state, moduleName, curUser.DeptId);
//新增时会根据角色自动审核
List <ManyPowerCheckEntity> powerList = new ManyPowerCheckBLL().GetListBySerialNum(curUser.OrganizeCode, "竣工安全验收");
List <ManyPowerCheckEntity> checkPower = new List <ManyPowerCheckEntity>();
var outsouringengineer = outsouringengineerbll.GetEntity(entity.EngineerId);
//先查出执行部门编码
for (int i = 0; i < powerList.Count; i++)
{
if (powerList[i].CHECKDEPTCODE == "-1" || powerList[i].CHECKDEPTID == "-1")
{
var createdeptentity = new DepartmentBLL().GetEntity(outsouringengineer.ENGINEERLETDEPTID);
var createdeptentity2 = new DepartmentEntity();
while (createdeptentity.Nature == "专业" || createdeptentity.Nature == "班组")
{
createdeptentity2 = new DepartmentBLL().GetEntity(createdeptentity.ParentId);
if (createdeptentity2.Nature != "专业" || createdeptentity2.Nature != "班组")
{
break;
}
}
powerList[i].CHECKDEPTCODE = createdeptentity.DeptCode;
powerList[i].CHECKDEPTID = createdeptentity.DepartmentId;
if (createdeptentity2 != null)
{
powerList[i].CHECKDEPTCODE = createdeptentity.DeptCode + "," + createdeptentity2.DeptCode;
powerList[i].CHECKDEPTID = createdeptentity.DepartmentId + "," + createdeptentity2.DepartmentId;
}
}
//创建部门
if (powerList[i].CHECKDEPTCODE == "-3" || powerList[i].CHECKDEPTID == "-3")
{
var createdeptentity = new DepartmentBLL().GetEntityByCode(curUser.DeptCode);
while (createdeptentity.Nature == "专业" || createdeptentity.Nature == "班组")
{
createdeptentity = new DepartmentBLL().GetEntity(createdeptentity.ParentId);
}
powerList[i].CHECKDEPTCODE = createdeptentity.DeptCode;
powerList[i].CHECKDEPTID = createdeptentity.DepartmentId;
}
}
//登录人是否有审核权限--有审核权限直接审核通过
for (int i = 0; i < powerList.Count; i++)
{
if (powerList[i].CHECKDEPTID.Contains(curUser.DeptId))
{
var rolelist = curUser.RoleName.Split(',');
for (int j = 0; j < rolelist.Length; j++)
{
if (powerList[i].CHECKROLENAME.Contains(rolelist[j]))
{
checkPower.Add(powerList[i]);
break;
}
}
}
}
if (checkPower.Count > 0)
{
state = "1";
ManyPowerCheckEntity check = checkPower.Last();//当前
for (int i = 0; i < powerList.Count; i++)
{
if (check.ID == powerList[i].ID)
{
flowid = powerList[i].ID;
}
}
}
else
{
state = "0";
mpcEntity = powerList.First();
}
if (null != mpcEntity)
{
entity.FLOWDEPT = mpcEntity.CHECKDEPTID;
entity.FLOWDEPTNAME = mpcEntity.CHECKDEPTNAME;
entity.FLOWROLE = mpcEntity.CHECKROLEID;
entity.FLOWROLENAME = mpcEntity.CHECKROLENAME;
entity.ISSAVED = "1"; //标记已经从登记到审核阶段
entity.ISOVER = "0"; //流程未完成，1表示完成
//entity.FLOWNAME = entity.FLOWDEPTNAME + "审核中";
if (mpcEntity.CHECKDEPTNAME == "执行部门" && mpcEntity.CHECKROLENAME == "负责人")
{
entity.FLOWNAME = outsouringengineer.ENGINEERLETDEPT + "审批中";
}
else
{
entity.FLOWNAME = mpcEntity.CHECKDEPTNAME + "审批中";
}
entity.FlowId = mpcEntity.ID;
}
else //为空则表示已经完成流程
{
entity.FLOWDEPT = "";
entity.FLOWDEPTNAME = "";
entity.FLOWROLE = "";
entity.FLOWROLENAME = "";
entity.ISSAVED = "1"; //标记已经从登记到审核阶段
entity.ISOVER = "1"; //流程未完成，1表示完成
entity.FLOWNAME = "";
entity.FlowId = flowid;
}
SafetyCollectbll.SaveForm(keyValue, entity);
//添加审核记录
if (state == "1")
{
//审核信息表
AptitudeinvestigateauditEntity aidEntity = new AptitudeinvestigateauditEntity();
aidEntity.AUDITRESULT = "0"; //通过
aidEntity.AUDITTIME = DateTime.Now;
aidEntity.AUDITPEOPLE = curUser.UserName;
aidEntity.AUDITPEOPLEID = curUser.UserId;
aidEntity.APTITUDEID = entity.ID; //关联的业务ID
aidEntity.AUDITOPINION = ""; //审核意见
aidEntity.AUDITSIGNIMG = curUser.SignImg;
if (null != mpcEntity)
{
aidEntity.REMARK = (powerList[0].AUTOID.Value - 1).ToString(); //备注 存流程的顺序号
//aidEntity.FlowId = mpcEntity.ID;
}
else
{
aidEntity.REMARK = "7";
}
aidEntity.FlowId = flowid;
aidEntity.AUDITDEPTID = curUser.DeptId;
aidEntity.AUDITDEPT = curUser.DeptName;
aptitudeinvestigateauditbll.SaveForm(aidEntity.ID, aidEntity);
}
return(Success("操作成功!"));
}
/// <summary>
/// Updates the department.
/// </summary>
/// <param name="department">The department.</param>
/// <returns></returns>
public string UpdateDepartment(DepartmentEntity department)
{
const string sql = @"uspUpdate_Department";
return(Db.Update(sql, true, Take(department)));
}
/// <summary>
/// 删除部门信息
/// </summary>
/// <param name="Department">部门信息实体</param>
/// <returns></returns>
public int DeleteDepartment(DepartmentEntity Department)
{
return(DataAccess.DeleteDepartment(Department));
}
public ActionResult CopyInfo(CopyRequestModel model)
{
if (!string.IsNullOrWhiteSpace(model.DeptId) && !string.IsNullOrWhiteSpace(model.Id))
{
//先查询出授权信息
MenuAuthorizeEntity entity = authorizeBLL.GetEntity(model.Id);
if (entity != null)
{
DepartmentBLL departmentBll = new DepartmentBLL();
var deptIdArry = model.DeptId.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
var deptCodeArry = model.DeptCode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
var deptNameArry = model.DeptName.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
//菜单授权信息
DeptMenuAuthBLL deptMenuAuthBll = new DeptMenuAuthBLL();
List <DeptMenuAuthEntity> deptMenuAuthList = deptMenuAuthBll.GetList(entity.DepartId);
//界面设置
List <AppMenuSettingEntity> appMenuSettingEntities =
new AppMenuSettingBLL().GetListByDeptId(entity.DepartId);
//栏目与菜单的关联关系
List <AppSettingAssociationEntity> appSettingAssociationList =
new AppSettingAssociationBLL().GetList(entity.DepartId);
List <DeptMenuAuthEntity> insetDeptMenuAuthList = new List <DeptMenuAuthEntity>();
List <MenuAuthorizeEntity> authorizeEntities = new List <MenuAuthorizeEntity>(); //复制之后要保存到数据库中的单位授权数据
List <AppMenuSettingEntity> insertMenuSettingEntities = new List <AppMenuSettingEntity>(); //界面设置
List <AppSettingAssociationEntity> insertAssociationEntities = new List <AppSettingAssociationEntity>(); //关联关系
for (int i = 0; i < deptIdArry.Length; i++)
{
//1、先复制单位的授权信息
DepartmentEntity deptEntity = departmentBll.GetEntity(deptIdArry[i]);
MenuAuthorizeEntity insertEntity = new MenuAuthorizeEntity()
{
Id = Guid.NewGuid().ToString(),
DepartId = deptIdArry[i],
DepartCode = deptCodeArry[i],
DepartName = deptNameArry[i],
DisplayName = deptNameArry[i],
BZApiUrl = entity.BZApiUrl,
CreateDate = entity.CreateDate,
CreateUserId = entity.CreateUserId,
CreateUserName = entity.CreateUserName,
CulturalUrl = entity.CulturalUrl,
ModifyDate = entity.ModifyDate,
ModifyUserId = entity.ModifyUserId,
ModifyUserName = entity.ModifyUserName,
PXApiUrl = entity.PXApiUrl,
RegistCode = entity.RegistCode,
SKApiUrl = entity.SKApiUrl,
TerminalCode = entity.TerminalCode,
ThemeType = entity.ThemeType,
VersionCode = entity.VersionCode,
ParentId = deptEntity != null? deptEntity.ParentId : "",
ParentName =
deptEntity != null && deptEntity.ParentId == "0"
? ""
: departmentBll.GetEntity(deptEntity.ParentId).FullName
};
authorizeEntities.Add(insertEntity);
//2、复制界面设置
appMenuSettingEntities.ForEach(setting =>
{
AppMenuSettingEntity appMenu = setting.Clone(deptIdArry[i], deptNameArry[i], deptCodeArry[i], appSettingAssociationList, insertAssociationEntities);
insertMenuSettingEntities.Add(appMenu);
});
//3、 复制关联关系
//appSettingAssociationList.ForEach(e =>
//{
// AppSettingAssociationEntity association = e.Clone(deptIdArry[i], ,insetDeptMenuAuthList);
// insertAssociationEntities.Add(association);
//});
//4、复制菜单授权信息
deptMenuAuthList.ForEach(p =>
{
DeptMenuAuthEntity deptMenu = p.Clone(deptIdArry[i], deptCodeArry[i], deptNameArry[i]);
insetDeptMenuAuthList.Add(deptMenu);
});
}
authorizeBLL.InsertEntity(authorizeEntities.ToArray());
new AppMenuSettingBLL().InsertList(insertMenuSettingEntities);
new AppSettingAssociationBLL().InsertList(insertAssociationEntities);
new DeptMenuAuthBLL().InsertList(insetDeptMenuAuthList);
}
}
return(Success("操作成功"));
}
/// <summary>
/// 获得指定模块或者编号的单据号
/// </summary>
/// <param name="enCode">编码</param>
/// <param name="userId">用户ID</param>
/// <returns>单据号</returns>
public string GetBillCode(string enCode, string userId = "")
{
try
{
string billCode = ""; //单据号
string nextBillCode = ""; //单据号
bool isOutTime = false; //是否已过期
CodeRuleEntity coderuleentity = GetEntityByCode(enCode);
if (coderuleentity != null)
{
UserInfo userInfo = null;
if (string.IsNullOrEmpty(userId))
{
userInfo = LoginUserInfo.Get();
}
else
{
UserEntity userEntity = userIBLL.GetEntityByUserId(userId);
userInfo = new UserInfo
{
userId = userEntity.F_UserId,
enCode = userEntity.F_EnCode,
password = userEntity.F_Password,
secretkey = userEntity.F_Secretkey,
realName = userEntity.F_RealName,
nickName = userEntity.F_NickName,
headIcon = userEntity.F_HeadIcon,
gender = userEntity.F_Gender,
mobile = userEntity.F_Mobile,
telephone = userEntity.F_Telephone,
email = userEntity.F_Email,
oICQ = userEntity.F_OICQ,
weChat = userEntity.F_WeChat,
companyId = userEntity.F_CompanyId,
departmentId = userEntity.F_DepartmentId,
openId = userEntity.F_OpenId,
isSystem = userEntity.F_SecurityLevel == 1 ? true : false
};
}
int nowSerious = 0;
List <CodeRuleFormatModel> codeRuleFormatList = coderuleentity.F_RuleFormatJson.ToList <CodeRuleFormatModel>();
string dateFormatStr = "";
foreach (CodeRuleFormatModel codeRuleFormatEntity in codeRuleFormatList)
{
switch (codeRuleFormatEntity.itemType.ToString())
{
//自定义项
case "0":
billCode = billCode + codeRuleFormatEntity.formatStr;
nextBillCode = nextBillCode + codeRuleFormatEntity.formatStr;
break;
//日期
case "1":
//日期字符串类型
dateFormatStr = codeRuleFormatEntity.formatStr;
billCode = billCode + DateTime.Now.ToString(codeRuleFormatEntity.formatStr.Replace("m", "M"));
nextBillCode = nextBillCode + DateTime.Now.ToString(codeRuleFormatEntity.formatStr.Replace("m", "M"));
break;
//流水号
case "2":
CodeRuleSeedEntity maxSeed = null;
CodeRuleSeedEntity codeRuleSeedEntity = null;
List <CodeRuleSeedEntity> seedList = GetSeedList(coderuleentity.F_RuleId, userInfo);
maxSeed = seedList.Find(t => t.F_UserId.IsEmpty());
int seedStep = codeRuleFormatEntity.stepValue == null ? 1 : int.Parse(codeRuleFormatEntity.stepValue.ToString()); //如果步长为空默认1
int initValue = codeRuleFormatEntity.initValue == null ? 1 : int.Parse(codeRuleFormatEntity.initValue.ToString()); //如果初始值为空默认1
if (maxSeed.IsInit)
{
maxSeed.F_SeedValue = initValue;
}
#region 处理流水号归0
// 首先确定最大种子是否未归0的
if (dateFormatStr.Contains("dd"))
{
if ((maxSeed.F_ModifyDate).ToDateString() != DateTime.Now.ToString("yyyy-MM-dd"))
{
isOutTime = true;
nowSerious = initValue;
maxSeed.F_SeedValue = initValue + seedStep;
maxSeed.F_ModifyDate = DateTime.Now;
}
}
else if (dateFormatStr.Contains("mm"))
{
if (((DateTime)maxSeed.F_ModifyDate).ToString("yyyy-MM") != DateTime.Now.ToString("yyyy-MM"))
{
isOutTime = true;
nowSerious = initValue;
maxSeed.F_SeedValue = initValue + seedStep;
maxSeed.F_ModifyDate = DateTime.Now;
}
}
else if (dateFormatStr.Contains("yy"))
{
if (((DateTime)maxSeed.F_ModifyDate).ToString("yyyy") != DateTime.Now.ToString("yyyy"))
{
isOutTime = true;
nowSerious = initValue;
maxSeed.F_SeedValue = initValue + seedStep;
maxSeed.F_ModifyDate = DateTime.Now;
}
}
#endregion
// 查找当前用户是否已有之前未用掉的种子做更新
codeRuleSeedEntity = seedList.Find(t => t.F_UserId == userInfo.userId && t.F_RuleId == coderuleentity.F_RuleId && (t.F_CreateDate).ToDateString() == DateTime.Now.ToString("yyyy-MM-dd"));
string keyvalue = codeRuleSeedEntity == null ? "" : codeRuleSeedEntity.F_RuleSeedId;
if (isOutTime)
{
SaveSeed(maxSeed.F_RuleSeedId, maxSeed, userInfo);
}
else if (codeRuleSeedEntity == null)
{
nowSerious = (int)maxSeed.F_SeedValue;
maxSeed.F_SeedValue += seedStep; //种子加步长
maxSeed.Modify(maxSeed.F_RuleSeedId, userInfo);
SaveSeed(maxSeed.F_RuleSeedId, maxSeed, userInfo);
}
else
{
nowSerious = (int)codeRuleSeedEntity.F_SeedValue;
}
codeRuleSeedEntity = new CodeRuleSeedEntity();
codeRuleSeedEntity.Create(userInfo);
codeRuleSeedEntity.F_SeedValue = nowSerious;
codeRuleSeedEntity.F_UserId = userInfo.userId;
codeRuleSeedEntity.F_RuleId = coderuleentity.F_RuleId;
SaveSeed(keyvalue, codeRuleSeedEntity, userInfo);
// 最大种子已经过期
string seriousStr = new string('0', (int)(codeRuleFormatEntity.formatStr.Length - nowSerious.ToString().Length)) + nowSerious.ToString();
string NextSeriousStr = new string('0', (int)(codeRuleFormatEntity.formatStr.Length - nowSerious.ToString().Length)) + maxSeed.F_SeedValue.ToString();
billCode = billCode + seriousStr;
nextBillCode = nextBillCode + NextSeriousStr;
break;
//部门
case "3":
DepartmentEntity departmentEntity = departmentIBLL.GetEntity(userInfo.companyId, userInfo.departmentId);
if (codeRuleFormatEntity.formatStr == "code")
{
billCode = billCode + departmentEntity.F_EnCode;
nextBillCode = nextBillCode + departmentEntity.F_EnCode;
}
else
{
billCode = billCode + departmentEntity.F_FullName;
nextBillCode = nextBillCode + departmentEntity.F_FullName;
}
break;
//公司
case "4":
CompanyEntity companyEntity = companyIBLL.GetEntity(userInfo.companyId);
if (codeRuleFormatEntity.formatStr == "code")
{
billCode = billCode + companyEntity.F_EnCode;
nextBillCode = nextBillCode + companyEntity.F_EnCode;
}
else
{
billCode = billCode + companyEntity.F_FullName;
nextBillCode = nextBillCode + companyEntity.F_FullName;
}
break;
//用户
case "5":
if (codeRuleFormatEntity.formatStr == "code")
{
billCode = billCode + userInfo.enCode;
nextBillCode = nextBillCode + userInfo.enCode;
}
else
{
billCode = billCode + userInfo.account;
nextBillCode = nextBillCode + userInfo.account;
}
break;
default:
break;
}
}
coderuleentity.F_CurrentNumber = nextBillCode;
SaveEntity(coderuleentity.F_RuleId, coderuleentity, userInfo);
}
return(billCode);
}
catch (Exception ex)
{
if (ex is ExceptionEx)
{
throw;
}
else
{
throw ExceptionEx.ThrowBusinessException(ex);
}
}
}
public ActionResult SubmitForm(DepartmentEntity infoEntity, string keyValue)
{
app.SubmitForm(infoEntity, keyValue);
return(Success("操作成功。"));
}
/// <summary>
/// 同步用户
/// </summary>
public bool ErchtmsSynchronoous(string type, object o, string account)
{
var baseUrl = Config.GetValue("ErchtmsApiUrl");
if (Config.GetValue("SyncBool") == "f")
{
return(true);
}
string id = "";
WebClient wc = new WebClient();
wc.Credentials = CredentialCache.DefaultCredentials;
//发送请求到web api并获取返回值，默认为post方式
try
{
System.Collections.Specialized.NameValueCollection nc = new System.Collections.Specialized.NameValueCollection();
if (type == "SaveUser")
{
UserEntity user = (UserEntity)o;
id = user.UserId;
nc.Add("account", account);
nc.Add("json", Newtonsoft.Json.JsonConvert.SerializeObject(user));
}
else if (type == "SaveDept")
{
DepartmentEntity d = (DepartmentEntity)o;
id = d.DepartmentId;
nc.Add("account", BSFramework.Application.Code.OperatorProvider.Provider.Current().Account);
nc.Add("json", Newtonsoft.Json.JsonConvert.SerializeObject(d));
}
else if (type == "SaveRole")
{
RoleEntity r = (RoleEntity)o;
id = r.RoleId;
nc.Add("account", BSFramework.Application.Code.OperatorProvider.Provider.Current().Account);
nc.Add("json", Newtonsoft.Json.JsonConvert.SerializeObject(r));
}
if (type == "DeleteUser")
{
UserEntity user = (UserEntity)o;
id = user.UserId;
nc.Add("account", account);
nc.Add("json", Newtonsoft.Json.JsonConvert.SerializeObject(user));
}
else if (type == "DeleteDept")
{
DepartmentEntity d = (DepartmentEntity)o;
id = d.DepartmentId;
nc.Add("account", BSFramework.Application.Code.OperatorProvider.Provider.Current().Account);
nc.Add("json", Newtonsoft.Json.JsonConvert.SerializeObject(d));
}
else if (type == "DeleteRole")
{
RoleEntity r = (RoleEntity)o;
id = r.RoleId;
nc.Add("account", BSFramework.Application.Code.OperatorProvider.Provider.Current().Account);
nc.Add("json", Newtonsoft.Json.JsonConvert.SerializeObject(r));
}
else if (type == "UpdatePwd")
{
string[] r = (string[])o;
nc.Add("userId", r[0]);
nc.Add("pwd", r[1]);
string path = baseUrl + "syncdata/" + type + "?userId=" + r[0] + "&pwd=" + r[1];
wc.UploadValuesCompleted += wc_UploadValuesCompleted;
wc.UploadValuesAsync(new Uri(path), nc);
return(true);
}
wc.UploadValuesCompleted += wc_UploadValuesCompleted;
string a = baseUrl + "syncdata/" + type + "?keyValue=" + id;
wc.UploadValuesAsync(new Uri(baseUrl + "syncdata/" + type + "?keyValue=" + id), nc);
}
catch (Exception ex)
{
//将同步结果写入日志文件
string fileName = DateTime.Now.ToString("yyyyMMdd") + ".log";
if (!Directory.Exists(System.Web.HttpContext.Current.Server.MapPath("~/logs")))
{
Directory.CreateDirectory(System.Web.HttpContext.Current.Server.MapPath("~/logs"));
}
System.IO.File.AppendAllText(System.Web.HttpContext.Current.Server.MapPath("~/logs/" + fileName), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "：同步数据失败，同步信息" + Newtonsoft.Json.JsonConvert.SerializeObject(o) + ",异常信息：" + ex.Message + "\r\n");
return(false);
}
return(true);
}
public DepartmentEntity Insert(DepartmentEntity entity);
