//查询所有店铺的信息
public List <DianPu> selectAllList()
{
List <DianPu> list = new List <DianPu>();
DianPu model;
string str = "";
if (FilterClass.DianPu1.UserName == "admin")
{
str = "select * from DPInfo";
}
else
{
str = "select * from DPInfo where DPName='" + FilterClass.DianPu1.UserName.Trim() + "'";
}
SqlDataReader read = SqlHelper.ExecuteReader(str);
while (read.Read())
{
if (read.HasRows)
{
model = new DianPu();
model.DPName = read["DPName"].ToString();
model.DPContent = read["DPContent"].ToString();
model.DPAddress = read["DPAddress"].ToString();
model.DPPerson = read["DPPerson"].ToString();
model.DPPicture = read["DPPicture"].ToString();
model.DPRemark = read["DPRemark"].ToString();
model.DPTel = read["DPTel"].ToString();
model.DPNo = read["DPNo"].ToString();
model.ID = Convert.ToInt32(read["ID"]);
list.Add(model);
}
}
return(list);
}
private void bcbutton_Click(object sender, EventArgs e)
{
DianPu model = new DianPu();
model.DPName = dpmcBox.Text.Trim();
model.DPPerson = lxrBox.Text.Trim();
model.DPTel = lxdhBox.Text.Trim();
model.DPAddress = dpdztBox.Text.Trim();
model.DPRemark = bzxxBox.Text.Trim();
model.DPContent = textBox1.Text.Trim();
model.DPPicture = comboBox1.Text.Trim();
model.DPNo = textBox2.Text.Trim();
model.DPDay = DateTime.Now.Day.ToString();
model.BGJPrint = comboBox2.Text;
model.MemberPrint = comboBox3.Text;
model.DPNumber = "1";
if (model.DPName == "" || model.DPPerson == "" || model.DPTel == "" || model.DPAddress == "" || model.DPRemark == "" || model.DPPicture == "")
{
MessageBox.Show("请将信息填写完整！");
return;
}
int result = dpbll.AddModel(model);
if (result != 0)
{
MessageBox.Show("添加成功！");
bind();
//添加成功之后，开始添加新店铺所对应的表
dpbll.AddTable(result);
this.Close();
return;
}
MessageBox.Show("添加失败！");
}
private void bcbutton_Click(object sender, EventArgs e)
{
DianPu model = new DianPu();
model.DPName = dpmcBox.Text.Trim();
model.DPPerson = lxrBox.Text.Trim();
model.DPTel = lxdhBox.Text.Trim();
model.DPNo = textBox2.Text.Trim();
model.DPAddress = dpdztBox.Text.Trim();
model.DPRemark = bzxxBox.Text.Trim();
model.DPContent = textBox1.Text.Trim();
model.DPPicture = comboBox1.Text.Trim();
model.BGJPrint = comboBox2.Text;
model.MemberPrint = comboBox3.Text;
if (model.DPName == "" || model.DPPerson == "" || model.DPTel == "" || model.DPAddress == "" || model.DPRemark == "" || model.DPPicture == "")
{
MessageBox.Show("请将信息填写完整！");
return;
}
bool result = dpbll.UpdateModel(model);
if (result)
{
MessageBox.Show("修改成功！");
bind();
this.Close();
return;
}
MessageBox.Show("修改失败！");
}
public static DPUpdateFrom Create(databind bind1, DianPu model)
{
model1 = model;
bind = bind1;
if (lsdzj == null)
{
lsdzj = new DPUpdateFrom();
}
return(lsdzj);
}
private void button2_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count != 1)
{
MessageBox.Show("请选择一条数据！");
return;
}
DianPu model = new DianPu();
model = (DianPu)dataGridView1.SelectedRows[0].DataBoundItem;
DPUpdateFrom lsdzj = DPUpdateFrom.Create(databind, model);
lsdzj.Show();
lsdzj.Focus();
}
public bool UpdateModel(DianPu model)
{
bool result = false;
string str = "update DPInfo set DPPerson=@DPPerson,DPTel=@DPTel,DPAddress=@DPAddress,DPRemark=@DPRemark,DPContent=@DPContent,DPPicture=@DPPicture,DPNo=@DPNo,MemberPrint=@MemberPrint,BGJPrint=@BGJPrint where DPName=@DPName";
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@DPName", model.DPName),
new SqlParameter("@DPPerson", model.DPPerson),
new SqlParameter("@DPTel", model.DPTel),
new SqlParameter("@DPAddress", model.DPAddress),
new SqlParameter("@DPRemark", model.DPRemark),
new SqlParameter("@DPContent", model.DPContent),
new SqlParameter("@DPPicture", model.DPPicture),
new SqlParameter("@MemberPrint", model.MemberPrint),
new SqlParameter("@BGJPrint", model.BGJPrint),
new SqlParameter("@DPNo", model.DPNo)
};
if (SqlHelper.ExecuteNonQuery(str, pms) > 0)
{
result = true;
}
return(result);
}
private void button3_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count != 1)
{
MessageBox.Show("请选择一条数据！");
return;
}
var btnresult = MessageBox.Show("确认删除？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (btnresult == DialogResult.OK)
{
DianPu model = new DianPu();
model = (DianPu)dataGridView1.SelectedRows[0].DataBoundItem;
bool result = dpbll.deleteIteam(model.ID);
if (result)
{
MessageBox.Show("删除成功！");
databind();
return;
}
MessageBox.Show("删除失败！");
}
}
//此类是唯一的只有admin能访问
//店铺信息DAL
//插入店铺信息
public int AddModel(DianPu model)
{
//首先判断 当前的店铺名字是否唯一 唯一之后才可添加新店铺
string dpname = model.DPName.Trim();
bool isweiyi = DpnameWY(dpname);
if (!isweiyi)
{
return(0);
}
string str = "insert into DPInfo(DPName,DPPerson,DPTel,DPAddress,DPRemark,DPContent,DPPicture,DPNo,DPDay,DPNumber,MemberPrint,BGJPrint) values(@DPName,@DPPerson,@DPTel,@DPAddress,@DPRemark,@DPContent,@DPPicture,@DPNo,@DPDay,@DPNumber,@MemberPrint,@BGJPrint);select @@Identity";
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@DPName", model.DPName),
new SqlParameter("@DPPerson", model.DPPerson),
new SqlParameter("@DPTel", model.DPTel),
new SqlParameter("@DPAddress", model.DPAddress),
new SqlParameter("@DPRemark", model.DPRemark),
new SqlParameter("@DPContent", model.DPContent),
new SqlParameter("@DPPicture", model.DPPicture),
new SqlParameter("@DPNo", model.DPNo),
new SqlParameter("@DPDay", model.DPDay),
new SqlParameter("@DPNumber", model.DPNumber),
new SqlParameter("@MemberPrint", model.MemberPrint),
new SqlParameter("@BGJPrint", model.BGJPrint)
};
object oo = SqlHelper.ExecuteScalar(str, pms);
if (oo == null)
{
return(0);
}
else
{
return(Convert.ToInt32(oo));
}
}
public bool UpdateModel(DianPu model)
{
return(dal.UpdateModel(model));
}
public int AddModel(DianPu model)
{
return(dal.AddModel(model));
}
