private void zjbutton_Click(object sender, EventArgs e)
{
if (ygxmtextBox.Text.Trim() == "" || zwgzcomboBox.Text.Trim() == "")
{
MessageBox.Show("请将信息填写完全！");
return;
}
staffTable model = new staffTable();
model.stName = ygxmtextBox.Text.Trim();
model.stType = zwgzcomboBox.Text.Trim();
model.stSex = ygxbcomboBox.Text.Trim();
model.stDocument = sfzhtextBox.Text.Trim() == "" ? "0" : sfzhtextBox.Text.Trim();
model.stTel = lxdhtextBox.Text.Trim() == "" ? "0" : lxdhtextBox.Text.Trim();
model.stAdd = jtzztextBox.Text.Trim() == "" ? "0" : jtzztextBox.Text.Trim();
model.stRemark = bzxxtextBox.Text.Trim() == "" ? "0" : bzxxtextBox.Text.Trim();
bool result = staffbll.AddInfoModel(model);
if (result)
{
MessageBox.Show("添加成功！");
bind();
this.Close();
}
else
{
MessageBox.Show("添加失败！");
}
}
private void zjbutton_Click(object sender, EventArgs e)
{
staffTable newmodel = new staffTable();
newmodel.Id = model.Id;
newmodel.stName = ygxmtextBox.Text.Trim();
newmodel.stType = zwgzcomboBox.Text.Trim();
newmodel.stSex = ygxbcomboBox.Text.Trim();
newmodel.stDocument = sfzhtextBox.Text.Trim() == "" ? "0" : sfzhtextBox.Text.Trim();
newmodel.stTel = lxdhtextBox.Text.Trim() == "" ? "0" : lxdhtextBox.Text.Trim();
newmodel.stAdd = jtzztextBox.Text.Trim() == "" ? "0" : jtzztextBox.Text.Trim();
newmodel.stRemark = bzxxtextBox.Text.Trim() == "" ? "0" : bzxxtextBox.Text.Trim();
bool result = staffbll.updateModel(newmodel);
if (result)
{
MessageBox.Show("修改成功！");
bind();
this.Close();
}
else
{
MessageBox.Show("修改失败！");
}
}
public static hyxgFrom Create(staffTable model11, databind bind1)
{
bind = bind1;
model = model11;
if (yggl == null)
{
yggl = new hyxgFrom();
}
return(yggl);
}
private void xgbutton_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count != 1)
{
MessageBox.Show("请选择一条数据！");
return;
}
staffTable model = (staffTable)dataGridView1.SelectedRows[0].DataBoundItem;
hyxgFrom hyxg = hyxgFrom.Create(model, databind);
hyxg.Show();
hyxg.Focus();
}
private void scbutton_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count != 1)
{
MessageBox.Show("请选择一条数据！");
return;
}
staffTable model = (staffTable)dataGridView1.SelectedRows[0].DataBoundItem;
bool result = staffbll.deleteIteam(model.Id);
if (result)
{
MessageBox.Show("删除成功！");
databind();
return;
}
MessageBox.Show("删除失败！");
}
//查询所有的店铺员工的详细信息
public List <staffTable> selectAllList()
{
string dpname = FilterClass.DianPu1.UserName.Trim();
List <staffTable> list = new List <staffTable>();
staffTable model;
SqlParameter[] pms;
string str;
if (dpname == "admin")
{
pms = new SqlParameter[] {};
str = "select * from staffTable";
}
else
{
pms = new SqlParameter[] {
new SqlParameter("@DPName", dpname)
};
str = "select * from staffTable where DPName=@DPName";
}
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model = new staffTable();
model.Id = Convert.ToInt32(read["Id"]);
model.stName = read["stName"].ToString();
model.stDocument = read["stDocument"].ToString();
model.stSex = read["stSex"].ToString();
model.stTel = read["stTel"].ToString();
model.stType = read["stType"].ToString();
model.stAdd = read["stAdd"].ToString();
model.stRemark = read["stRemark"].ToString();
list.Add(model);
}
}
return(list);
}
//修改某一个员工信息
public bool updateModel(staffTable model)
{
bool result = false;
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@stName", model.stName),
new SqlParameter("@stDocument", model.stDocument),
new SqlParameter("@stSex", model.stSex),
new SqlParameter("@stTel", model.stTel),
new SqlParameter("@stAdd", model.stAdd),
new SqlParameter("@stRemark", model.stRemark),
new SqlParameter("@Id", model.Id),
new SqlParameter("@stType", model.stType),
};
string str = "update staffTable set stName=@stName,stDocument=@stDocument,stSex=@stSex,stTel=@stTel,stType=@stType,stAdd=@stAdd,stRemark=@stRemark where Id=@Id";
if (SqlHelper.ExecuteNonQuery(str, pms) > 0)
{
result = true;
}
return(result);
}
//店铺中的员工的信息表
//添加员工的信息
public bool AddInfoModel(staffTable model)
{
bool result = false;
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@stName", model.stName),
new SqlParameter("@stDocument", model.stDocument),
new SqlParameter("@stSex", model.stSex),
new SqlParameter("@stTel", model.stTel),
new SqlParameter("@stType", model.stType),
new SqlParameter("@stAdd", model.stAdd),
new SqlParameter("@stRemark", model.stRemark),
new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim())
};
string str = "insert into staffTable(stName,stDocument,stSex,stTel,stType,stAdd,stRemark,DPName) values(@stName,@stDocument,@stSex,@stTel,@stType,@stAdd,@stRemark,@DPName)";
if (SqlHelper.ExecuteNonQuery(str, pms) > 0)
{
result = true;
}
return(result);
}
public bool updateModel(staffTable model)
{
return(dal.updateModel(model));
}
public bool AddInfoModel(staffTable model)
{
return(dal.AddInfoModel(model));
}
