//修改的时候进行提交
public bool EditMemberInfo(memberInfoModel model)
{
bool result = false;
result = dal.EditMemberInfo(model);
return(result);
}
//修改会员信息
public bool EditMemberInfo(memberInfoModel model)
{
bool result = false;
string str = "update memberInfo set memberName=@memberName,memberTel=@memberTel,memberDocument=@memberDocument,birDate=@birDate,cardDate=@cardDate,memberSex=@memberSex,rebate=@rebate,endDate=@endDate,fuwuBate=@fuwuBate,cardMoney=@cardMoney,toUpMoney=@toUpMoney,cardType=@cardType,salesMan=@salesMan,memberType=@memberType,address=@address,remark=@remark,imgUrl=@imgUrl,password=@password,zhuangtai=@zhuangtai,membercardNo=@membercardNo where ID=@ID";
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@membercardNo", model.memberCardNo),
new SqlParameter("@ID", model.ID),
new SqlParameter("@memberName", model.memberName),
new SqlParameter("@memberTel", model.memberTel),
new SqlParameter("@memberDocument", model.memberDocument),
new SqlParameter("@birDate", model.birDate),
new SqlParameter("@cardDate", model.cardDate),
new SqlParameter("@memberSex", model.memberSex),
new SqlParameter("@rebate", model.rebate),
new SqlParameter("@endDate", model.endDate),
new SqlParameter("@fuwuBate", model.fuwuBate),
new SqlParameter("@toUpMoney", model.toUpMoney),
new SqlParameter("@cardMoney", model.cardMoney),
new SqlParameter("@cardType", model.cardType),
new SqlParameter("@salesMan", model.saleMan),
new SqlParameter("@memberType", model.memberType),
new SqlParameter("@address", model.address == null?DBNull.Value.ToString():model.address),
new SqlParameter("@remark", model.remark == null?DBNull.Value.ToString():model.remark),
new SqlParameter("@imgUrl", model.imageUrl),
new SqlParameter("@password", model.password == null?DBNull.Value.ToString():model.password),
new SqlParameter("@zhuangtai", model.zhuangtai),
//new SqlParameter("@dianName",FilterClass.DianPu1.UserName.Trim())
};
if (SqlHelper.ExecuteNonQuery(str, pms) > 0)
{
result = true;
}
return(result);
}
/// <summary>
/// 办卡导出
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="list"></param>
/// <param name="sheet"></param>
/// <returns></returns>
private static IWorkbook memberInfopirent <T>(List <T> list, ISheet sheet)
{
int rowIndex = 0;
IRow row = sheet.CreateRow(rowIndex);
#region MyRegion//表头
row.CreateCell(0).SetCellValue("会员卡号");
row.CreateCell(1).SetCellValue("会员姓名");
row.CreateCell(2).SetCellValue("会员电话");
row.CreateCell(3).SetCellValue("会员生日");
row.CreateCell(4).SetCellValue("身份证号");
row.CreateCell(5).SetCellValue("办卡日期");
row.CreateCell(6).SetCellValue("会员性别");
row.CreateCell(7).SetCellValue("折扣");
row.CreateCell(8).SetCellValue("卡到期");
row.CreateCell(9).SetCellValue("服务折扣");
row.CreateCell(10).SetCellValue("充值金额");
row.CreateCell(11).SetCellValue("办卡金额");
row.CreateCell(12).SetCellValue("店铺名");
row.CreateCell(13).SetCellValue("卡类型");
row.CreateCell(14).SetCellValue("业务员");
row.CreateCell(15).SetCellValue("会员类别");
row.CreateCell(16).SetCellValue("地址");
row.CreateCell(17).SetCellValue("备注");
row.CreateCell(18).SetCellValue("状态");
row.CreateCell(19).SetCellValue("密码");
rowIndex++;
#endregion
foreach (T item in list)
{
memberInfoModel model = item as memberInfoModel;
//每遍历一条数据创建一行
row = sheet.CreateRow(rowIndex);
//创建行中的单元格
row.CreateCell(0).SetCellValue(model.memberCardNo);
row.CreateCell(1).SetCellValue(model.memberName);
row.CreateCell(2).SetCellValue(model.memberTel);
row.CreateCell(3).SetCellValue(model.birDate);
row.CreateCell(4).SetCellValue(model.memberDocument);
row.CreateCell(5).SetCellValue(model.cardDate);
row.CreateCell(6).SetCellValue(model.memberSex);
row.CreateCell(7).SetCellValue(model.rebate);
row.CreateCell(8).SetCellValue(model.endDate);
row.CreateCell(9).SetCellValue(model.fuwuBate);
row.CreateCell(10).SetCellValue(model.toUpMoney);
row.CreateCell(11).SetCellValue(model.cardMoney);
row.CreateCell(12).SetCellValue(model.dianName);
row.CreateCell(13).SetCellValue(model.cardType);
row.CreateCell(14).SetCellValue(model.saleMan);
row.CreateCell(15).SetCellValue(model.memberType);
row.CreateCell(16).SetCellValue(model.address);
row.CreateCell(17).SetCellValue(model.remark);
row.CreateCell(18).SetCellValue(model.zhuangtai);
row.CreateCell(19).SetCellValue(model.password);
rowIndex++;
}
return(sheet.Workbook);
}
//为了导出使用的 查询某一种类型的所有数据
public List <memberInfoModel> selectAll(string cardTepe)
{
int i = 1;
List <memberInfoModel> list = new List <memberInfoModel>();
memberInfoModel model;
SqlDataReader read;
SqlParameter[] pms;
string str;
if (cardTepe.Trim() == "全部")
{
str = "select * from memberInfo";
read = SqlHelper.ExecuteReader(str);
}
else
{
pms = new SqlParameter[] {
new SqlParameter("@memberType", cardTepe)
};
str = "select * from memberInfo where memberType=@memberType";
read = SqlHelper.ExecuteReader(str, pms);
}
while (read.Read())
{
if (read.HasRows)
{
model = new memberInfoModel();
model.memberCardNo = read["memberCardNo"].ToString();
model.memberName = read["memberName"].ToString();
model.memberTel = read["memberTel"].ToString();
model.memberDocument = read["memberDocument"].ToString();
model.birDate = read["birDate"].ToString();
model.cardDate = read["cardDate"].ToString();
model.memberSex = read["memberSex"].ToString();
model.rebate = read["rebate"].ToString();
model.endDate = read["endDate"].ToString();
model.fuwuBate = read["fuwuBate"].ToString();
model.toUpMoney = read["toUpMoney"].ToString();
model.cardMoney = read["cardMoney"].ToString();
model.dianName = read["dianName"].ToString();
model.cardType = read["cardType"].ToString();
model.saleMan = read["salesMan"].ToString();
model.memberType = read["memberType"].ToString();
model.address = read["address"].ToString();
model.remark = read["remark"].ToString();
model.imageUrl = read["imgUrl"].ToString();
model.password = read["password"].ToString();
model.zhuangtai = read["zhuangtai"].ToString();
model.ID = Convert.ToInt32(read["ID"]);
model.idbh = i;
list.Add(model);
i++;
}
}
return(list.OrderByDescending(a => a.ID).ToList());
}
public static hyInfoZhanShi Create(memberInfoModel model)
{
model1 = model;
if (_danli == null)
{
_danli = new hyInfoZhanShi();
}
return(_danli);
}
public static xiugaimember Create(memberInfoModel model, binddata bindd)
{
bdata = bindd;
modelmember = model;
if (hyzj == null)
{
hyzj = new xiugaimember();
}
return(hyzj);
}
public static hyczck Create(memberInfoModel model, bind1 datbind)
{
bind = datbind;
model1 = model;
if (_danli == null)
{
_danli = new hyczck();
}
return(_danli);
}
public static ExitCard CreateForm(memberInfoModel model, DataBind bind)
{
bind1 = bind;
zhanshimolde = model;
if (_danli == null)
{
_danli = new ExitCard();
}
return(_danli);
}
private void 除会员ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
MessageBox.Show("请选择会员!");
return;
}
memberInfoModel model = (memberInfoModel)dataGridView1.SelectedRows[0].DataBoundItem;
caocuofrom chongzhi = caocuofrom.Create(deletePassword, model.ID.ToString().Trim());
chongzhi.Show();
chongzhi.Focus();
}
private void 会员信息ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
MessageBox.Show("请选择会员!");
return;
}
memberInfoModel model = (memberInfoModel)dataGridView1.SelectedRows[0].DataBoundItem;
hyInfoZhanShi chongzhi = hyInfoZhanShi.Create(model);
chongzhi.Show();
chongzhi.Focus();
}
private void ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
MessageBox.Show("请选择会员!");
return;
}
//memberInfoModel model = list[id];
memberInfoModel model = (memberInfoModel)dataGridView1.SelectedRows[0].DataBoundItem;
xiugaimember xiugais = xiugaimember.Create(model, bindData);
xiugais.Show();
xiugais.Focus();
//id = -1;
}
//public string ID = FilterClass.ID == null ? null : FilterClass.ID.Trim();
//添加会员信息 在会员管理里面的
public bool AddMemberInfo(memberInfoModel model)
{
bool result = false;
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@membercardNo", model.memberCardNo),
new SqlParameter("@memberName", model.memberName),
new SqlParameter("@memberTel", model.memberTel),
new SqlParameter("@memberDocument", model.memberDocument),
new SqlParameter("@birDate", SqlDbType.SmallDateTime)
{
Value = model.birDate
},
new SqlParameter("@cardDate", SqlDbType.SmallDateTime)
{
Value = model.cardDate
},
new SqlParameter("@memberSex", model.memberSex),
new SqlParameter("@rebate", model.rebate),
new SqlParameter("@endDate", SqlDbType.SmallDateTime)
{
Value = model.endDate
},
new SqlParameter("@fuwuBate", model.fuwuBate),
new SqlParameter("@toUpMoney", model.toUpMoney),
new SqlParameter("@cardMoney", model.cardMoney),
new SqlParameter("@dianName", model.dianName),
new SqlParameter("@cardType", model.cardType),
new SqlParameter("@salesMan", model.saleMan),
new SqlParameter("@memberType", model.memberType),
new SqlParameter("@address", model.address),
new SqlParameter("@remark", model.remark),
new SqlParameter("@imgUrl", model.imageUrl),
new SqlParameter("@password", model.password == null?DBNull.Value.ToString():model.password),
new SqlParameter("@zhuangtai", model.zhuangtai),
new SqlParameter("@PY", model.PY)
};
string str = "insert into memberInfo(membercardNo,memberName,memberTel,memberDocument,birDate,cardDate,memberSex,rebate,endDate,fuwuBate,toUpMoney,cardMoney,dianName,cardType,salesMan,memberType,address,remark,imgUrl,password,zhuangtai,PY) values(@membercardNo,@memberName,@memberTel,@memberDocument,@birDate,@cardDate,@memberSex,@rebate,@endDate,@fuwuBate,@toUpMoney,@cardMoney,@dianName,@cardType,@salesMan,@memberType,@address,@remark,@imgUrl,@password,@zhuangtai,@PY)";
if (SqlHelper.ExecuteNonQuery(str, pms) > 0)
{
result = true;
}
return(result);
}
private void 打印预览ToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("确定退卡？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (DialogResult.Cancel == result)
{
return;
}
if (dataGridView1.SelectedRows.Count != 1)
{
MessageBox.Show("请选择一条记录！");
return;
}
memberInfoModel model = dataGridView1.SelectedRows[0].DataBoundItem as memberInfoModel;
ExitCard fromcard = ExitCard.CreateForm(model, bindData);
fromcard.Show();
fromcard.Focus();
}
//当点击 会员管理左侧的节点的时候 合首次加载的时候 加载相应的卡的信息
public List <memberInfoModel> selectInfoCollect(string cardTepe, int ii, out int j)
{
string dpname = FilterClass.DianPu1.UserName.Trim();
int i = 1;
List <memberInfoModel> list = new List <memberInfoModel>();
memberInfoModel model;
SqlDataReader read;
SqlParameter[] pms;
string str;
//先获取所有的数量
str = "select count(*) from memberInfo";
if (cardTepe != "全部")
{
str += " where memberType='" + cardTepe + "'";
}
object oo = SqlHelper.ExecuteScalar(str);
j = Convert.ToInt32(oo);
if (cardTepe.Trim() == "全部")
{
str = "select top 300 * from memberInfo where ID NOT IN(select TOP " + (ii - 1) * 300 + " ID from memberInfo order by ID DESC,cardDate DESC) order by ID DESC";
read = SqlHelper.ExecuteReader(str);
}
else
{
pms = new SqlParameter[] {
new SqlParameter("@memberType", cardTepe),
new SqlParameter("@memberType1", cardTepe)
};
str = "select top 300 * from memberInfo where memberType=@memberType and ID NOT IN(select TOP " + (ii - 1) * 300 + " ID from memberInfo where memberType=@memberType1 order by ID DESC,cardDate DESC) order by ID DESC";
read = SqlHelper.ExecuteReader(str, pms);
}
while (read.Read())
{
if (read.HasRows)
{
model = new memberInfoModel();
model.memberCardNo = read["memberCardNo"].ToString();
model.memberName = read["memberName"].ToString();
model.memberTel = read["memberTel"].ToString();
model.memberDocument = read["memberDocument"].ToString();
model.birDate = read["birDate"].ToString();
model.cardDate = read["cardDate"].ToString();
model.memberSex = read["memberSex"].ToString();
model.rebate = read["rebate"].ToString();
model.endDate = read["endDate"].ToString();
model.fuwuBate = read["fuwuBate"].ToString();
model.toUpMoney = read["toUpMoney"].ToString();
model.cardMoney = read["cardMoney"].ToString();
model.dianName = read["dianName"].ToString();
model.cardType = read["cardType"].ToString();
model.saleMan = read["salesMan"].ToString();
model.memberType = read["memberType"].ToString();
model.address = read["address"].ToString();
model.remark = read["remark"].ToString();
model.imageUrl = read["imgUrl"].ToString();
model.password = read["password"].ToString();
model.zhuangtai = read["zhuangtai"].ToString();
model.ID = Convert.ToInt32(read["ID"]);
model.idbh = i;
list.Add(model);
i++;
}
}
return(list.OrderByDescending(a => a.ID).ToList());
}
//按条件查找会员
public List <memberInfoModel> hyczModel(string neirong, string tiaojian, int mouhu)
{
//string dpname=FilterClass.DianPu1.UserName.Trim();
int i = 1;
List <memberInfoModel> list = new List <memberInfoModel>();
memberInfoModel model;
SqlParameter[] pms;
string str = "";
switch (tiaojian.Trim())
{
case "姓名":
pms = new SqlParameter[] {
new SqlParameter("@memberName", neirong)
};
if (mouhu == 1)
{
str = "select * from memberInfo where memberName like '%'+@memberName+'%'";
}
else
{
str = "select * from memberInfo where memberName=@memberName";
}
break;
case "卡号":
pms = new SqlParameter[] {
new SqlParameter("@memberCardNo", neirong)
};
if (mouhu == 1)
{
str = "select * from memberInfo where memberCardNo like '%'+@memberCardNo+'%'";
}
else
{
str = "select * from memberInfo where memberCardNo=@memberCardNo";
}
break;
case "电话":
pms = new SqlParameter[] {
new SqlParameter("@memberTel", neirong)
};
if (mouhu == 1)
{
str = "select * from memberInfo where memberTel like '%'+@memberTel+'%'";
}
else
{
str = "select * from memberInfo where memberTel=@memberTel";
}
break;
case "备注":
pms = new SqlParameter[] {
new SqlParameter("@remark", neirong)
};
if (mouhu == 1)
{
str = "select * from memberInfo where remark like '%'+@remark+'%'";
}
else
{
str = "select * from memberInfo where remark=@remark";
}
break;
case "业务员":
pms = new SqlParameter[] {
new SqlParameter("@salesMan", neirong)
};
if (mouhu == 1)
{
str = "select * from memberInfo where salesMan like '%'+@salesMan+'%'";
}
else
{
str = "select * from memberInfo where salesMan=@salesMan";
}
break;
default: pms = new SqlParameter[] {
};
break;
}
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model = new memberInfoModel();
model.memberCardNo = read["memberCardNo"].ToString();
model.memberName = read["memberName"].ToString();
model.memberTel = read["memberTel"].ToString();
model.memberDocument = read["memberDocument"].ToString();
model.birDate = read["birDate"].ToString();
model.cardDate = read["cardDate"].ToString();
model.memberSex = read["memberSex"].ToString();
model.rebate = read["rebate"].ToString();
model.endDate = read["endDate"].ToString();
model.fuwuBate = read["fuwuBate"].ToString();
model.toUpMoney = read["toUpMoney"].ToString();
model.cardMoney = read["cardMoney"].ToString();
model.dianName = read["dianName"].ToString();
model.cardType = read["cardType"].ToString();
model.saleMan = read["salesMan"].ToString();
model.memberType = read["memberType"].ToString();
model.address = read["address"].ToString();
model.remark = read["remark"].ToString();
model.imageUrl = read["imgUrl"].ToString();
model.password = read["password"].ToString();
model.zhuangtai = read["zhuangtai"].ToString();
model.ID = Convert.ToInt32(read["ID"]);
model.idbh = i;
list.Add(model);
i++;
}
}
return(list);
}
//通过ID查询某一张卡的信息
public memberInfoModel SelectId(string card)
{
string dpname = FilterClass.DianPu1.UserName.Trim();
memberInfoModel model = new memberInfoModel();
SqlParameter[] pms;
if (dpname == "admin")
{
pms = new SqlParameter[] {
new SqlParameter("@ID", card)
};
}
else
{
pms = new SqlParameter[] {
new SqlParameter("@ID", card),
//new SqlParameter("@dianName",dpname)
};
}
string str;
if (dpname == "admin")
{
str = "select * from memberInfo where ID=@ID";
}
else
{
str = "select * from memberInfo where ID=@ID";
}
{
}
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model.memberCardNo = read["memberCardNo"].ToString();
model.memberName = read["memberName"].ToString();
model.memberTel = read["memberTel"].ToString();
model.memberDocument = read["memberDocument"].ToString();
model.birDate = read["birDate"].ToString();
model.cardDate = read["cardDate"].ToString();
model.memberSex = read["memberSex"].ToString();
model.rebate = read["rebate"].ToString();
model.endDate = read["endDate"].ToString();
model.fuwuBate = read["fuwuBate"].ToString();
model.toUpMoney = read["toUpMoney"].ToString();
model.cardMoney = read["cardMoney"].ToString();
model.dianName = read["dianName"].ToString();
model.cardType = read["cardType"].ToString();
model.saleMan = read["salesMan"].ToString();
model.memberType = read["memberType"].ToString();
model.address = read["address"].ToString();
model.remark = read["remark"].ToString();
model.imageUrl = read["imgUrl"].ToString();
model.password = read["password"].ToString();
model.zhuangtai = read["zhuangtai"].ToString();
}
}
return(model);
}
private void qdbutton_Click(object sender, EventArgs e)
{
if (hydhtextBox.Text == "" || hykhtextBox.Text == "" || hyxmtextBox.Text == "" || hyxbcomboBox.Text == "" || lsdcomboBox.Text == "")
{
//此处验证的是 要修改的会员卡号 是否是有重复的信息
MessageBox.Show("请将信息填写完整！");
return;
}
else
{
string cardno = hykhtextBox.Text.Trim();
//bool result = modelbll.PDCNumber(cardno);
string id = modelbll.PDCNumberID(cardno);
if (id != "0" && id != modelmember.ID.ToString())
{
DialogResult resu = MessageBox.Show("此卡号已经存在，请更换卡号！", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
return;
}
#region//封装用户填写进去的内容，进行添加
memberInfoModel model = new memberInfoModel();
model.ID = modelmember.ID;
model.memberCardNo = hykhtextBox.Text;
model.memberName = hyxmtextBox.Text;
model.memberTel = hydhtextBox.Text;
model.memberDocument = sfzhtextBox.Text;
model.birDate = TimeGuiGe.TimePicterBegin(csrqdateTimePicker.Text);
model.cardDate = modelmember.cardDate.Trim();
model.memberSex = hyxbcomboBox.Text;
model.rebate = spzktextBox.Text;
if (qydqxzcheckBox.Checked)
{
model.endDate = TimeGuiGe.TimePicterBegin(dateTimePicker1.Text);
}
else
{
model.endDate = TimeGuiGe.TimePicterBegin(dateTimePicker1.Text);
}
model.fuwuBate = fwzktextBox.Text;
model.toUpMoney = czjetextBox.Text;
model.cardMoney = bkjetextBox.Text;
model.dianName = lsdcomboBox.Text;
model.cardType = textBox1.Text;
model.saleMan = ywycomboBox.Text;
model.memberType = hyflcomboBox.Text;
model.address = dwtextBox.Text;
model.remark = bzxxtextBox.Text;
model.zhuangtai = ztcomboBox.Text;
if (qyhymmcheckBox.Checked && password != "0")
{
model.password = password;
}
Bitmap newImage = new Bitmap(160, 120);
Graphics draw = Graphics.FromImage(newImage);
if (bitmap != null)
{
draw.DrawImage(bitmap, 0, 0);
draw.Dispose();
string dirpath = "memberInfo";
if (!Directory.Exists(dirpath))
{
Directory.CreateDirectory(dirpath);
}
string path = dirpath + "\\" + hykhtextBox.Text.Trim() + ".bmp";
if (newImage != null)
{
newImage.Save(path, System.Drawing.Imaging.ImageFormat.Bmp);
}
model.imageUrl = path;
}
else
{
model.imageUrl = pictureBox1.ImageLocation;
}
bool result = modelbll.EditMemberInfo(model);
if (result)
{
MessageBox.Show("修改成功！");
this.Close();
}
else
{
MessageBox.Show("修改失败，请稍后再试！");
}
#endregion
}
}
private void qdbutton_Click(object sender, EventArgs e)
{
if (hydhtextBox.Text == "" || hykhtextBox.Text == "" || hyxmtextBox.Text == "" || hyxbcomboBox.Text == "" || lsdcomboBox.Text == "")
{
MessageBox.Show("请将信息填写完整！");
return;
}
else
{
#region//封装用户填写进去的内容，进行添加
memberInfoModel model = new memberInfoModel();
model.memberCardNo = hykhtextBox.Text;
model.memberName = hyxmtextBox.Text;
model.PY = PinYinZHClass.PinYinZH(hyxmtextBox.Text.Trim());
model.memberTel = hydhtextBox.Text;
model.memberDocument = sfzhtextBox.Text;
model.birDate = TimeGuiGe.TimePicterBegin(csrqdateTimePicker.Text);
model.cardDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.memberSex = hyxbcomboBox.Text;
model.rebate = spzktextBox.Text;
if (qydqxzcheckBox.Checked)
{
model.endDate = TimeGuiGe.TimePicterBegin(dateTimePicker1.Text);
}
else
{
model.endDate = TimeGuiGe.TimePicterBegin(dateTimePicker1.Text);
}
model.fuwuBate = fwzktextBox.Text;
model.toUpMoney = czjetextBox.Text;
model.cardMoney = bkjetextBox.Text;
model.dianName = lsdcomboBox.Text;
model.cardType = textBox1.Text;
model.saleMan = ywycomboBox.Text == "" ? FilterClass.DianPu1.LoginName : ywycomboBox.Text;
model.memberType = hyflcomboBox.Text;
model.address = dwtextBox.Text;
model.remark = bzxxtextBox.Text;
model.zhuangtai = ztcomboBox.Text;
if (qyhymmcheckBox.Checked)
{
model.password = password;
}
#region//过程
//SaveFileDialog filedialog = new SaveFileDialog();
//System.Drawing.Imaging.Encoder myEncoder = System.Drawing.Imaging.Encoder.Quality;
//ImageCodecInfo myImageCodecInfo = GetEncoderInfo("image/jpeg");
//EncoderParameter myEncoderParameter = myEncoderParameter = new EncoderParameter(myEncoder, 25L);
//EncoderParameters myEncoderParameters = new EncoderParameters(1);
//myEncoderParameters.Param[0] = myEncoderParameter;
//bitmap.Save(Application.StartupPath + "/a.jpeg", myImageCodecInfo, myEncoderParameters);
/////////
//Bitmap newbit = new Bitmap(100, 100);
//Graphics smg = Graphics.FromImage(newbit);
//if (bitmap == null)
//{
// MessageBox.Show("空的");
//}
//smg.DrawImage((Image)bitmap, 0, 0, 100, 100);
//string path = Application.StartupPath+"\\a.Png";
//newbit.Save(path);
//if (!Directory.Exists(dirpath))
// Directory.CreateDirectory(dirpath);
#endregion
Bitmap newImage = new Bitmap(160, 120);
Graphics draw = Graphics.FromImage(newImage);
//if (bitmap == null)
//{
// MessageBox.Show("请采集照片！");
// return;
//}
string dirpath = "";
string path = "";
if (bitmap != null)
{
draw.DrawImage(bitmap, 0, 0);
draw.Dispose();
dirpath = "memberInfo";
if (!Directory.Exists(dirpath))
{
Directory.CreateDirectory(dirpath);
}
path = dirpath + "\\" + hykhtextBox.Text.Trim() + ".bmp";
if (newImage != null)
{
newImage.Save(path, System.Drawing.Imaging.ImageFormat.Bmp);
}
}
model.imageUrl = path;
string name = hyxmtextBox.Text.Trim();
//为true的时候为不存在
bool result = modelbll.PDHYName(name);
if (!result)
{
DialogResult resu = MessageBox.Show("已经存在当前姓名，是否继续添加？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (resu == DialogResult.Cancel)
{
return;
}
}
//为true的时候为不存在
result = modelbll.PDCNumber(hykhtextBox.Text);
if (!result)
{
DialogResult resu = MessageBox.Show("此卡号已经存在，请更换卡号！", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
return;
}
result = modelbll.AddMemberInfo(model);
if (result)
{
MessageBox.Show("添加成功！");
if (checkBox3.Checked)
{
hyxmtextBox.Text = "";
hykhtextBox.Text = "";
hydhtextBox.Text = "";
sfzhtextBox.Text = "";
ywycomboBox.SelectedIndex = 0;
dwtextBox.Text = "";
bzxxtextBox.Text = "";
}
else
{
this.Close();
}
}
else
{
MessageBox.Show("添加失败，请稍后再试！");
}
#endregion
}
}
/// <summary>
/// 统计报表中的办卡统计方法
/// </summary>
/// <param name="yginfo">查看某一个员工还是所有员工如果admin登陆则所有的店铺的信息均能看到
/// <returns></returns>
public List <memberInfoModel> tjbbOfbk(string begindate, string enddate, string dpname)
{
List <memberInfoModel> list = new List <memberInfoModel>();
memberInfoModel model;
string dpinfo = FilterClass.DianPu1.UserName.Trim();
string str = "";
SqlParameter[] pms;
if (dpinfo == "admin")
{
if (dpname == "全部")
{
str = "select * from memberInfo where cardDate between '" + begindate + "' and '" + enddate + "'";
pms = new SqlParameter[] { };
}
else
{
str = "select * from memberInfo where dianName=@dianName and cardDate between '" + begindate + "' and '" + enddate + "'";
pms = new SqlParameter[] {
new SqlParameter("@dianName", dpname)
};
}
}
else
{
str = "select * from memberInfo where dianName=@dianName and cardDate between '" + begindate + "' and '" + enddate + "'";
pms = new SqlParameter[] {
new SqlParameter("@dianName", dpinfo)
};
}
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model = new memberInfoModel();
model.memberCardNo = read["memberCardNo"].ToString();
model.memberName = read["memberName"].ToString();
model.memberTel = read["memberTel"].ToString();
model.memberDocument = read["memberDocument"].ToString();
model.birDate = read["birDate"].ToString();
model.cardDate = read["cardDate"].ToString();
model.memberSex = read["memberSex"].ToString();
model.rebate = read["rebate"].ToString();
model.endDate = read["endDate"].ToString();
model.fuwuBate = read["fuwuBate"].ToString();
model.toUpMoney = read["toUpMoney"].ToString();
model.cardMoney = read["cardMoney"].ToString();
model.dianName = read["dianName"].ToString();
model.cardType = read["cardType"].ToString();
model.saleMan = read["salesMan"].ToString();
model.memberType = read["memberType"].ToString();
model.address = read["address"].ToString();
model.remark = read["remark"].ToString();
model.imageUrl = read["imgUrl"].ToString();
model.password = read["password"].ToString();
model.zhuangtai = read["zhuangtai"].ToString();
list.Add(model);
}
}
return(list);
}
