public static ResultInfoModel SaveUser(UserModel model, bool isExistAccount)
{
var result = new ResultInfoModel();
result.IsSuccess = _userdal.UpdateUser(model);
if (!string.IsNullOrWhiteSpace(model.Account) && !isExistAccount)
{
var isOrNotExistAccount = _accountDal.GetAccountByAccount(model.Account);
if (isOrNotExistAccount == null)
{
var account = new AccountModel();
account.BAAccount = model.Account;
account.BAPassword = EncryptHelper.DesEncrypt("123456");
account.BAUserId = model.Id;
account.BAType = UserEnum.Employee.GetHashCode();
account.BAIsValid = EnabledEnum.Enabled.GetHashCode();
account.BACreateUserNo = model.BUOperateUserNo;
account.BACreateUserName = model.BUOperateUserName;
account.BACreateTime = DateTime.Now;
account.BAOperateUserNo = model.BUOperateUserNo;
account.BAOperateUserName = model.BUOperateUserName;
account.BAOperateTime = DateTime.Now;
_accountDal.InsertAccount(account);
result.Code = EncryptHelper.DesEncrypt(model.Id.ToString());
}
else
{
result.IsSuccess = false;
result.Message = "Account has exist!";
}
}
return(result);
}
public ActionResult Reset(string account, string password)
{
var result = new ResultInfoModel {
IsSuccess = false
};
try
{
var accontInfo = HomeBusiness.RestAccount(account, password, this.LoginUser);
var login = HomeBusiness.Login(account, password);
//写入cookie
string key = CommonHelper.Md5(CookieKey.COOKIE_KEY_USERINFO);
string data = JsonHelper.Serializer <UserLoginInfo>(login);
CookieHelper.SetCookie(
key,
CommonHelper.DesEncrypt(data, CookieKey.COOKIE_KEY_ENCRYPT),
DateTime.Now.AddDays(1).Date,
ServerInfo.GetTopDomain);
result.IsSuccess = accontInfo.IsSuccess;
result.Message = accontInfo.Message;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(Json(result));
}
public static ResultInfoModel SaveDepartment(DepartmentSaveModel model, UserLoginInfo loginUser)
{
var result = new ResultInfoModel()
{
IsSuccess = true
};
try
{
var entity = new DepartmentModel()
{
Id = long.Parse(model.DepartId),
BDParentId = long.Parse(model.ParentId),
BDDeptName = model.DepartName,
BDDeptDesc = model.DepartDesc,
BDIsValid = model.IsValid,
BDOperateUserNo = loginUser.JobNum,
BDOperateUserName = loginUser.UserName,
BDOperateTime = DateTime.Now
};
_departmentDal.Update(entity);
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
public static ResultInfoModel SaveNewUser(User model)
{
var result = new ResultInfoModel();
if (IfHaveSamePhone(model.BUPhoneNum))
{
result.IsSuccess = false;
result.Message = "已存在相同手机号的用户";
return(result);
}
if (string.IsNullOrEmpty(model.BUJobNumber) && IfHaveSameJobNumber(model.BUJobNumber))
{
result.IsSuccess = false;
result.Message = "已存在相同工号的用户";
return(result);
}
var userId = string.Empty;
try
{
using (var tran = SqlHelper.BeginTransaction())
{
userId = EncryptHelper.DesEncrypt(_userdal.InsertUser(model, tran).ToString());
var account = new Account();
account.BAAccount = "默认账号";
account.BAAccount = "123456";
}
}
catch (Exception ex)
{ }
return(result);
}
public static ResultInfoModel InvalidStandVerification(long id, UserLoginInfo loginUser)
{
var returnvalue = new ResultInfoModel()
{
IsSuccess = false
};
var upParam = new InvalidParam()
{
Id = id,
JobNum = loginUser.JobNum,
Name = loginUser.UserName,
InvalidTime = DateTime.Now
};
try
{
var result = _verificationDal.Invalid(upParam);
returnvalue.IsSuccess = result;
}
catch (Exception ex)
{
returnvalue.IsSuccess = false;
returnvalue.Message = ex.Message;
}
return(returnvalue);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
var roleName = context.Request["roleName"];
var groupName = context.Request["groupName"];
var roleInfo = JurisdictionBusiness.GetRoleByRoleName(roleName);
var groupInfo = JurisdictionBusiness.GetGroupByGroupName(groupName);
var result = new ResultInfoModel {
IsSuccess = false
};
if (roleInfo != null && groupInfo != null)
{
result = JurisdictionBusiness.DiRoleToGroup(roleInfo.Id, groupInfo.Id);
}
if (result.IsSuccess)
{
context.Response.Write("Success");
}
else
{
context.Response.Write(result.Message);
}
}
public static ResultInfoModel RestAccount(string account, string password, UserLoginInfo loguser)
{
var result = new ResultInfoModel {
IsSuccess = false,
};
//验证账户名是否存在
var accountInfo = _accountDal.GetAccountByAccount(account);
if (accountInfo != null && accountInfo.BAPassword == password)
{
result.Message = "The password is same with the original password";
return(result);
}
if (accountInfo != null)
{
accountInfo.BAPassword = EncryptHelper.DesEncrypt(password);
accountInfo.BAOperateUserNo = loguser.JobNum;
accountInfo.BAOperateUserName = loguser.UserName;
accountInfo.BAOperateTime = DateTime.Now;
_accountDal.UpdataAccount(accountInfo);
result.IsSuccess = true;
result.Message = "Update Success";
}
return(result);
}
/// <summary>
/// 描述：启用或停用部门
/// 创建标识：cpf
/// 创建时间：2017-9-24 18:17:48
/// </summary>
/// <param name="Id"></param>
/// <param name="loginuser"></param>
/// <returns></returns>
public static ResultInfoModel UpdateDepartmentValid(string Id, UserLoginInfo loginuser)
{
var result = new ResultInfoModel();
var model = _departmentDal.GetDpById(Convert.ToInt32(Id));
if (model != null)
{
if (model.BDIsValid == EnabledEnum.Enabled.GetHashCode())
{
var deptlist = _departmentDal.GetDepartmentByParentId(long.Parse(Id));
if (deptlist != null && deptlist.Count > 0)
{
result.IsSuccess = false;
result.Message = "There is an effective sub department under the Department and cannot be deactivated!";
return(result);
}
var userList = _userdal.GetUserListByDeptId(long.Parse(Id));
if (userList != null && userList.Count > 0)
{
result.IsSuccess = false;
result.Message = "You can't disable this department because there are some in-service staff employees under the department!";
return(result);
}
model.BDIsValid = EnabledEnum.UnEnabled.GetHashCode();
model.BDOperateUserNo = loginuser.JobNum;
model.BDOperateUserName = loginuser.UserName;
model.BDOperateTime = DateTime.Now;
result.IsSuccess = _departmentDal.UpdateIsValid(model);
}
else
{
var dpInfo = _departmentDal.GetDepartById(Convert.ToInt32(Id));
if (!CheckDepartment(dpInfo.Name))
{
var parentDept = _departmentDal.GetDpById(int.Parse(model.BDParentId.ToString()));
if (parentDept != null && parentDept.BDIsValid == EnabledEnum.UnEnabled.GetHashCode())
{
result.IsSuccess = false;
result.Message = "The higher level has been disabled, so it cannot be enabled";
return(result);
}
model.BDIsValid = EnabledEnum.Enabled.GetHashCode();
model.BDOperateUserNo = loginuser.JobNum;
model.BDOperateUserName = loginuser.UserName;
model.BDOperateTime = DateTime.Now;
result.IsSuccess = _departmentDal.UpdateIsValid(model);
result.Code = EncryptHelper.DesEncrypt(model.BDParentId.ToString());
}
else
{
result.IsSuccess = false;
result.Message = dpInfo.Name + "already exists!";
return(result);
}
}
result.Message = "Edit Success";
}
return(result);
}
/// <summary>
/// 描述：启用或停用部门
/// 创建标识：cpf
/// 创建时间：2017-9-24 18:17:48
/// </summary>
/// <param name="Id"></param>
/// <param name="loginuser"></param>
/// <returns></returns>
public static ResultInfoModel UpdateDepartmentValid(string Id, UserLoginInfo loginuser)
{
var result = new ResultInfoModel();
var model = _departmentDal.GetDpById(Convert.ToInt32(Id));
if (model != null)
{
if (model.BDIsValid == EnabledEnum.Enabled.GetHashCode())
{
var deptlist = _departmentDal.GetDepartmentByParentId(long.Parse(Id));
if (deptlist != null && deptlist.Count > 0)
{
result.IsSuccess = false;
result.Message = "该部门下存在有效的子部门，不能停用!";
return(result);
}
var userList = _userdal.GetUserListByDeptId(long.Parse(Id));
if (userList != null && userList.Count > 0)
{
result.IsSuccess = false;
result.Message = "该部门下存在在职员工，不能停用!";
return(result);
}
model.BDIsValid = EnabledEnum.UnEnabled.GetHashCode();
model.BDOperateUserId = int.Parse(loginuser.UserId.ToString());
model.BDOperateUserName = loginuser.UserName;
model.BDOperateTime = DateTime.Now;
result.IsSuccess = _departmentDal.UpdateIsValid(model);
}
else
{
var dpInfo = _departmentDal.GetDepartById(Convert.ToInt32(Id));
if (!CheckDepartment(dpInfo.Name))
{
var parentDept = _departmentDal.GetDpById(int.Parse(model.BDParentId.ToString()));
if (parentDept != null && parentDept.BDIsValid == EnabledEnum.UnEnabled.GetHashCode())
{
result.IsSuccess = false;
result.Message = "上级部门已停用，故不能启用";
return(result);
}
model.BDIsValid = EnabledEnum.Enabled.GetHashCode();
model.BDOperateUserId = int.Parse(loginuser.UserId.ToString());
model.BDOperateUserName = loginuser.UserName;
model.BDOperateTime = DateTime.Now;
result.IsSuccess = _departmentDal.UpdateIsValid(model);
result.Code = EncryptHelper.DesEncrypt(model.BDParentId.ToString());
}
else
{
result.IsSuccess = false;
result.Message = "部门名" + dpInfo.Name + "已存在无法启用!";
return(result);
}
}
result.Message = "编辑成功";
}
return(result);
}
public ActionResult UpdateDepartmentValid(string Id)
{
var result = new ResultInfoModel();
if (!string.IsNullOrEmpty(Id))
{
result = HomeBusiness.UpdateDepartmentValid(EncryptHelper.DesDecrypt(Id), this.LoginUser);
}
return(Json(result));
}
public ActionResult SaveByGroup(string paraStr)
{
var model = JsonHelper.Deserialize <SaveByGroupIdModel>(paraStr);
var result = new ResultInfoModel {
IsSuccess = false
};
if (model != null)
{
result = JurisdictionBusiness.SaveRoleGroupRelationByGroup(model, this.LoginUser);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public static ResultInfoModel SaveNewUser(UserModel model)
{
var result = new ResultInfoModel {
IsSuccess = true
};
try
{
if (!string.IsNullOrWhiteSpace(model.Account))
{
var isOrNotExistAccount = _accountDal.GetAccountByAccount(model.Account);
if (isOrNotExistAccount == null)
{
var userId = _userdal.InsertUser(model);
var account = new AccountModel();
account.BAAccount = model.Account;
account.BAPassword = EncryptHelper.DesEncrypt("123456");
account.BAUserId = int.Parse(userId.ToString());
account.BAType = UserEnum.Employee.GetHashCode();
account.BAIsValid = EnabledEnum.Enabled.GetHashCode();
account.BACreateUserNo = model.BUCreateUserNo;
account.BACreateUserName = model.BUCreateUserName;
account.BACreateTime = DateTime.Now;
account.BAOperateUserNo = model.BUOperateUserNo;
account.BAOperateUserName = model.BUOperateUserName;
account.BAOperateTime = DateTime.Now;
_accountDal.InsertAccount(account);
result.Code = EncryptHelper.DesEncrypt(userId.ToString());
}
else
{
result.IsSuccess = false;
result.Message = "Account has exist!";
}
}
else
{
var userId = _userdal.InsertUser(model);
result.Code = EncryptHelper.DesEncrypt(userId.ToString());
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 描述：重置用户密码
/// </summary>
/// <param name="userid">用户Id</param>
/// <returns></returns>
public ActionResult RestPassByUserid(string userId)
{
var result = new ResultInfoModel {
IsSuccess = false
};
try
{
result = HomeBusiness.RestAccountByUserid(userId, LoginUser);
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(Json(result));
}
private void SetDetectedItemsToBindableItems(List <DetectedItemInfo> items)
{
m_ResultViewModel.ResultModelList.Clear();
foreach (DetectedItemInfo item in items)
{
ResultInfoModel resultModel = new ResultInfoModel();
resultModel.DetectionLabel = item.Type;
resultModel.Confidence = item.Confidence;
resultModel.DetectedBoxLeftTopX = item.X;
resultModel.DetectedBoxLeftTopY = item.Y;
resultModel.DetectedBoxWidth = item.Width;
resultModel.DetectedBoxHeight = item.Height;
m_ResultViewModel.ResultModelList.Add(resultModel);
}
DrawBoundingBox(items);
}
/// <summary>
/// 描述：根据用户id初始化用户密码
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static ResultInfoModel RestAccountByUserid(string userId, UserLoginInfo loguser)
{
var result = new ResultInfoModel {
IsSuccess = false,
};
var accountInfo = _accountDal.GetAccountByUserId(long.Parse(EncryptHelper.DesDecrypt(userId)));
if (accountInfo != null)
{
accountInfo.BAPassword = EncryptHelper.DesEncrypt(ConfigurationManager.AppSettings["defaultPassword"].ToString());
accountInfo.BAOperateUserNo = loguser.JobNum;
accountInfo.BAOperateUserName = loguser.UserName;
accountInfo.BAOperateTime = DateTime.Now;
_accountDal.UpdataAccount(accountInfo);
result.IsSuccess = true;
result.Message = "Update Success";
}
return(result);
}
/// <summary>
/// 描述:保存新部门
/// 创建标识：cpf
/// 创建时间：2017-9-21 21:56:37
/// </summary>
/// <param name="model"></param>
/// <param name="loginUser"></param>
/// <returns></returns>
public static ResultInfoModel SaveNewDepartment(DepartmentSaveModel model, UserLoginInfo loginUser)
{
var result = new ResultInfoModel()
{
IsSuccess = true
};
var flag = CheckDepartment(model.DepartName);
try
{
if (!flag)
{
var entity = new DepartmentModel()
{
BDParentId = long.Parse(model.ParentId),
BDDeptName = model.DepartName,
BDDeptDesc = model.DepartDesc ?? string.Empty,
BDIsValid = model.IsValid,
BDCreateUserNo = loginUser.JobNum,
BDCreateUserName = loginUser.UserName,
BDCreateTime = DateTime.Now,
BDOperateUserNo = loginUser.JobNum,
BDOperateUserName = loginUser.UserName,
BDOperateTime = DateTime.Now
};
var ids = _departmentDal.Insert(entity);
result.Code = EncryptHelper.DesEncrypt(ids.ToString());
}
else
{
result.IsSuccess = false;
result.Message = "A department with the same name already exists";
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 描述:保存新部门
/// 创建标识：cpf
/// 创建时间：2017-9-21 21:56:37
/// </summary>
/// <param name="model"></param>
/// <param name="loginUser"></param>
/// <returns></returns>
public static ResultInfoModel SaveNewDepartment(DepartmentSaveModel model, UserLoginInfo loginUser)
{
var result = new ResultInfoModel()
{
IsSuccess = true
};
var flag = CheckDepartment(model.DepartName);
try
{
if (!flag)
{
var entity = new Department()
{
BDParentId = long.Parse(model.ParentId),
BDDeptName = model.DepartName,
BDDeptDescription = model.DepartDesc,
BDIsValid = model.IsValid,
BDCreateUserId = Convert.ToInt32(loginUser.UserId),
BDCreateUserName = loginUser.UserName,
BDCreateTime = DateTime.Now,
BDOperateUserId = Convert.ToInt32(loginUser.UserId),
BDOperateUserName = loginUser.UserName,
BDOperateTime = DateTime.Now
};
var ids = _departmentDal.Insert(entity);
result.Code = EncryptHelper.DesEncrypt(ids.ToString());
}
else
{
result.IsSuccess = false;
result.Message = "已存在相同名称的部门";
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
private void ResultsDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
ResultInfoModel resultModel = ResultsDataGrid.SelectedItem as ResultInfoModel;
if (resultModel == null)
{
return;
}
DetectedItemInfo item = new DetectedItemInfo();
item.Type = resultModel.DetectionLabel;
item.Confidence = resultModel.Confidence;
item.X = resultModel.DetectedBoxLeftTopX;
item.Y = resultModel.DetectedBoxLeftTopY;
item.Width = resultModel.DetectedBoxWidth;
item.Height = resultModel.DetectedBoxHeight;
PreviewImageModel previewModel = PreviewImageModel.Instance;
previewModel.DrawDetectedBoundingBoxOnImage(item);
}
public ActionResult UsrSave(UserView model)
{
var result = new ResultInfoModel();
try
{
if (string.IsNullOrEmpty(model.UserId))
{
//新增
var user = new User();
user.BUSurname = model.BUSurname;
user.BUGivenname = model.BUGivenname;
user.BUJobNumber = model.BUJobNumber;
user.BUSex = model.BUSex;
user.BUAvatars = model.BUAvatars;
user.BUPhoneNum = model.BUPhoneNum;
user.BUEmail = model.BUEmail;
user.BUDepartId = int.Parse(EncryptHelper.DesDecrypt(model.DepartId));
user.BUTitle = model.BUTitle;
user.BUIsValid = model.BUIsValid;
user.BUCreateUserId = int.Parse(LoginUser.UserId.ToString());
user.BUCreateUserName = LoginUser.UserName;
user.BUCreateTime = DateTime.Now;
user.BUOperateUserId = int.Parse(LoginUser.UserId.ToString());
user.BUOperateUserName = LoginUser.UserName;
user.BUOperateTime = DateTime.Now;
result = HomeBusiness.SaveNewUser(user);
}
else
{
//解密id
}
}
catch (Exception ex)
{
}
return(Json(new { }));
}
public static ResultInfoModel InitialData()
{
var result = new ResultInfoModel {
IsSuccess = false
};
using (var con = new SqlConnection(NewSqlHelper.ConnectionString))
{
con.Open();
var tran = con.BeginTransaction();
try
{
var now = DateTime.Now;
var code1 = new CodeModel
{
BCCode = "Assembling",
BCCodeDesc = "Assembling",
BCCategory = "ProblemProcess",
BCCodeOrder = 1,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code1);
var code2 = new CodeModel
{
BCCode = "Molding",
BCCodeDesc = "Molding",
BCCategory = "ProblemProcess",
BCCodeOrder = 2,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code2);
var code3 = new CodeModel
{
BCCode = "Press Molding",
BCCodeDesc = "Press Molding",
BCCategory = "ProblemProcess",
BCCodeOrder = 3,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code3);
var code4 = new CodeModel
{
BCCode = "3D Blow Molding",
BCCodeDesc = "3D Blow Molding",
BCCategory = "ProblemProcess",
BCCodeOrder = 4,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code4);
var code5 = new CodeModel
{
BCCode = "3D Blow Assembling",
BCCodeDesc = "3D Blow Assembling",
BCCategory = "ProblemProcess",
BCCodeOrder = 5,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code5);
var code6 = new CodeModel
{
BCCode = "Foaming",
BCCodeDesc = "Foaming",
BCCategory = "ProblemProcess",
BCCodeOrder = 6,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code6);
var code7 = new CodeModel
{
BCCode = "Other",
BCCodeDesc = "Other",
BCCategory = "ProblemProcess",
BCCodeOrder = 7,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code7);
var code8 = new CodeModel
{
BCCode = "All",
BCCodeDesc = "All",
BCCategory = "ProblemProcess",
BCCodeOrder = 8,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code8);
var code21 = new CodeModel
{
BCCode = "Customer Complaint",
BCCodeDesc = "Customer Complaint",
BCCategory = "ProblemSource",
BCCodeOrder = 1,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code21);
var code22 = new CodeModel
{
BCCode = "Production",
BCCodeDesc = "Production",
BCCategory = "ProblemSource",
BCCodeOrder = 2,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code22);
var code23 = new CodeModel
{
BCCode = "Supplier",
BCCodeDesc = "Supplier",
BCCategory = "ProblemSource",
BCCodeOrder = 3,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code23);
var code24 = new CodeModel
{
BCCode = "Equipment",
BCCodeDesc = "Equipment",
BCCategory = "ProblemSource",
BCCodeOrder = 4,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code24);
var code25 = new CodeModel
{
BCCode = "Tooling",
BCCodeDesc = "Tooling",
BCCategory = "ProblemSource",
BCCodeOrder = 5,
BCIsValid = EnabledEnum.Enabled.GetHashCode(),
BCCreateUserNo = "00000",
BCCreateUserName = "******",
BCCreateTime = now,
BCOperateUserNo = "00000",
BCOperateUserName = "******",
BCOperateTime = now
};
_codeDAL.InsertModel(code25);
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(result);
}
public ActionResult UpLoadFile()
{
var result = new ResultInfoModel()
{
IsSuccess = false
};
StringBuilder strbuild = new StringBuilder();
string FileName;
string savePath;
HttpPostedFileBase file = Request.Files["file"];
if (file == null || file.ContentLength <= 0)
{
result.Message = "please choose file";
return(Content(JsonHelper.JsonSerializer(result)));
}
else
{
string fileName = Path.GetFileName(file.FileName);
int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte
string fileEx = Path.GetExtension(fileName); //获取上传文件的扩展名
string NoFileName = Path.GetFileNameWithoutExtension(fileName); //获取无扩展名的文件名
int Maxsize = 4000 * 1024; //定义上传文件的最大空间大小为4M
string FileType = ".xls,.xlsx"; //定义上传文件的类型字符串
FileName = NoFileName + fileEx;
if (!FileType.Contains(fileEx))
{
result.Message = "please upload .xls and .xlsx";
return(Content(JsonHelper.JsonSerializer(result)));
}
if (filesize >= Maxsize)
{
result.Message = string.Format("file size can't big than {0}", Maxsize);
return(Content(JsonHelper.JsonSerializer(result)));
}
string path = Server.MapPath("~/App_Data/uploads");
savePath = Path.Combine(path, FileName);
file.SaveAs(savePath);
}
string strConn;
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + savePath + ";Extended Properties=Excel 12.0;";
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
try
{
myCommand.Fill(myDataSet, "ExcelInfo");
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();
try
{
var maxJobNumber = string.Empty;
for (int i = 0; i < table.Rows.Count; i++)
{
var model = new UserModel();
model.BUName = table.Rows[i]["ChineseName"].ToString() ?? "";
model.BUSex = 0;
model.BUAvatars = string.Empty;
model.BUPhoneNum = table.Rows[i]["PhoneNum"].ToString() ?? "";
model.BUEmail = table.Rows[i]["Email"].ToString() ?? "";
model.BUDepartId = 0;
model.BUTitle = string.Empty;
model.BUIsValid = EnabledEnum.Enabled.GetHashCode();
model.BUCreateUserNo = LoginUser.JobNum;
model.BUCreateUserName = LoginUser.UserName;
model.BUCreateTime = DateTime.Now;
model.BUOperateUserNo = LoginUser.JobNum;
model.BUOperateUserName = LoginUser.UserName;
model.BUOperateTime = DateTime.Now;
model.BUDepartName = table.Rows[i]["DepartName"].ToString() ?? "";
model.BUExtensionPhone = table.Rows[i]["ExtensionPhone"].ToString() ?? "";
model.BUEnglishName = table.Rows[i]["EnglishName"].ToString() ?? "";
model.BUPosition = table.Rows[i]["Position"].ToString() ?? "";
model.BUMobilePhone = table.Rows[i]["MobilePhone"].ToString() ?? "";
model.Account = table.Rows[i]["Account"].ToString() ?? "";
maxJobNumber = HomeBusiness.GenerateNewJobNumber(maxJobNumber);
model.BUJobNumber = maxJobNumber;
var inserResult = HomeBusiness.SaveNewUser(model);
}
result.IsSuccess = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
conn.Close();
}
return(Content(JsonHelper.JsonSerializer(result)));
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult UsrSave(UserView model)
{
var result = new ResultInfoModel
{
IsSuccess = true
};
try
{
if (string.IsNullOrEmpty(model.UserId) || model.UserId.Equals("0"))
{
//新增
var user = new UserModel();
user.BUName = model.BUName;
user.BUSex = model.BUSex;
if (!string.IsNullOrWhiteSpace(model.BUAvatars))
{
var path = model.BUAvatars.Substring(ServerInfo.RootURI.Length);
user.BUAvatars = path;
}
else
{
user.BUAvatars = string.Empty;
}
user.BUPhoneNum = model.BUPhoneNum;
user.BUEmail = model.BUEmail;
//user.BUDepartId = int.Parse(EncryptHelper.DesDecrypt(model.DepartId));
user.BUTitle = model.BUTitle;
user.BUIsValid = model.BUIsValid;
user.BUCreateUserNo = LoginUser.JobNum;
user.BUCreateUserName = LoginUser.UserName;
user.BUCreateTime = DateTime.Now;
user.BUOperateUserNo = LoginUser.JobNum;;
user.BUOperateUserName = LoginUser.UserName;
user.BUOperateTime = DateTime.Now;
user.BUDepartName = model.BUDepartName;
user.BUExtensionPhone = model.BUExtensionPhone;
user.BUEnglishName = model.BUEnglishName;
user.BUPosition = model.BUPosition;
user.BUMobilePhone = model.BUMobilePhone;
user.BUJobNumber = HomeBusiness.GenerateNewJobNumber(string.Empty);
user.Account = model.Account;
result = HomeBusiness.SaveNewUser(user);
}
else
{
//解密id
model.UserId = EncryptHelper.DesDecrypt(model.UserId);
var user = HomeBusiness.GetUserById(long.Parse(model.UserId));
user.BUName = model.BUName;
user.BUSex = model.BUSex;
user.BUAvatars = model.BUAvatars;
user.BUPhoneNum = model.BUPhoneNum;
user.BUEmail = model.BUEmail;
//user.BUDepartId = int.Parse(EncryptHelper.DesDecrypt(model.DepartId));
user.BUTitle = model.BUTitle;
user.BUIsValid = model.BUIsValid;
user.BUOperateUserNo = LoginUser.JobNum;
user.BUOperateUserName = LoginUser.UserName;
//user.BUOperateUserNo = "33029";
//user.BUOperateUserName = "******";
user.BUOperateTime = DateTime.Now;
user.BUDepartName = model.BUDepartName;
user.BUExtensionPhone = model.BUExtensionPhone;
user.BUEnglishName = model.BUEnglishName;
user.BUPosition = model.BUPosition;
user.BUMobilePhone = model.BUMobilePhone;
user.Account = model.Account;
var isExistAccount = model.IsExistAccount;
result = HomeBusiness.SaveUser(user, isExistAccount);
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(Json(result));
}
/// <summary>
/// Test
/// </summary>
/// <param name="file"></param>
/// <returns></returns>
public ActionResult UploadMaterialFiles()
{
var result = new ResultInfoModel()
{
IsSuccess = false
};
StringBuilder strbuild = new StringBuilder();
string FileName;
string savePath;
HttpPostedFileBase file = Request.Files["file"];
if (file == null || file.ContentLength <= 0)
{
result.Message = "please choose file";
return(Content(JsonHelper.JsonSerializer(result)));
}
else
{
string fileName = Path.GetFileName(file.FileName);
int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte
string fileEx = Path.GetExtension(fileName); //获取上传文件的扩展名
string NoFileName = Path.GetFileNameWithoutExtension(fileName); //获取无扩展名的文件名
int Maxsize = 4000 * 1024; //定义上传文件的最大空间大小为4M
string FileType = ".xls,.xlsx"; //定义上传文件的类型字符串
FileName = NoFileName + fileEx;
if (!FileType.Contains(fileEx))
{
result.Message = "please upload .xls and .xlsx";
return(Content(JsonHelper.JsonSerializer(result)));
}
if (filesize >= Maxsize)
{
result.Message = string.Format("file size can't big than {0}", Maxsize);
return(Content(JsonHelper.JsonSerializer(result)));
}
string path = Server.MapPath("~/App_Data/uploads");
savePath = Path.Combine(path, FileName);
file.SaveAs(savePath);
string strConn;
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + savePath + ";Extended Properties=Excel 12.0;";
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
try
{
myCommand.Fill(myDataSet, "ExcelInfo");
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();
try
{
for (int i = 0; i < table.Rows.Count; i++)
{
MaterialInfoModel model = new MaterialInfoModel();
model.MIProcessType = table.Rows[i][0].ToString();
model.MICustomer = table.Rows[i][1].ToString();
model.MISapPN = table.Rows[i][2].ToString();
model.MIProductName = table.Rows[i][3].ToString();
model.MIInjectionMC = table.Rows[i][4].ToString();
model.MICustomerPN = table.Rows[i][5].ToString();
model.MICavity = DataConvertHelper.ToInt(table.Rows[i][6].ToString(), 0);
model.MICycletime = DataConvertHelper.ToDecimal(table.Rows[i][7].ToString(), 0);
model.MICycletimeCav = DataConvertHelper.ToDecimal(table.Rows[i][8].ToString(), 0);
model.MIStandardHeadcount = DataConvertHelper.ToInt(table.Rows[i][9].ToString(), 0);
model.MTStandardScrap = table.Rows[i][10].ToString();
model.MIMaterialPN = table.Rows[i][11].ToString();
model.MICavityG = DataConvertHelper.ToDecimal(table.Rows[i][12].ToString(), 0);
model.MIMoldNo = table.Rows[i][13].ToString();
model.MIAssAC = table.Rows[i][14].ToString();
model.MIWorkOrder = table.Rows[i][15].ToString();
MaterialBusiness.SaveMaterial(model, this.LoginUser);
var insertResult = MaterialBusiness.SaveMaterial(model, LoginUser);
}
result.IsSuccess = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
conn.Close();
}
return(Content(JsonHelper.JsonSerializer(result)));
}
}
public ActionResult ImportWorkOrder(int type)
{
var result = new ResultInfoModel()
{
IsSuccess = false
};
StringBuilder strbuild = new StringBuilder();
string FileName;
string savePath;
HttpPostedFileBase file = Request.Files["file"];
if (file == null || file.ContentLength <= 0)
{
result.Message = "please choose file";
return(Content(JsonHelper.JsonSerializer(result)));
}
else
{
string fileName = Path.GetFileName(file.FileName);
int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte
string fileEx = Path.GetExtension(fileName); //获取上传文件的扩展名
string NoFileName = Path.GetFileNameWithoutExtension(fileName); //获取无扩展名的文件名
int Maxsize = 4000 * 1024; //定义上传文件的最大空间大小为4M
string FileType = ".xls,.xlsx"; //定义上传文件的类型字符串
FileName = NoFileName + fileEx;
if (!FileType.Contains(fileEx))
{
result.Message = "please upload .xls and .xlsx";
return(Content(JsonHelper.JsonSerializer(result)));
}
if (filesize >= Maxsize)
{
result.Message = string.Format("file size can't big than {0}", Maxsize);
return(Content(JsonHelper.JsonSerializer(result)));
}
string path = Server.MapPath("~/App_Data/uploads");
savePath = Path.Combine(path, FileName);
file.SaveAs(savePath);
string strConn;
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + savePath + ";Extended Properties=Excel 12.0;";
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
try
{
myCommand.Fill(myDataSet, "ExcelInfo");
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();
try
{
for (int i = 0; i < table.Rows.Count; i++)
{
WorkOrderInfo model = new WorkOrderInfo();
model.WIWorkOrder = table.Rows[i][0].ToString();
model.WISapPN = table.Rows[i][1].ToString();
model.WIProductName = table.Rows[i][2].ToString();
model.WIReceiptTime = table.Rows[i][3].ToString();
model.WIReceiptBy = table.Rows[i][4].ToString();
model.WICloseDateShift = table.Rows[i][5].ToString();
model.WIOrderArchived = table.Rows[i][6].ToString();
model.WIParameterRecord = table.Rows[i][7].ToString();
model.WIToolMaintenanceRecord = table.Rows[i][8].ToString();
model.WIToolMachineCheck = table.Rows[i][9].ToString();
model.WIQuantityConfirm = table.Rows[i][10].ToString();
model.WIArchivedBy = table.Rows[i][11].ToString();
model.WIWeeklyCheck = table.Rows[i][12].ToString();
model.WIRemarks = table.Rows[i][7].ToString();
model.WIGetBy = table.Rows[i][8].ToString();
model.WIGetTime = table.Rows[i][9].ToString();
model.WIType = type;
MaterialBusiness.SaveWorkOrder(model, this.LoginUser);
}
result.IsSuccess = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
conn.Close();
}
return(Content(JsonHelper.JsonSerializer(result)));
}
}
public ActionResult UploadDefectCodeFiles()
{
var result = new ResultInfoModel()
{
IsSuccess = false
};
StringBuilder strbuild = new StringBuilder();
string FileName;
string savePath;
HttpPostedFileBase file = Request.Files["file"];
if (file == null || file.ContentLength <= 0)
{
result.Message = "please choose file";
return(Content(JsonHelper.JsonSerializer(result)));
}
else
{
string fileName = Path.GetFileName(file.FileName);
int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte
string fileEx = Path.GetExtension(fileName); //获取上传文件的扩展名
string NoFileName = Path.GetFileNameWithoutExtension(fileName); //获取无扩展名的文件名
int Maxsize = 5000 * 1024; //定义上传文件的最大空间大小为4M
string FileType = ".xls,.xlsx"; //定义上传文件的类型字符串
FileName = NoFileName + fileEx;
if (!FileType.Contains(fileEx))
{
result.Message = "please upload .xls and .xlsx";
return(Content(JsonHelper.JsonSerializer(result)));
}
if (filesize >= Maxsize)
{
result.Message = string.Format("file size can't big than {0}", Maxsize);
return(Content(JsonHelper.JsonSerializer(result)));
}
string path = Server.MapPath("~/App_Data/uploads");
savePath = Path.Combine(path, FileName);
file.SaveAs(savePath);
string strConn;
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + savePath + ";Extended Properties=Excel 12.0;";
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
try
{
myCommand.Fill(myDataSet, "ExcelInfo");
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();
var importResult = new Importresult();
importResult.FalseInfo = new List <FalseInfo>();
try
{
for (int i = 0; i < table.Rows.Count; i++)
{
CodeDefectModel model = new CodeDefectModel();
model.BDCodeType = table.Rows[i][0].ToString();
model.BDCodeNo = DataConvertHelper.ToInt(table.Rows[i][1].ToString(), 0);
model.BDCode = table.Rows[i][2].ToString();
model.BDCodeNameEn = table.Rows[i][3].ToString();
model.BDCodeNameCn = table.Rows[i][4].ToString();
var inserResult = CodeBusiness.SaveDefectCode(model, this.LoginUser);
}
result.IsSuccess = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
conn.Close();
}
}
return(Content(JsonHelper.JsonSerializer(result)));
}