/// <summary>
/// 初始化窗体
/// </summary>
private void InitForm()
{
ServerUtil.BindDropDLTDept(this.f_DepartIDComboBox);
ServerUtil.BindDropDLTRoles(this.f_RoleIDComboBox);
if (_id != 0)
{
this.Text = "用户修改";
label1.Visible = true;
label2.Visible = true;
f_RegTimeLabel1.Visible = true;
f_LastInTimeLabel1.Visible = true;
GSSBLL.Users bll = new GSSBLL.Users();
GSSModel.Users model = bll.GetModel(_id);
f_UserIDTextBox.Text = model.F_UserID.ToString();
f_UserNameTextBox.Text = model.F_UserName;
//f_PassWordTextBox.Text=model.F_PassWord ;
textBoxPSWH.Text = model.F_PassWord;
f_DepartIDComboBox.SelectedValue = model.F_DepartID;
f_RoleIDComboBox.SelectedValue = model.F_RoleID;
f_RealNameTextBox.Text = model.F_RealName;
SexradioButton1.Checked = model.F_Sex == false ? false : true;
SexradioButton2.Checked = !SexradioButton1.Checked;
f_BirthdayDateTimePicker.Text = model.F_Birthday.ToString();
f_EmailTextBox.Text = model.F_Email;
f_MobilePhoneTextBox.Text = model.F_MobilePhone;
f_TelphoneTextBox.Text = model.F_Telphone;
f_NoteTextBox.Text = model.F_Note;
f_IsUsedCheckBox.Checked = model.F_IsUsed;
f_RegTimeLabel1.Text = model.F_RegTime.ToString();
f_LastInTimeLabel1.Text = model.F_LastInTime.ToString();
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(GSSModel.Users model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Users(");
strSql.Append("F_UserName,F_PassWord,F_DepartID,F_RoleID,F_RealName,F_Sex,F_Birthday,F_Email,F_MobilePhone,F_Telphone,F_Note,F_RegTime,F_LastInTime,F_IsUsed)");
strSql.Append(" values (");
strSql.Append("@F_UserName,@F_PassWord,@F_DepartID,@F_RoleID,@F_RealName,@F_Sex,@F_Birthday,@F_Email,@F_MobilePhone,@F_Telphone,@F_Note,@F_RegTime,@F_LastInTime,@F_IsUsed)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@F_UserName", SqlDbType.NVarChar, 30),
new SqlParameter("@F_PassWord", SqlDbType.Char, 32),
new SqlParameter("@F_DepartID", SqlDbType.Int, 4),
new SqlParameter("@F_RoleID", SqlDbType.Int, 4),
new SqlParameter("@F_RealName", SqlDbType.NVarChar, 10),
new SqlParameter("@F_Sex", SqlDbType.Bit, 1),
new SqlParameter("@F_Birthday", SqlDbType.SmallDateTime),
new SqlParameter("@F_Email", SqlDbType.NVarChar, 50),
new SqlParameter("@F_MobilePhone", SqlDbType.NVarChar, 20),
new SqlParameter("@F_Telphone", SqlDbType.NVarChar, 20),
new SqlParameter("@F_Note", SqlDbType.NVarChar, 500),
new SqlParameter("@F_RegTime", SqlDbType.SmallDateTime),
new SqlParameter("@F_LastInTime", SqlDbType.SmallDateTime),
new SqlParameter("@F_IsUsed", SqlDbType.Bit, 1)
};
parameters[0].Value = model.F_UserName;
parameters[1].Value = model.F_PassWord;
parameters[2].Value = model.F_DepartID;
parameters[3].Value = model.F_RoleID;
parameters[4].Value = model.F_RealName;
parameters[5].Value = model.F_Sex;
parameters[6].Value = model.F_Birthday;
parameters[7].Value = model.F_Email;
parameters[8].Value = model.F_MobilePhone;
parameters[9].Value = model.F_Telphone;
parameters[10].Value = model.F_Note;
parameters[11].Value = model.F_RegTime;
parameters[12].Value = model.F_LastInTime;
parameters[13].Value = model.F_IsUsed;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(GSSModel.Users model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Users set ");
strSql.Append("F_UserName=@F_UserName,");
strSql.Append("F_PassWord=@F_PassWord,");
strSql.Append("F_DepartID=@F_DepartID,");
strSql.Append("F_RoleID=@F_RoleID,");
strSql.Append("F_RealName=@F_RealName,");
strSql.Append("F_Sex=@F_Sex,");
strSql.Append("F_Birthday=@F_Birthday,");
strSql.Append("F_Email=@F_Email,");
strSql.Append("F_MobilePhone=@F_MobilePhone,");
strSql.Append("F_Telphone=@F_Telphone,");
strSql.Append("F_Note=@F_Note,");
strSql.Append("F_RegTime=@F_RegTime,");
strSql.Append("F_LastInTime=@F_LastInTime,");
strSql.Append("F_IsUsed=@F_IsUsed");
strSql.Append(" where F_UserID=@F_UserID");
SqlParameter[] parameters =
{
new SqlParameter("@F_UserName", SqlDbType.NVarChar, 30),
new SqlParameter("@F_PassWord", SqlDbType.Char, 32),
new SqlParameter("@F_DepartID", SqlDbType.Int, 4),
new SqlParameter("@F_RoleID", SqlDbType.Int, 4),
new SqlParameter("@F_RealName", SqlDbType.NVarChar, 10),
new SqlParameter("@F_Sex", SqlDbType.Bit, 1),
new SqlParameter("@F_Birthday", SqlDbType.SmallDateTime),
new SqlParameter("@F_Email", SqlDbType.NVarChar, 50),
new SqlParameter("@F_MobilePhone", SqlDbType.NVarChar, 20),
new SqlParameter("@F_Telphone", SqlDbType.NVarChar, 20),
new SqlParameter("@F_Note", SqlDbType.NVarChar, 500),
new SqlParameter("@F_RegTime", SqlDbType.SmallDateTime),
new SqlParameter("@F_LastInTime", SqlDbType.SmallDateTime),
new SqlParameter("@F_IsUsed", SqlDbType.Bit, 1),
new SqlParameter("@F_UserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.F_UserName;
parameters[1].Value = model.F_PassWord;
parameters[2].Value = model.F_DepartID;
parameters[3].Value = model.F_RoleID;
parameters[4].Value = model.F_RealName;
parameters[5].Value = model.F_Sex;
parameters[6].Value = model.F_Birthday;
parameters[7].Value = model.F_Email;
parameters[8].Value = model.F_MobilePhone;
parameters[9].Value = model.F_Telphone;
parameters[10].Value = model.F_Note;
parameters[11].Value = model.F_RegTime;
parameters[12].Value = model.F_LastInTime;
parameters[13].Value = model.F_IsUsed;
parameters[14].Value = model.F_UserID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public GSSModel.Users GetModel(int F_UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 F_UserID,F_UserName,F_PassWord,F_DepartID,F_RoleID,F_RealName,F_Sex,F_Birthday,F_Email,F_MobilePhone,F_Telphone,F_Note,F_RegTime,F_LastInTime,F_IsUsed from T_Users ");
strSql.Append(" where F_UserID=@F_UserID");
SqlParameter[] parameters =
{
new SqlParameter("@F_UserID", SqlDbType.Int, 4)
};
parameters[0].Value = F_UserID;
GSSModel.Users model = new GSSModel.Users();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["F_UserID"].ToString() != "")
{
model.F_UserID = int.Parse(ds.Tables[0].Rows[0]["F_UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["F_UserName"] != null)
{
model.F_UserName = ds.Tables[0].Rows[0]["F_UserName"].ToString();
}
if (ds.Tables[0].Rows[0]["F_PassWord"] != null)
{
model.F_PassWord = ds.Tables[0].Rows[0]["F_PassWord"].ToString();
}
if (ds.Tables[0].Rows[0]["F_DepartID"].ToString() != "")
{
model.F_DepartID = int.Parse(ds.Tables[0].Rows[0]["F_DepartID"].ToString());
}
if (ds.Tables[0].Rows[0]["F_RoleID"].ToString() != "")
{
model.F_RoleID = int.Parse(ds.Tables[0].Rows[0]["F_RoleID"].ToString());
}
if (ds.Tables[0].Rows[0]["F_RealName"] != null)
{
model.F_RealName = ds.Tables[0].Rows[0]["F_RealName"].ToString();
}
if (ds.Tables[0].Rows[0]["F_Sex"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["F_Sex"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_Sex"].ToString().ToLower() == "true"))
{
model.F_Sex = true;
}
else
{
model.F_Sex = false;
}
}
if (ds.Tables[0].Rows[0]["F_Birthday"].ToString() != "")
{
model.F_Birthday = DateTime.Parse(ds.Tables[0].Rows[0]["F_Birthday"].ToString());
}
if (ds.Tables[0].Rows[0]["F_Email"] != null)
{
model.F_Email = ds.Tables[0].Rows[0]["F_Email"].ToString();
}
if (ds.Tables[0].Rows[0]["F_MobilePhone"] != null)
{
model.F_MobilePhone = ds.Tables[0].Rows[0]["F_MobilePhone"].ToString();
}
if (ds.Tables[0].Rows[0]["F_Telphone"] != null)
{
model.F_Telphone = ds.Tables[0].Rows[0]["F_Telphone"].ToString();
}
if (ds.Tables[0].Rows[0]["F_Note"] != null)
{
model.F_Note = ds.Tables[0].Rows[0]["F_Note"].ToString();
}
if (ds.Tables[0].Rows[0]["F_RegTime"].ToString() != "")
{
model.F_RegTime = DateTime.Parse(ds.Tables[0].Rows[0]["F_RegTime"].ToString());
}
if (ds.Tables[0].Rows[0]["F_LastInTime"].ToString() != "")
{
model.F_LastInTime = DateTime.Parse(ds.Tables[0].Rows[0]["F_LastInTime"].ToString());
}
if (ds.Tables[0].Rows[0]["F_IsUsed"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["F_IsUsed"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsUsed"].ToString().ToLower() == "true"))
{
model.F_IsUsed = true;
}
else
{
model.F_IsUsed = false;
}
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 保存数据
/// </summary>
private void SaveData()
{
//验证数据项
string msg = CheckData();
if (msg.Length > 0)
{
MessageBox.Show(msg, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (textBoxPSWH.Text.Trim().Length == 0 && f_PassWordTextBox.Text.Trim().Length == 0)
{
MessageBox.Show("请输入密码!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
textBoxPSWH.Text = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(f_PassWordTextBox.Text.Trim(), "MD5").ToLower();
}
//数据准备
GSSModel.Users model = new GSSModel.Users();
model.F_UserName = f_UserNameTextBox.Text;
model.F_PassWord = textBoxPSWH.Text;
model.F_DepartID = Convert.ToInt32(f_DepartIDComboBox.SelectedValue);
model.F_RoleID = Convert.ToInt32(f_RoleIDComboBox.SelectedValue);
model.F_RealName = f_RealNameTextBox.Text;
model.F_Sex = SexradioButton1.Checked;
model.F_Birthday = Convert.ToDateTime(f_BirthdayDateTimePicker.Text);
model.F_Email = f_EmailTextBox.Text;
model.F_MobilePhone = f_MobilePhoneTextBox.Text;
model.F_Telphone = f_TelphoneTextBox.Text;
model.F_Note = f_NoteTextBox.Text;
model.F_IsUsed = f_IsUsedCheckBox.Checked;
//数据提交
GSSBLL.Users bll = new GSSBLL.Users();
bool isok = false;
if (_id != 0)
{
model.F_UserID = int.Parse(f_UserIDTextBox.Text);
model.F_LastInTime = DateTime.Now;
isok = bll.Update(model);
}
else
{
model.F_RegTime = DateTime.Now;
int num = bll.Add(model);
if (num > 0)
{
isok = true;
}
}
if (isok)
{
MessageBox.Show("数据保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("数据保存失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
