public Boolean addImg_D(ContactUsers cu, string id)
{
int count = 0;
byte[] imagebytes = null;
Image photo = new Bitmap(cu.User_img);
MemoryStream ms = new MemoryStream();
photo.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
imagebytes = ms.GetBuffer();
//打开数据库
using (OleDbConnection olconn = new OleDbConnection(connStr))
{
olconn.Open();
OleDbCommand olcmd = new OleDbCommand(string.Format("update Contact_Users set User_Img=@User_Img where ID={0}", id), olconn);
olcmd.Parameters.Add("User_Img", SqlDbType.Image);
olcmd.Parameters["User_Img"].Value = imagebytes;
count = olcmd.ExecuteNonQuery();
if (count == 1)
{
return(true);
}
else
{
return(false);
}
}
}
//更新联系人信息
public Boolean addUserorUpdateUser_D(ContactUsers cus, string id)
{
try
{
using (OleDbConnection olconn = new OleDbConnection(connStr))
{
olconn.Open();
string sql = string.Format("update Contact_Users set User_Name='{0}',User_Sex='{1}',User_Age='{2}',User_Birth='{3}',User_Phone='{4}',User_Qq='{5}',User_Company='{6}',User_Address='{7}',User_Remark='{8}' where ID={9}", cus.User_name, cus.User_sex, cus.User_age, cus.User_birth, cus.User_phone, cus.User_qq, cus.User_company, cus.User_address, cus.User_remark, id);
OleDbCommand olcmd = new OleDbCommand(sql, olconn);
int count = olcmd.ExecuteNonQuery();
if (count == 1)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + @"--------------------建议：尽量不要使用英文单引号：''", "特殊字符转义异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
//添加头像
public Boolean addImg_B(ContactUsers cu, string id)
{
if (scd.addImg_D(cu, id))
{
return(true);
}
else
{
return(false);
}
}
//修改用户数据
public Boolean addUserorUpdateUser_B(ContactUsers cus, string id)
{
if (scd.addUserorUpdateUser_D(cus, id))
{
return(true);
}
else
{
return(false);
}
}
public Boolean addUsers_B(ContactUsers cu, Boolean isImg)
{
if (mftd.addUser_D(cu, isImg))
{
return(true);
}
else
{
return(false);
}
}
//添加联系人
public Boolean addUser_D(ContactUsers cu, Boolean isImg)
{
string connStr = string.Format(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Application.StartupPath + @"\source\StuContact.mdb;Jet OLEDB:Database Password={0}", config.readConfig_ReadPwd());
if (isImg)
{
int count = 0;
byte[] imagebytes = null;
Image photo = new Bitmap(cu.User_img);
MemoryStream ms = new MemoryStream();
photo.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
imagebytes = ms.GetBuffer();
using (OleDbConnection olconn = new OleDbConnection(connStr))
{
olconn.Open();
string sql = string.Format("insert into Contact_Users(User_Name,User_Img,User_Sex,User_Age,User_Birth,User_Phone,User_Qq,User_Company,User_Address,User_Remark,User_BelongGroup) values(@User_Name,@User_Img,@User_Sex,@User_Age,@User_Birth,@User_Phone,@User_Qq,@User_Company,@User_Address,@User_Remark,@User_BelongGroup)");
OleDbCommand olcmd = new OleDbCommand(sql, olconn);
olcmd.Parameters.Add("User_Name", OleDbType.VarChar);
olcmd.Parameters["User_Name"].Value = cu.User_name;
olcmd.Parameters.Add("User_Img", OleDbType.Binary);
olcmd.Parameters["User_Img"].Value = imagebytes;
olcmd.Parameters.Add("User_Sex", OleDbType.VarChar);
olcmd.Parameters["User_Sex"].Value = cu.User_sex;
olcmd.Parameters.Add("User_Age", OleDbType.VarChar);
olcmd.Parameters["User_Age"].Value = cu.User_age;
olcmd.Parameters.Add("User_Birth", OleDbType.VarChar);
olcmd.Parameters["User_Birth"].Value = cu.User_birth;
olcmd.Parameters.Add("User_Phone", OleDbType.VarChar);
olcmd.Parameters["User_Phone"].Value = cu.User_phone;
olcmd.Parameters.Add("User_Qq", OleDbType.VarChar);
olcmd.Parameters["User_Qq"].Value = cu.User_qq;
olcmd.Parameters.Add("User_Company", OleDbType.VarChar);
olcmd.Parameters["User_Company"].Value = cu.User_company;
olcmd.Parameters.Add("User_Address", OleDbType.VarChar);
olcmd.Parameters["User_Address"].Value = cu.User_address;
olcmd.Parameters.Add("User_Remark", OleDbType.VarChar);
olcmd.Parameters["User_Remark"].Value = cu.User_remark;
olcmd.Parameters.Add("User_BelongGroup", OleDbType.VarChar);
olcmd.Parameters["User_BelongGroup"].Value = cu.User_belonggroup;
count = olcmd.ExecuteNonQuery();
if (count == 1)
{
return(true);
}
else
{
return(false);
}
}
}
else//不保存图片
{
using (OleDbConnection olconn = new OleDbConnection(connStr))
{
olconn.Open();
string sql = string.Format("insert into Contact_Users(User_Name,User_Sex,User_Age,User_Birth,User_Phone,User_Qq,User_Company,User_Address,User_Remark,User_BelongGroup) values(@User_Name,@User_Sex,@User_Age,@User_Birth,@User_Phone,@User_Qq,@User_Company,@User_Address,@User_Remark,@User_BelongGroup)");
OleDbCommand olcmd = new OleDbCommand(sql, olconn);
olcmd.Parameters.Add("User_Name", OleDbType.VarChar);
olcmd.Parameters["User_Name"].Value = cu.User_name;
olcmd.Parameters.Add("User_Sex", OleDbType.VarChar);
olcmd.Parameters["User_Sex"].Value = cu.User_sex;
olcmd.Parameters.Add("User_Age", OleDbType.VarChar);
olcmd.Parameters["User_Age"].Value = cu.User_age;
olcmd.Parameters.Add("User_Birth", OleDbType.VarChar);
olcmd.Parameters["User_Birth"].Value = cu.User_birth;
olcmd.Parameters.Add("User_Phone", OleDbType.VarChar);
olcmd.Parameters["User_Phone"].Value = cu.User_phone;
olcmd.Parameters.Add("User_Qq", OleDbType.VarChar);
olcmd.Parameters["User_Qq"].Value = cu.User_qq;
olcmd.Parameters.Add("User_Company", OleDbType.VarChar);
olcmd.Parameters["User_Company"].Value = cu.User_company;
olcmd.Parameters.Add("User_Address", OleDbType.VarChar);
olcmd.Parameters["User_Address"].Value = cu.User_address;
olcmd.Parameters.Add("User_Remark", OleDbType.VarChar);
olcmd.Parameters["User_Remark"].Value = cu.User_remark;
olcmd.Parameters.Add("User_BelongGroup", OleDbType.VarChar);
olcmd.Parameters["User_BelongGroup"].Value = cu.User_belonggroup;
count = olcmd.ExecuteNonQuery();
if (count >= 1)
{
return(true);
}
else
{
return(false);
}
}
}
}
Boolean flag = false;//标识用户是否选择了头像
private void button1_Click(object sender, EventArgs e)
{
//姓名、所属分组不能为空
if (txtName.Text == "")
{
MessageBox.Show("还没有输入姓名！最少要输入姓名、手机号和所属分组", "操作提示");
}
#region
//else if (txtAge.Text == "")
// MessageBox.Show("请输入年龄！");
//else if (txtBirth.Text == "")
// MessageBox.Show("请输入生日！");
//else if (txtPhone.Text == "")
// MessageBox.Show("请输入手机号码！");
//else if (txtQQ.Text == "")
// MessageBox.Show("请输入qq号码！");
//else if (txtAddress.Text == "")
// MessageBox.Show("请输入地址！");
#endregion
else if (txtPhone.Text.Trim() == "")
{
MessageBox.Show("输入联系人号码！", "操作提示");
}
else if (radioSex_1.Checked == false && radioSex_2.Checked == false)
{
MessageBox.Show("请选择性别！", "操作提示");
}
//else if (radioSex_2.Checked == false)
// MessageBox.Show("请选择性别！", "操作提示");
else if (comGroup.Text == "")
{
MessageBox.Show("请选择该联系人所属分组！", "操作提示");
}
else
{
//开始添加保存
ContactUsers cu = new ContactUsers();
cu.User_name = txtName.Text.Trim();
if (flag)
{
cu.User_img = pictureBox1.Image;
}
else
{
cu.User_img = null;
}
if (radioSex_1.Checked)
{
cu.User_sex = "男";
}
if (radioSex_2.Checked)
{
cu.User_sex = "女";
}
cu.User_age = txtAge.Text.Trim();
cu.User_birth = txtBirth.Text.Trim();
cu.User_phone = txtPhone.Text.Trim();
cu.User_qq = txtQQ.Text.Trim();
cu.User_company = txtCompany.Text.Trim();
cu.User_address = txtAddress.Text.Trim();
if (txtRemark.Text == "在这里面写上你对该联系人的一些描述，是您对该联系人的情况了解更多.....")
{
cu.User_remark = "";
}
else
{
cu.User_remark = txtRemark.Text.Trim();
}
//首先应该获取所选分组的ID
cu.User_belonggroup = mftd.getUserGroupID_D(comGroup.SelectedItem.ToString());
addUsersForm_B aufb = new addUsersForm_B();
if (aufb.addUsers_B(cu, flag))//flag代表是否有头像，方便判断
{
if (MessageBox.Show("添加成功！是否继续添加?", "添加提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.Cancel)
{
this.Hide();
}
else
{
txtAddress.Text = ""; txtAge.Text = ""; txtBirth.Text = ""; txtCompany.Text = "";
txtName.Text = ""; txtPhone.Text = ""; txtQQ.Text = ""; txtRemark.Text = "";
}
}
else
{
MessageBox.Show("添加失败", "添加提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
