/// <summary>
/// 修改部门（确定按钮）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ImageButton2_Click(object sender, EventArgs e)
{
try
{
if (TextBox4.Text.Trim() != "")
{
Maticsoft.Model.Department bumen = dep.GetModel(Convert.ToInt32(Label1.Text));
bumen.departmentname = TextBox4.Text.Trim();
bumen.Beizhu = TextBox5.Text.Trim();
bool a = dep.Update(bumen);
if (a == true)
{
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:showDiv2();</script>");
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('职务名称不能为空！');</script>");
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>javascript:showDiv2();</script>");
}
}
catch (Exception ee)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('确定异常 " + ee.Message + "');</script>");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Department DataRowToModel(DataRow row)
{
Maticsoft.Model.Department model = new Maticsoft.Model.Department();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["Levels"] != null && row["Levels"].ToString() != "")
{
model.Levels = int.Parse(row["Levels"].ToString());
}
if (row["IsActive"] != null && row["IsActive"].ToString() != "")
{
model.IsActive = int.Parse(row["IsActive"].ToString());
}
if (row["Display"] != null && row["Display"].ToString() != "")
{
model.Display = int.Parse(row["Display"].ToString());
}
if (row["PreID"] != null && row["PreID"].ToString() != "")
{
model.PreID = int.Parse(row["PreID"].ToString());
}
if (row["CpId"] != null && row["CpId"].ToString() != "")
{
model.CpId = int.Parse(row["CpId"].ToString());
}
if (row["DStatus"] != null)
{
model.DStatus = row["DStatus"].ToString();
}
if (row["DOrder"] != null && row["DOrder"].ToString() != "")
{
model.DOrder = decimal.Parse(row["DOrder"].ToString());
}
if (row["CreateDate"] != null && row["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(row["CreateDate"].ToString());
}
if (row["CreateUser"] != null)
{
model.CreateUser = row["CreateUser"].ToString();
}
if (row["ParentId"] != null && row["ParentId"].ToString() != "")
{
model.ParentId = int.Parse(row["ParentId"].ToString());
}
if (row["UcDepartmentId"] != null && row["UcDepartmentId"].ToString() != "")
{
model.UcDepartmentId = int.Parse(row["UcDepartmentId"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Department set ");
strSql.Append("Name=@Name,");
strSql.Append("Levels=@Levels,");
strSql.Append("IsActive=@IsActive,");
strSql.Append("Display=@Display,");
strSql.Append("PreID=@PreID,");
strSql.Append("CpId=@CpId,");
strSql.Append("DStatus=@DStatus,");
strSql.Append("DOrder=@DOrder,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("CreateUser=@CreateUser,");
strSql.Append("ParentId=@ParentId,");
strSql.Append("UcDepartmentId=@UcDepartmentId");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Levels", SqlDbType.Int, 4),
new SqlParameter("@IsActive", SqlDbType.Int, 4),
new SqlParameter("@Display", SqlDbType.Int, 4),
new SqlParameter("@PreID", SqlDbType.Int, 4),
new SqlParameter("@CpId", SqlDbType.Int, 4),
new SqlParameter("@DStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@DOrder", SqlDbType.Float, 8),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.NVarChar, 100),
new SqlParameter("@ParentId", SqlDbType.Int, 4),
new SqlParameter("@UcDepartmentId", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Levels;
parameters[2].Value = model.IsActive;
parameters[3].Value = model.Display;
parameters[4].Value = model.PreID;
parameters[5].Value = model.CpId;
parameters[6].Value = model.DStatus;
parameters[7].Value = model.DOrder;
parameters[8].Value = model.CreateDate;
parameters[9].Value = model.CreateUser;
parameters[10].Value = model.ParentId;
parameters[11].Value = model.UcDepartmentId;
parameters[12].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Department set ");
strSql.Append("DepartmentID=@DepartmentID,");
strSql.Append("DepartmentNo=@DepartmentNo,");
strSql.Append("DepartmentName=@DepartmentName,");
strSql.Append("DepartmentRemark=@DepartmentRemark,");
strSql.Append("Remark=@Remark,");
strSql.Append("CreatedDate=@CreatedDate,");
strSql.Append("CreatedGuy=@CreatedGuy,");
strSql.Append("UpdatedDate=@UpdatedDate,");
strSql.Append("Status=@Status,");
strSql.Append("CheckDate=@CheckDate,");
strSql.Append("DepartmentGroup=@DepartmentGroup");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@DepartmentID", SqlDbType.Int, 4),
new SqlParameter("@DepartmentNo", SqlDbType.NVarChar, 50),
new SqlParameter("@DepartmentName", SqlDbType.NVarChar, 255),
new SqlParameter("@DepartmentRemark", SqlDbType.Text),
new SqlParameter("@Remark", SqlDbType.NText),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@CreatedGuy", SqlDbType.Int, 4),
new SqlParameter("@UpdatedDate", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CheckDate", SqlDbType.DateTime),
new SqlParameter("@DepartmentGroup", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.DepartmentID;
parameters[1].Value = model.DepartmentNo;
parameters[2].Value = model.DepartmentName;
parameters[3].Value = model.DepartmentRemark;
parameters[4].Value = model.Remark;
parameters[5].Value = model.CreatedDate;
parameters[6].Value = model.CreatedGuy;
parameters[7].Value = model.UpdatedDate;
parameters[8].Value = model.Status;
parameters[9].Value = model.CheckDate;
parameters[10].Value = model.DepartmentGroup;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Department DataRowToModel(DataRow row)
{
Maticsoft.Model.Department model = new Maticsoft.Model.Department();
if (row != null)
{
if (row["DepartmentID"] != null && row["DepartmentID"].ToString() != "")
{
model.DepartmentID = int.Parse(row["DepartmentID"].ToString());
}
if (row["DepartmentNo"] != null)
{
model.DepartmentNo = row["DepartmentNo"].ToString();
}
if (row["DepartmentName"] != null)
{
model.DepartmentName = row["DepartmentName"].ToString();
}
if (row["DepartmentRemark"] != null)
{
model.DepartmentRemark = row["DepartmentRemark"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["CreatedDate"] != null && row["CreatedDate"].ToString() != "")
{
model.CreatedDate = DateTime.Parse(row["CreatedDate"].ToString());
}
if (row["CreatedGuy"] != null && row["CreatedGuy"].ToString() != "")
{
model.CreatedGuy = int.Parse(row["CreatedGuy"].ToString());
}
if (row["UpdatedDate"] != null && row["UpdatedDate"].ToString() != "")
{
model.UpdatedDate = DateTime.Parse(row["UpdatedDate"].ToString());
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["CheckDate"] != null && row["CheckDate"].ToString() != "")
{
model.CheckDate = DateTime.Parse(row["CheckDate"].ToString());
}
if (row["DepartmentGroup"] != null)
{
model.DepartmentGroup = row["DepartmentGroup"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Department set ");
strSql.Append("departmentname=@departmentname,");
strSql.Append("Beizhu=@Beizhu,");
strSql.Append("BY1=@BY1,");
strSql.Append("BY2=@BY2,");
strSql.Append("BY3=@BY3,");
strSql.Append("BY4=@BY4,");
strSql.Append("BY5=@BY5,");
strSql.Append("BY6=@BY6,");
strSql.Append("BY7=@BY7");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@departmentname", SqlDbType.VarChar, 100),
new SqlParameter("@Beizhu", SqlDbType.VarChar, 4000),
new SqlParameter("@BY1", SqlDbType.Decimal, 9),
new SqlParameter("@BY2", SqlDbType.Decimal, 9),
new SqlParameter("@BY3", SqlDbType.Decimal, 9),
new SqlParameter("@BY4", SqlDbType.VarChar, 4000),
new SqlParameter("@BY5", SqlDbType.VarChar, 4000),
new SqlParameter("@BY6", SqlDbType.VarChar, 4000),
new SqlParameter("@BY7", SqlDbType.VarChar, 4000),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.departmentname;
parameters[1].Value = model.Beizhu;
parameters[2].Value = model.BY1;
parameters[3].Value = model.BY2;
parameters[4].Value = model.BY3;
parameters[5].Value = model.BY4;
parameters[6].Value = model.BY5;
parameters[7].Value = model.BY6;
parameters[8].Value = model.BY7;
parameters[9].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(int id)
{
Maticsoft.BLL.Department bll = new Maticsoft.BLL.Department();
Maticsoft.Model.Department model = bll.GetModel(id);
this.lblid.Text = model.id.ToString();
this.lbldepartmentname.Text = model.departmentname;
this.lblBeizhu.Text = model.Beizhu;
this.lblBY1.Text = model.BY1.ToString();
this.lblBY2.Text = model.BY2.ToString();
this.lblBY3.Text = model.BY3.ToString();
this.lblBY4.Text = model.BY4;
this.lblBY5.Text = model.BY5;
this.lblBY6.Text = model.BY6;
this.lblBY7.Text = model.BY7;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Department DataRowToModel(DataRow row)
{
Maticsoft.Model.Department model = new Maticsoft.Model.Department();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["departmentname"] != null)
{
model.departmentname = row["departmentname"].ToString();
}
if (row["Beizhu"] != null)
{
model.Beizhu = row["Beizhu"].ToString();
}
if (row["BY1"] != null && row["BY1"].ToString() != "")
{
model.BY1 = decimal.Parse(row["BY1"].ToString());
}
if (row["BY2"] != null && row["BY2"].ToString() != "")
{
model.BY2 = decimal.Parse(row["BY2"].ToString());
}
if (row["BY3"] != null && row["BY3"].ToString() != "")
{
model.BY3 = decimal.Parse(row["BY3"].ToString());
}
if (row["BY4"] != null)
{
model.BY4 = row["BY4"].ToString();
}
if (row["BY5"] != null)
{
model.BY5 = row["BY5"].ToString();
}
if (row["BY6"] != null)
{
model.BY6 = row["BY6"].ToString();
}
if (row["BY7"] != null)
{
model.BY7 = row["BY7"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Department(");
strSql.Append("Name,Levels,IsActive,Display,PreID,CpId,DStatus,DOrder,CreateDate,CreateUser,ParentId,UcDepartmentId)");
strSql.Append(" values (");
strSql.Append("@Name,@Levels,@IsActive,@Display,@PreID,@CpId,@DStatus,@DOrder,@CreateDate,@CreateUser,@ParentId,@UcDepartmentId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Levels", SqlDbType.Int, 4),
new SqlParameter("@IsActive", SqlDbType.Int, 4),
new SqlParameter("@Display", SqlDbType.Int, 4),
new SqlParameter("@PreID", SqlDbType.Int, 4),
new SqlParameter("@CpId", SqlDbType.Int, 4),
new SqlParameter("@DStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@DOrder", SqlDbType.Float, 8),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.NVarChar, 100),
new SqlParameter("@ParentId", SqlDbType.Int, 4),
new SqlParameter("@UcDepartmentId", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Levels;
parameters[2].Value = model.IsActive;
parameters[3].Value = model.Display;
parameters[4].Value = model.PreID;
parameters[5].Value = model.CpId;
parameters[6].Value = model.DStatus;
parameters[7].Value = model.DOrder;
parameters[8].Value = model.CreateDate;
parameters[9].Value = model.CreateUser;
parameters[10].Value = model.ParentId;
parameters[11].Value = model.UcDepartmentId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Department(");
strSql.Append("DepartmentID,DepartmentNo,DepartmentName,DepartmentRemark,Remark,CreatedDate,CreatedGuy,UpdatedDate,Status,CheckDate,DepartmentGroup)");
strSql.Append(" values (");
strSql.Append("@DepartmentID,@DepartmentNo,@DepartmentName,@DepartmentRemark,@Remark,@CreatedDate,@CreatedGuy,@UpdatedDate,@Status,@CheckDate,@DepartmentGroup)");
SqlParameter[] parameters =
{
new SqlParameter("@DepartmentID", SqlDbType.Int, 4),
new SqlParameter("@DepartmentNo", SqlDbType.NVarChar, 50),
new SqlParameter("@DepartmentName", SqlDbType.NVarChar, 255),
new SqlParameter("@DepartmentRemark", SqlDbType.Text),
new SqlParameter("@Remark", SqlDbType.NText),
new SqlParameter("@CreatedDate", SqlDbType.DateTime),
new SqlParameter("@CreatedGuy", SqlDbType.Int, 4),
new SqlParameter("@UpdatedDate", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CheckDate", SqlDbType.DateTime),
new SqlParameter("@DepartmentGroup", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.DepartmentID;
parameters[1].Value = model.DepartmentNo;
parameters[2].Value = model.DepartmentName;
parameters[3].Value = model.DepartmentRemark;
parameters[4].Value = model.Remark;
parameters[5].Value = model.CreatedDate;
parameters[6].Value = model.CreatedGuy;
parameters[7].Value = model.UpdatedDate;
parameters[8].Value = model.Status;
parameters[9].Value = model.CheckDate;
parameters[10].Value = model.DepartmentGroup;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Department(");
strSql.Append("departmentname,Beizhu,BY1,BY2,BY3,BY4,BY5,BY6,BY7)");
strSql.Append(" values (");
strSql.Append("@departmentname,@Beizhu,@BY1,@BY2,@BY3,@BY4,@BY5,@BY6,@BY7)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@departmentname", SqlDbType.VarChar, 100),
new SqlParameter("@Beizhu", SqlDbType.VarChar, 4000),
new SqlParameter("@BY1", SqlDbType.Decimal, 9),
new SqlParameter("@BY2", SqlDbType.Decimal, 9),
new SqlParameter("@BY3", SqlDbType.Decimal, 9),
new SqlParameter("@BY4", SqlDbType.VarChar, 4000),
new SqlParameter("@BY5", SqlDbType.VarChar, 4000),
new SqlParameter("@BY6", SqlDbType.VarChar, 4000),
new SqlParameter("@BY7", SqlDbType.VarChar, 4000)
};
parameters[0].Value = model.departmentname;
parameters[1].Value = model.Beizhu;
parameters[2].Value = model.BY1;
parameters[3].Value = model.BY2;
parameters[4].Value = model.BY3;
parameters[5].Value = model.BY4;
parameters[6].Value = model.BY5;
parameters[7].Value = model.BY6;
parameters[8].Value = model.BY7;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Department GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 DepartmentID,DepartmentNo,DepartmentName,DepartmentRemark,Remark,CreatedDate,CreatedGuy,UpdatedDate,Status,CheckDate,DepartmentGroup from Department ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Maticsoft.Model.Department model = new Maticsoft.Model.Department();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Department GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,Levels,IsActive,Display,PreID,CpId,DStatus,DOrder,CreateDate,CreateUser,ParentId,UcDepartmentId from Department ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.Department model = new Maticsoft.Model.Department();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Department GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,departmentname,Beizhu,BY1,BY2,BY3,BY4,BY5,BY6,BY7 from Department ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Maticsoft.Model.Department model = new Maticsoft.Model.Department();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <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"));
}
}
public 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;
}
int id = int.Parse(this.lblid.Text);
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.id = id;
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.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.Department model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.Department model)
{
return(dal.Update(model));
}
