/// <summary>
/// 添加部门（确定按钮）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ImageButton1_Click(object sender, EventArgs e)
{
try
{
if (TextBox1.Text.Trim() != "")
{
Maticsoft.Model.Department bumen = new Model.Department();
bumen.departmentname = TextBox1.Text.Trim();
bumen.Beizhu = TextBox2.Text.Trim();
int a = dep.Add(bumen);
if (a > 0)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('添加成功！');</script>");
bind(sql);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('添加失败！');</script>");
bind(sql);
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('部门名称不能为空！');</script>");
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>javascript:showDiv1();</script>");
}
}
catch (Exception ee)
{
//Response.Write("<script>alert('确定异常 " + ee.Message + "')</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('确定异常 " + ee.Message + "');</script>");
}
}
/// <summary>
/// 用户中心登陆
/// </summary>
/// <returns></returns>
public ActionResult UserCenterLogin()
{
ConfigurationHelper config = new ConfigurationHelper();
string WebUrl = config.getConfigName("WebUrl");
string token = Request.QueryString["token"]?.ToString();
DataTable dt = null;
if (!string.IsNullOrEmpty(token))
{
token = HttpUtility.UrlEncode(token, System.Text.Encoding.UTF8);
token = Setpassword.get_password_ASC(HttpUtility.UrlDecode(token));
dt = JsonConvert.DeserializeObject(token, typeof(DataTable)) as DataTable;
}
if (dt != null && dt.Rows.Count > 0)//表示token能解析出对象
{
DateTime time = Convert.ToDateTime(dt.Rows[0]["CreateDate"]);
if (time.Date == DateTime.Now.Date)
{
DataTable userTable = BUserInfo.GetList("UrGuid='" + dt.Rows[0]["UserGuid"].ToString() + "'").Tables[0];
//处理dt
if (userTable.Rows.Count > 0)//如果存在这个guid 表示用户存在
{
//存在还要判断数据是否有被修改
int companyId = Convert.ToInt32(dt.Rows[0]["CompanyID"]);
string companyName = dt.Rows[0]["CompanyName"].ToString();
//先开始判断公司
MCompany = BCompany.GetModel(companyId);
if (MCompany == null)
{
//创建公司
MCompany = new Maticsoft.Model.Company()
{
Id = companyId, Name = companyName
};
BCompany.Add(MCompany);
}
else//表示存在公司
{
if (MCompany.Name != companyName)//表示数据更改
{
string sql = "update company set Name=@Name where Id=@Id";
SqlParameter[] paras =
{
new SqlParameter("@Name", companyName),
new SqlParameter("@Id", companyId)
};
DbHelperSQL.ExecuteSql(sql, paras);
}
}
int departmentId = Convert.ToInt32(dt.Rows[0]["DepartmentID"]);
int newDepartmentId = 0;
string departmentName = dt.Rows[0]["DepartmentName"].ToString();
DataTable departmentTable = BDepartment.GetList("UcDepartmentId = " + departmentId).Tables[0];
if (departmentTable.Rows.Count > 0)//表示已经存在部门
{
newDepartmentId = Convert.ToInt32(departmentTable.Rows[0]["ID"]);
if (departmentTable.Rows[0]["Name"].ToString() != departmentName || departmentTable.Rows[0]["CpId"].ToString() != companyId.ToString())//表示部门名称更改，更新部门名称
{
string sql = "update Department set UcDepartmentId=@UcDepartmentId,Name=@Name,CpId=@CpId where Id=@Id";
SqlParameter[] paras =
{
new SqlParameter("@UcDepartmentId", departmentId),
new SqlParameter("@CpId", companyId),
new SqlParameter("@Name", departmentName),
new SqlParameter("@Id", newDepartmentId)
};
DbHelperSQL.ExecuteSql(sql, paras);
}
}
else
{
//不存在部门，新增
MDepartment = new Maticsoft.Model.Department()
{
CpId = companyId, UcDepartmentId = departmentId, Name = departmentName
};
newDepartmentId = BDepartment.Add(MDepartment);
}
//处理用户
if (userTable.Rows[0]["UserName"].ToString() != dt.Rows[0]["UserPhone"].ToString() || dt.Rows[0]["UserName"].ToString() != userTable.Rows[0]["TrueName"].ToString() || Convert.ToInt32(userTable.Rows[0]["DepartmentId"]) != newDepartmentId || userTable.Rows[0]["HeadImage"].ToString() != dt.Rows[0]["UserHeadImage"].ToString())
{
//表示用户信息有被更改
string sql = "update Userinfo set UserName=@UserName,TrueName=@TrueName,DepartmentId=@DepartmentId,HeadImage=@HeadImage where Id=@Id";
SqlParameter[] paras =
{
new SqlParameter("@UserName", dt.Rows[0]["UserPhone"].ToString()),
new SqlParameter("@TrueName", dt.Rows[0]["UserName"].ToString()),
new SqlParameter("@HeadImage", dt.Rows[0]["UserHeadImage"].ToString()),
new SqlParameter("@DepartmentId", newDepartmentId),
new SqlParameter("@Id", Convert.ToInt32(userTable.Rows[0]["ID"]))
};
DbHelperSQL.ExecuteSql(sql, paras);
}
string name = userTable.Rows[0]["TrueName"].ToString();
string ID = userTable.Rows[0]["ID"].ToString();
string RoleID = userTable.Rows[0]["RoleID"].ToString();
Session.Add("UserInfoID", ID);
Session.Add("TrueName", name);
Session.Add("RoleID", RoleID);
Session.Timeout = 40;
return(RedirectToAction("Index", "Window"));
//string ID = userTable.Rows[0]["ID"].ToString();
//Session.Add("UserInfoID", ID);
//Session.Add("RoleID", 3);//默认都是反馈人员
//Session.Add("TrueName", MUserInfo.TrueName);
//Session.Timeout = 40;
//return RedirectToAction("Index", "Window");
}
else //表示不存在这个用户
{
int companyId = Convert.ToInt32(dt.Rows[0]["CompanyID"]);
string companyName = dt.Rows[0]["CompanyName"].ToString();
//先开始判断公司
MCompany = BCompany.GetModel(companyId);
if (MCompany == null)
{
//创建公司
MCompany = new Maticsoft.Model.Company()
{
Id = companyId, Name = companyName
};
BCompany.Add(MCompany);
}
else//表示存在公司
{
if (MCompany.Name != companyName)//表示数据更改
{
string sql = "update company set Name=@Name where Id=@Id";
SqlParameter[] paras =
{
new SqlParameter("@Name", companyName),
new SqlParameter("@Id", companyId)
};
DbHelperSQL.ExecuteSql(sql, paras);
}
}
int departmentId = Convert.ToInt32(dt.Rows[0]["DepartmentID"]);
int newDepartmentId = 0;
string departmentName = dt.Rows[0]["DepartmentName"].ToString();
DataTable departmentTable = BDepartment.GetList("UcDepartmentId = " + departmentId).Tables[0];
if (departmentTable.Rows.Count > 0)//表示已经存在部门
{
newDepartmentId = Convert.ToInt32(departmentTable.Rows[0]["ID"]);
if (departmentTable.Rows[0]["Name"].ToString() != departmentName || departmentTable.Rows[0]["CpId"].ToString() != companyId.ToString())//表示部门名称更改，更新部门名称
{
string sql = "update Department set UcDepartmentId=@UcDepartmentId,Name=@Name,CpId=@CpId where Id=@Id";
SqlParameter[] paras =
{
new SqlParameter("@UcDepartmentId", departmentId),
new SqlParameter("@Name", departmentName),
new SqlParameter("@CpId", companyId),
new SqlParameter("@Id", newDepartmentId)
};
DbHelperSQL.ExecuteSql(sql, paras);
}
}
else
{
//不存在部门，新增
MDepartment = new Maticsoft.Model.Department()
{
CpId = companyId, UcDepartmentId = departmentId, Name = departmentName
};
newDepartmentId = BDepartment.Add(MDepartment);
}
//创建用户
MUserInfo.ParentID = 1; //默认上级是超级管理员
MUserInfo.Password = ""; // password.set_password_ASC("888888");
MUserInfo.PrivilegeID = "17"; //默认权限
MUserInfo.RoleID = 3;
MUserInfo.status = Convert.ToInt32(1);
MUserInfo.Time = System.DateTime.Now;
MUserInfo.UserFrom = "ERP-User";
MUserInfo.DepartmentID = newDepartmentId;
MUserInfo.TrueName = dt.Rows[0]["UserName"].ToString(); //用户真实姓名
MUserInfo.UserName = dt.Rows[0]["UserPhone"].ToString(); //用户昵称，就是手机号
MUserInfo.UrGuid = dt.Rows[0]["UserGuid"].ToString();
MUserInfo.HeadImage = dt.Rows[0]["UserHeadImage"].ToString();
int check = BUserInfo.Add(MUserInfo);
if (check > 0)
{
Session.Add("UserInfoID", check);
Session.Add("RoleID", 3);//默认都是反馈人员
Session.Add("TrueName", MUserInfo.TrueName);
Session.Timeout = 40;
return(RedirectToAction("Index", "Window"));
}
else
{
return(RedirectToAction("Login", "Window"));
}
}
}
else
{
return(RedirectToAction("Login", "Window"));
}
}
else
{
return(RedirectToAction("Login", "Window"));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtdepartmentname.Text.Trim().Length == 0)
{
strErr += "departmentname不能为空！\\n";
}
if (this.txtBeizhu.Text.Trim().Length == 0)
{
strErr += "Beizhu不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtBY1.Text))
{
strErr += "BY1格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtBY2.Text))
{
strErr += "BY2格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtBY3.Text))
{
strErr += "BY3格式错误！\\n";
}
if (this.txtBY4.Text.Trim().Length == 0)
{
strErr += "BY4不能为空！\\n";
}
if (this.txtBY5.Text.Trim().Length == 0)
{
strErr += "BY5不能为空！\\n";
}
if (this.txtBY6.Text.Trim().Length == 0)
{
strErr += "BY6不能为空！\\n";
}
if (this.txtBY7.Text.Trim().Length == 0)
{
strErr += "BY7不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string departmentname = this.txtdepartmentname.Text;
string Beizhu = this.txtBeizhu.Text;
decimal BY1 = decimal.Parse(this.txtBY1.Text);
decimal BY2 = decimal.Parse(this.txtBY2.Text);
decimal BY3 = decimal.Parse(this.txtBY3.Text);
string BY4 = this.txtBY4.Text;
string BY5 = this.txtBY5.Text;
string BY6 = this.txtBY6.Text;
string BY7 = this.txtBY7.Text;
Maticsoft.Model.Department model = new Maticsoft.Model.Department();
model.departmentname = departmentname;
model.Beizhu = Beizhu;
model.BY1 = BY1;
model.BY2 = BY2;
model.BY3 = BY3;
model.BY4 = BY4;
model.BY5 = BY5;
model.BY6 = BY6;
model.BY7 = BY7;
Maticsoft.BLL.Department bll = new Maticsoft.BLL.Department();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
