//通过服务名称查询数据
public fuwuModel selectIteam(string name)
{
fuwuModel model = new fuwuModel();
string str;
SqlParameter[] pms;
//if (FilterClass.DianPu1.UserName.Trim()=="admin")
//{
str = "select * from fuwuInfo where Name=@Name and DPName='" + FilterClass.DianPu1.UserName.Trim() + "' ";
pms = new SqlParameter[] {
new SqlParameter("@Name", name.Trim())
};
// }
//else
//{
// str = "select * from fuwuInfo where Name=@Name and DPName=@DPName";
// pms = new SqlParameter[] {
//new SqlParameter("@Name",name.Trim()),
//new SqlParameter("@DPName",FilterClass.DianPu1.UserName.Trim())
//};
//}
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model.Name = read["Name"].ToString().Trim();
model.neirong = read["neirong"].ToString().Trim();
}
}
return(model);
}
private void scfwbutton_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedColumns.Count != 1)
{
MessageBox.Show("请选择要编辑的一列！");
return;
}
string name = dataGridView1.SelectedColumns[0].HeaderText;
fuwuModel model = bll.selectIteam(name);
if (model == null)
{
MessageBox.Show("请选择有效列！");
return;
}
bool result = bll.deleteIteam(name);
if (result)
{
MessageBox.Show("删除成功！");
gridbind();
return;
}
MessageBox.Show("删除失败！");
}
//显示服务 查询功能
public List <fuwuModel> selectAllList()
{
List <fuwuModel> list = new List <fuwuModel>();
fuwuModel model;
string str = "select * from fuwuInfo where DPName='" + FilterClass.DianPu1.UserName.Trim() + "'";
//SqlParameter[] pms;
//if (FilterClass.DianPu1.UserName.Trim()=="admin")
//{
// str = "select * from fuwuInfo";
//}
//else
//{
// str = "select * from fuwuInfo";
//// pms = new SqlParameter[] {
////new SqlParameter("@DPName",FilterClass.DianPu1.UserName.Trim())
////};
//}
SqlDataReader read = SqlHelper.ExecuteReader(str);
while (read.Read())
{
if (read.HasRows)
{
model = new fuwuModel();
model.Name = read["Name"].ToString();
model.neirong = read["neirong"].ToString();
list.Add(model);
}
}
return(list);
}
private void fuwuEdit_Load(object sender, EventArgs e)
{
fuwuModel model = new fuwuModel();
model = fuwubll.selectIteam(name);
if (model == null)
{
MessageBox.Show("请选择有效行！");
return;
}
List <string> list = new List <string>();
list = bll.selectNodes();
list.Insert(0, "无卡");
tableLayoutPanel1.Height = (list.Count + 1) * 40;
RowStyle row;
Label lab1;
TextBox teb1;
//row = new RowStyle(SizeType.Absolute,40);
lab1 = new Label();
lab1.Text = "服务类别名称";
teb1 = new TextBox();
teb1.Text = model.Name;
teb1.ReadOnly = true;
tableLayoutPanel1.Controls.Add(lab1, 0, 0);
tableLayoutPanel1.Controls.Add(teb1, 1, 0);
foreach (var i in list)
{
lab1 = new Label();
lab1.Text = i;
teb1 = new TextBox();
row = new RowStyle(SizeType.Absolute, 40);
string[] str = model.neirong.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var iteam in str)
{
string[] ss = iteam.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (i.Trim() == ss[0].Trim())
{
teb1.Text = ss[1];
}
}
tableLayoutPanel1.Controls.Add(lab1, 0, tableLayoutPanel1.RowStyles.Count - 1);
tableLayoutPanel1.Controls.Add(teb1, 1, tableLayoutPanel1.RowStyles.Count - 1);
tableLayoutPanel1.RowStyles.Add(row);
}
}
//服务的DAL
//添加服务类 基本服务
//admin账户可设置此参数 添加服务的时候记录 店铺名称 在查询的时候去除名称
public bool AddModel(fuwuModel model)
{
bool result = false;
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@Name", model.Name),
new SqlParameter("@neirong", model.neirong),
new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim())
};
string str = "insert into fuwuInfo(Name,neirong,DPName) values(@Name,@neirong,@DPName)";
if (SqlHelper.ExecuteNonQuery(str, pms) > 0)
{
result = true;
}
return(result);
}
//修改基本服务中的信息
public bool EditModel(fuwuModel model)
{
bool result = false;
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@neirong", model.neirong),
new SqlParameter("@Name", model.Name),
new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim())
};
string str = "update fuwuInfo set neirong=@neirong where Name=@Name and DPName=@DPName";
if (SqlHelper.ExecuteNonQuery(str, pms) > 0)
{
result = true;
}
return(result);
}
private void xgfwbutton_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedColumns.Count != 1)
{
MessageBox.Show("请选择要编辑的一列！");
return;
}
string name = dataGridView1.SelectedColumns[0].HeaderText;
fuwuModel model = bll.selectIteam(name);
if (model == null)
{
MessageBox.Show("请选择有效列！");
return;
}
fuwuEdit fuwu = fuwuEdit.Create(gridbind, name);
fuwu.Show();
fuwu.Focus();
}
private void button1_Click(object sender, EventArgs e)
{
fuwuModel model = new fuwuModel();
TextBox tb;
Label lb;
string str = "";
int count = tableLayoutPanel1.RowStyles.Count;
for (int i = 0; i < count - 1; i++)
{
if (i == 0)
{
tb = tableLayoutPanel1.GetControlFromPosition(1, i) as TextBox;
model.Name = tb.Text.Trim();
continue;
}
lb = tableLayoutPanel1.GetControlFromPosition(0, i) as Label;
tb = tableLayoutPanel1.GetControlFromPosition(1, i) as TextBox;
if (tb.Text == "")
{
MessageBox.Show("信息不能为空！");
model.Name = "";
str = "";
return;
}
str += lb.Text.Trim() + "," + tb.Text.Trim() + ";";
}
model.neirong = str;
bool result = fuwubl.AddModel(model);
if (result)
{
MessageBox.Show("添加成功！");
bind1();
this.Close();
return;
}
MessageBox.Show("添加失败！");
}
public bool EditModel(fuwuModel model)
{
return(dal.EditModel(model));
}
public bool AddModel(fuwuModel model)
{
return(dal.AddModel(model));
}
