private void btnSave_Click(object sender, EventArgs e)
{
//验证
if (tbName.Text.Trim() == "")
{
MessageBoxEx.Show("请输入员工姓名!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
tbName.Focus();
return;
}
if (tbPwd.Text.Trim() == "")
{
MessageBoxEx.Show("请输入登录密码!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
tbPwd.Focus();
return;
}
Dong.Model.OperInfo mOper = new Dong.Model.OperInfo();
mOper.Code = tbCode.Text.Trim();
mOper.Name = tbName.Text.Trim();
mOper.Pwd = tbPwd.Text.Trim();
mOper.Sex = cbSex.Text;
if (tbPhone.Text != "")
{
mOper.Phone = tbPhone.Text.Trim();
}
else
{
mOper.Phone = "无";
}
if (tbCID.Text != "")
{
mOper.CId = tbCID.Text.Trim();
}
else
{
mOper.CId = "无";
}
mOper.Role = 0;
Dong.BLL.OperInfo bOper = new Dong.BLL.OperInfo();
if (bOper.Update(mOper))
{
MessageBoxEx.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmUsers fUser = (frmUsers)this.Owner;
fUser.refreshData();
this.Close();
}
else
{
MessageBoxEx.Show("保存失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmAddVip_Load(object sender, EventArgs e)
{
cbSex.Items.Add("男");
cbSex.Items.Add("女");
Dong.BLL.OperInfo bOper = new Dong.BLL.OperInfo();
Dong.Model.OperInfo mOper = new Dong.Model.OperInfo();
mOper = bOper.GetModel(this.Tag.ToString());
tbCode.Text = mOper.Code;
tbName.Text = mOper.Name;
tbPhone.Text = mOper.Phone;
tbPwd.Text = mOper.Pwd;
tbCID.Text = mOper.CId;
cbSex.Text = mOper.Sex;
cbRoles.Items.Add(new ComboBoxItem("0", "管理员"));
cbRoles.Items.Add(new ComboBoxItem("1", "收银员"));
cbRoles.SelectedIndex = (int)mOper.Role;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Dong.Model.OperInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OperInfo set ");
strSql.Append("Pwd=@Pwd,");
strSql.Append("Name=@Name,");
strSql.Append("Sex=@Sex,");
strSql.Append("CId=@CId,");
strSql.Append("Phone=@Phone,");
strSql.Append("Role=@Role");
strSql.Append(" where Code=@Code ");
OleDbParameter[] parameters =
{
new OleDbParameter("@Pwd", OleDbType.VarChar, 50),
new OleDbParameter("@Name", OleDbType.VarChar, 50),
new OleDbParameter("@Sex", OleDbType.VarChar, 50),
new OleDbParameter("@CId", OleDbType.VarChar, 50),
new OleDbParameter("@Phone", OleDbType.VarChar, 50),
new OleDbParameter("@Role", OleDbType.Integer, 4),
new OleDbParameter("@Code", OleDbType.VarChar, 50)
};
parameters[0].Value = model.Pwd;
parameters[1].Value = model.Name;
parameters[2].Value = model.Sex;
parameters[3].Value = model.CId;
parameters[4].Value = model.Phone;
parameters[5].Value = model.Role;
parameters[6].Value = model.Code;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dong.Model.OperInfo DataRowToModel(DataRow row)
{
Dong.Model.OperInfo model = new Dong.Model.OperInfo();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["Code"] != null)
{
model.Code = row["Code"].ToString();
}
if (row["Pwd"] != null)
{
model.Pwd = row["Pwd"].ToString();
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["Sex"] != null)
{
model.Sex = row["Sex"].ToString();
}
if (row["CId"] != null)
{
model.CId = row["CId"].ToString();
}
if (row["Phone"] != null)
{
model.Phone = row["Phone"].ToString();
}
if (row["Role"] != null && row["Role"].ToString() != "")
{
model.Role = int.Parse(row["Role"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Dong.Model.OperInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OperInfo(");
strSql.Append("Code,Pwd,Name,Sex,CId,Phone,Role)");
strSql.Append(" values (");
strSql.Append("@Code,@Pwd,@Name,@Sex,@CId,@Phone,@Role)");
OleDbParameter[] parameters =
{
new OleDbParameter("@Code", OleDbType.VarChar, 50),
new OleDbParameter("@Pwd", OleDbType.VarChar, 50),
new OleDbParameter("@Name", OleDbType.VarChar, 50),
new OleDbParameter("@Sex", OleDbType.VarChar, 50),
new OleDbParameter("@CId", OleDbType.VarChar, 50),
new OleDbParameter("@Phone", OleDbType.VarChar, 50),
new OleDbParameter("@Role", OleDbType.Integer, 4)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Pwd;
parameters[2].Value = model.Name;
parameters[3].Value = model.Sex;
parameters[4].Value = model.CId;
parameters[5].Value = model.Phone;
parameters[6].Value = model.Role;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dong.Model.OperInfo GetModel(string Code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,Code,Pwd,Name,Sex,CId,Phone,Role from OperInfo ");
strSql.Append(" where Code=@Code ");
OleDbParameter[] parameters =
{
new OleDbParameter("@Code", OleDbType.VarChar, 50)
};
parameters[0].Value = Code;
Dong.Model.OperInfo model = new Dong.Model.OperInfo();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
