/// <summary>
/// 保存按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
if (CheckData())
{
AccountInfo accountInfo = new AccountInfo();
try
{
accountInfo.UserName = txtUserName.Text;
accountInfo.Title = txtTitle.Text;
accountInfo.DisplayPW = txtUserPassWord.Text;
accountInfo.WebUrl = txtWebUrl.Text;
accountInfo.Email = txtEmail.Text;
accountInfo.Remark = txtRemark.Text;
accountInfo.RegistTime = DateTime.Now;
accountInfo.EncryptType = string.Empty;
bool result = false;
if (string.IsNullOrEmpty(id))
{
result = ubll.Add(accountInfo);
}
else
{
accountInfo.ID = int.Parse(id);
result = ubll.Update(accountInfo);
}
this.DialogResult = System.Windows.Forms.DialogResult.OK;
callBackFunc(result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public AccountInfo DataRowToModel(DataRow row)
{
AccountInfo model = new AccountInfo();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["UserPassWord"] != null)
{
model.UserPassWord = row["UserPassWord"].ToString();
}
if (row["WebUrl"] != null)
{
model.WebUrl = row["WebUrl"].ToString();
}
if (row["Email"] != null)
{
model.Email = row["Email"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["EncryptType"] != null)
{
model.EncryptType = row["EncryptType"].ToString();
}
if (row["RegistTime"] != null && row["RegistTime"].ToString() != "")
{
model.RegistTime = DateTime.Parse(row["RegistTime"].ToString());
}
if (row["ClassID"] != null && row["ClassID"].ToString() != "")
{
model.ClassID = int.Parse(row["ClassID"].ToString());
}
}
return model;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(AccountInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AccountInfo(");
strSql.Append("Title,UserName,UserPassWord,WebUrl,Email,Remark,EncryptType,RegistTime,ClassID)");
strSql.Append(" values (");
strSql.Append("@Title,@UserName,@UserPassWord,@WebUrl,@Email,@Remark,@EncryptType,@RegistTime,@ClassID)");
OleDbParameter[] parameters = {
new OleDbParameter("@Title", OleDbType.VarChar,255),
new OleDbParameter("@UserName", OleDbType.VarChar,255),
new OleDbParameter("@UserPassWord", OleDbType.VarChar,255),
new OleDbParameter("@WebUrl", OleDbType.VarChar,255),
new OleDbParameter("@Email", OleDbType.VarChar,255),
new OleDbParameter("@Remark", OleDbType.VarChar,255),
new OleDbParameter("@EncryptType", OleDbType.VarChar,255),
new OleDbParameter("@RegistTime", OleDbType.Date),
new OleDbParameter("@ClassID", OleDbType.Integer,4)};
parameters[0].Value = model.Title;
parameters[1].Value = model.UserName;
parameters[2].Value = model.UserPassWord;
parameters[3].Value = model.WebUrl;
parameters[4].Value = model.Email;
parameters[5].Value = model.Remark;
parameters[6].Value = model.EncryptType;
parameters[7].Value = model.RegistTime;
parameters[8].Value = model.ClassID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AccountInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AccountInfo set ");
strSql.Append("Title=@Title,");
strSql.Append("UserName=@UserName,");
strSql.Append("UserPassWord=@UserPassWord,");
strSql.Append("WebUrl=@WebUrl,");
strSql.Append("Email=@Email,");
strSql.Append("Remark=@Remark,");
strSql.Append("EncryptType=@EncryptType,");
strSql.Append("RegistTime=@RegistTime,");
strSql.Append("ClassID=@ClassID");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters = {
new OleDbParameter("@Title", OleDbType.VarChar,255),
new OleDbParameter("@UserName", OleDbType.VarChar,255),
new OleDbParameter("@UserPassWord", OleDbType.VarChar,255),
new OleDbParameter("@WebUrl", OleDbType.VarChar,255),
new OleDbParameter("@Email", OleDbType.VarChar,255),
new OleDbParameter("@Remark", OleDbType.VarChar,255),
new OleDbParameter("@EncryptType", OleDbType.VarChar,255),
new OleDbParameter("@RegistTime", OleDbType.Date),
new OleDbParameter("@ClassID", OleDbType.Integer,4),
new OleDbParameter("@ID", OleDbType.Integer,4)};
parameters[0].Value = model.Title;
parameters[1].Value = model.UserName;
parameters[2].Value = model.UserPassWord;
parameters[3].Value = model.WebUrl;
parameters[4].Value = model.Email;
parameters[5].Value = model.Remark;
parameters[6].Value = model.EncryptType;
parameters[7].Value = model.RegistTime;
parameters[8].Value = model.ClassID;
parameters[9].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public AccountInfo GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,Title,UserName,UserPassWord,WebUrl,Email,Remark,EncryptType,RegistTime,ClassID from AccountInfo ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters = {
new OleDbParameter("@ID", OleDbType.Integer,4)
};
parameters[0].Value = ID;
AccountInfo model = new AccountInfo();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(AccountInfo model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AccountInfo model)
{
return dal.Update(model);
}
/// <summary>
/// 删除按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDel_Click(object sender, EventArgs e)
{
List<string> delList = new List<string>();
for (int i = 0; i < dgvInfos.Rows.Count; i++)
{
if (Convert.ToBoolean(dgvInfos.Rows[i].Cells["cb"].Value))//刚发现
{
delList.Add(dgvInfos.Rows[i].Cells["id"].Value.ToString());
}
}
if (delList.Count > 0)
{
if (MessageBox.Show(this, "您确定要删除选择的账号信息吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No) return;
AccountInfoBLL bll = new AccountInfoBLL();
AccountInfo accountInfo = new AccountInfo();
bll.DeleteList(string.Join(",", delList.ToArray()));
Search();
}
}
