private void btnOK_Click(object sender, EventArgs e)
{
if (CheckUserInput())
{
Express.Model.CustomerInfo model = new Express.Model.CustomerInfo();
model.Address = txtAddress.Text;
model.contactperson = txtContractUser.Text;
model.contactphone = txtContractTel.Text;
model.CState = cbCstate.SelectedIndex;
model.cusname = txtCusName.Text;
model.departmentname = txtOrgName.Text;
model.OperUser3 = ClientInfo.Sys_UserInfo.username;
model.Remark = txtRemark.Text;
model.UserDate3 = DateTime.Now;
string msg = "";
if (null == btnOK.Tag)
{
bool isSuc = new Express.BLL.CustomerInfo().Add(model);
msg = isSuc ? "添加客户信息成功!" : "添加客户信息失败!";
}
else
{
model.cid = Convert.ToInt32(btnOK.Tag);
bool isSuc = new Express.BLL.CustomerInfo().Update(model);
msg = isSuc ? "修改客户信息成功!" : "修改客户信息失败!";
}
MessageBox.Show(msg, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (ClientInfo.Sys_UserInfo.username.ToLower() == "admin")
{
if (ClientInfo.Sys_UserInfo.pass == Express.Common.DEncrypt.DESEncrypt.Encrypt(txtPass.Text))
{
try
{
string path = SaveFile();
if (!string.IsNullOrEmpty(path))
{
if (Express.Common.AccessManager.Backup(Application.StartupPath + @"\\dbms.datb", path))
{
string msg = new Express.BLL.SysSetInfo().FormateData(Power)?"格式化数据成功!":"格式化数据失败";
MessageBox.Show(msg, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Express.Model.CustomerInfo model = new Express.Model.CustomerInfo();
model.Address = "无";
model.contactperson = "无";
model.contactphone = "88888888";
model.CState = 0;
model.cusname = "系统默认";
model.departmentname = "系统默认";
model.OperUser3 = ClientInfo.Sys_UserInfo.username;
model.Remark = "";
model.UserDate3 = DateTime.Now;
new Express.BLL.CustomerInfo().Add(model);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("备份数据库失败！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("密码输入有误，请重新输入密码！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("你不能进行该操作，该操作只能超级管理员可以进行操作！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Express.Model.CustomerInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CustomerInfo set ");
strSql.Append("cusname=@cusname,");
strSql.Append("departmentname=@departmentname,");
strSql.Append("Address=@Address,");
strSql.Append("contactperson=@contactperson,");
strSql.Append("contactphone=@contactphone,");
strSql.Append("Remark=@Remark,");
strSql.Append("OperUser3=@OperUser3,");
strSql.Append("UserDate3=@UserDate3,");
strSql.Append("CState=@CState");
strSql.Append(" where cid=@cid");
OleDbParameter[] parameters =
{
new OleDbParameter("@cusname", OleDbType.VarChar, 10),
new OleDbParameter("@departmentname", OleDbType.VarChar, 20),
new OleDbParameter("@Address", OleDbType.VarChar, 200),
new OleDbParameter("@contactperson", OleDbType.VarChar, 10),
new OleDbParameter("@contactphone", OleDbType.VarChar, 30),
new OleDbParameter("@Remark", OleDbType.VarChar, 100),
new OleDbParameter("@OperUser3", OleDbType.VarChar, 20),
new OleDbParameter("@UserDate3", OleDbType.Date),
new OleDbParameter("@CState", OleDbType.Integer, 4),
new OleDbParameter("@cid", OleDbType.Integer, 4)
};
parameters[0].Value = model.cusname;
parameters[1].Value = model.departmentname;
parameters[2].Value = model.Address;
parameters[3].Value = model.contactperson;
parameters[4].Value = model.contactphone;
parameters[5].Value = model.Remark;
parameters[6].Value = model.OperUser3;
parameters[7].Value = model.UserDate3;
parameters[8].Value = model.CState;
parameters[9].Value = model.cid;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Express.Model.CustomerInfo DataRowToModel(DataRow row)
{
Express.Model.CustomerInfo model = new Express.Model.CustomerInfo();
if (row != null)
{
if (row["cid"] != null && row["cid"].ToString() != "")
{
model.cid = int.Parse(row["cid"].ToString());
}
if (row["cusname"] != null)
{
model.cusname = row["cusname"].ToString();
}
if (row["departmentname"] != null)
{
model.departmentname = row["departmentname"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["contactperson"] != null)
{
model.contactperson = row["contactperson"].ToString();
}
if (row["contactphone"] != null)
{
model.contactphone = row["contactphone"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["OperUser3"] != null)
{
model.OperUser3 = row["OperUser3"].ToString();
}
if (row["UserDate3"] != null && row["UserDate3"].ToString() != "")
{
model.UserDate3 = DateTime.Parse(row["UserDate3"].ToString());
}
if (row["CState"] != null && row["CState"].ToString() != "")
{
model.CState = int.Parse(row["CState"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Express.Model.CustomerInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CustomerInfo(");
strSql.Append("cusname,departmentname,Address,contactperson,contactphone,Remark,OperUser3,UserDate3,CState)");
strSql.Append(" values (");
strSql.Append("@cusname,@departmentname,@Address,@contactperson,@contactphone,@Remark,@OperUser3,@UserDate3,@CState)");
OleDbParameter[] parameters =
{
new OleDbParameter("@cusname", OleDbType.VarChar, 10),
new OleDbParameter("@departmentname", OleDbType.VarChar, 20),
new OleDbParameter("@Address", OleDbType.VarChar, 200),
new OleDbParameter("@contactperson", OleDbType.VarChar, 10),
new OleDbParameter("@contactphone", OleDbType.VarChar, 30),
new OleDbParameter("@Remark", OleDbType.VarChar, 100),
new OleDbParameter("@OperUser3", OleDbType.VarChar, 20),
new OleDbParameter("@UserDate3", OleDbType.Date),
new OleDbParameter("@CState", OleDbType.Integer, 4)
};
parameters[0].Value = model.cusname;
parameters[1].Value = model.departmentname;
parameters[2].Value = model.Address;
parameters[3].Value = model.contactperson;
parameters[4].Value = model.contactphone;
parameters[5].Value = model.Remark;
parameters[6].Value = model.OperUser3;
parameters[7].Value = model.UserDate3;
parameters[8].Value = model.CState;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Express.Model.CustomerInfo GetModel(int cid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select cid,cusname,departmentname,Address,contactperson,contactphone,Remark,OperUser3,UserDate3,CState from CustomerInfo ");
strSql.Append(" where cid=@cid");
OleDbParameter[] parameters =
{
new OleDbParameter("@cid", OleDbType.Integer, 4)
};
parameters[0].Value = cid;
Express.Model.CustomerInfo model = new Express.Model.CustomerInfo();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}