public List <qtFuWuModel> SelectAllList()
{
string dpname = FilterClass.DianPu1.UserName.Trim();
List <qtFuWuModel> list = new List <qtFuWuModel>();
qtFuWuModel model;
SqlParameter[] pms;
string str;
if (dpname == "admin")
{
pms = new SqlParameter[] { };
str = "select * from QtFuWu";
}
else
{
pms = new SqlParameter[] {
new SqlParameter("@DPName", dpname)
};
str = "select * from QtFuWu where DPName=@DPName";
}
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model = new qtFuWuModel();
model.QtName = read["QtName"].ToString();
list.Add(model);
}
}
return(list);
}
private void button1_Click(object sender, EventArgs e)
{
qtFuWuModel model = new qtFuWuModel();
model.QtName = textBox1.Text.Trim();
try
{
//money = Convert.ToInt32(textBox2.Text.Trim());
//if (money > 100 || money < 0)
//{
// MessageBox.Show("请输入合理的提成！");
// return;
//}
//model.QtTc = money;
bool result = bll.EditModel(model);
if (result)
{
MessageBox.Show("修改成功！");
bind1();
this.Close();
return;
}
MessageBox.Show("错误！请稍后再试！");
}
catch
{
MessageBox.Show("提成请输入数字！");
}
}
public static EditQtFuWu Create(databind bind, qtFuWuModel model)
{
model1 = model;
bind1 = bind;
if (qt == null)
{
qt = new EditQtFuWu();
}
return(qt);
}
private void button2_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count != 1)
{
MessageBox.Show("请选择一条数据！");
return;
}
qtFuWuModel model = (qtFuWuModel)dataGridView1.SelectedRows[0].DataBoundItem;
EditQtFuWu qtedit = EditQtFuWu.Create(databind, model);
qtedit.Show();
qtedit.Focus();
}
/// <summary>
/// 添加其他服务类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddModel(qtFuWuModel model)
{
bool result = false;
string str = "insert into QtFuWu(QtName,DPName) values(@QtName,@DPName)";
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@QtName", model.QtName),
new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim())
};
if (SqlHelper.ExecuteNonQuery(str, pms) > 0)
{
result = true;
}
return(result);
}
public bool EditModel(qtFuWuModel model)
{
bool result = false;
string str = "update QtFuWu set QtName=@QtName1 where QtName=@QtName and DPName=@DPName";
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@QtName", model.QtName),
new SqlParameter("@QtName1", model.QtName),
new SqlParameter("@DPName", FilterClass.DianPu1.UserName.Trim())
};
if (SqlHelper.ExecuteNonQuery(str, pms) > 0)
{
result = true;
}
return(result);
}
public bool EditModel(qtFuWuModel model)
{
return(dal.EditModel(model));
}
public bool AddModel(qtFuWuModel model)
{
return(dal.AddModel(model));
}
