/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Bsam.Core.Model.Models.Model.PasswordLib model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PasswordLib set ");
strSql.Append("IsDeleted=@IsDeleted,");
strSql.Append("plURL=@plURL,");
strSql.Append("plPWD=@plPWD,");
strSql.Append("plAccountName=@plAccountName,");
strSql.Append("plStatus=@plStatus,");
strSql.Append("plErrorCount=@plErrorCount,");
strSql.Append("plHintPwd=@plHintPwd,");
strSql.Append("plHintquestion=@plHintquestion,");
strSql.Append("plCreateTime=@plCreateTime,");
strSql.Append("plUpdateTime=@plUpdateTime,");
strSql.Append("plLastErrTime=@plLastErrTime,");
strSql.Append("test=@test");
strSql.Append(" where PLID=@PLID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@IsDeleted", DbType.bit, 1),
new SQLiteParameter("@plURL", DbType.String),
new SQLiteParameter("@plPWD", DbType.String),
new SQLiteParameter("@plAccountName", DbType.String),
new SQLiteParameter("@plStatus", DbType.Int32, 8),
new SQLiteParameter("@plErrorCount", DbType.Int32, 8),
new SQLiteParameter("@plHintPwd", DbType.String),
new SQLiteParameter("@plHintquestion", DbType.String),
new SQLiteParameter("@plCreateTime", DbType.DateTime),
new SQLiteParameter("@plUpdateTime", DbType.DateTime),
new SQLiteParameter("@plLastErrTime", DbType.DateTime),
new SQLiteParameter("@test", DbType.String),
new SQLiteParameter("@PLID", DbType.Int32, 8)
};
parameters[0].Value = model.IsDeleted;
parameters[1].Value = model.plURL;
parameters[2].Value = model.plPWD;
parameters[3].Value = model.plAccountName;
parameters[4].Value = model.plStatus;
parameters[5].Value = model.plErrorCount;
parameters[6].Value = model.plHintPwd;
parameters[7].Value = model.plHintquestion;
parameters[8].Value = model.plCreateTime;
parameters[9].Value = model.plUpdateTime;
parameters[10].Value = model.plLastErrTime;
parameters[11].Value = model.test;
parameters[12].Value = model.PLID;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Bsam.Core.Model.Models.Model.PasswordLib model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PasswordLib(");
strSql.Append("IsDeleted,plURL,plPWD,plAccountName,plStatus,plErrorCount,plHintPwd,plHintquestion,plCreateTime,plUpdateTime,plLastErrTime,test)");
strSql.Append(" values (");
strSql.Append("@IsDeleted,@plURL,@plPWD,@plAccountName,@plStatus,@plErrorCount,@plHintPwd,@plHintquestion,@plCreateTime,@plUpdateTime,@plLastErrTime,@test)");
strSql.Append(";select LAST_INSERT_ROWID()");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@IsDeleted", DbType.bit, 1),
new SQLiteParameter("@plURL", DbType.String),
new SQLiteParameter("@plPWD", DbType.String),
new SQLiteParameter("@plAccountName", DbType.String),
new SQLiteParameter("@plStatus", DbType.Int32, 8),
new SQLiteParameter("@plErrorCount", DbType.Int32, 8),
new SQLiteParameter("@plHintPwd", DbType.String),
new SQLiteParameter("@plHintquestion", DbType.String),
new SQLiteParameter("@plCreateTime", DbType.DateTime),
new SQLiteParameter("@plUpdateTime", DbType.DateTime),
new SQLiteParameter("@plLastErrTime", DbType.DateTime),
new SQLiteParameter("@test", DbType.String)
};
parameters[0].Value = model.IsDeleted;
parameters[1].Value = model.plURL;
parameters[2].Value = model.plPWD;
parameters[3].Value = model.plAccountName;
parameters[4].Value = model.plStatus;
parameters[5].Value = model.plErrorCount;
parameters[6].Value = model.plHintPwd;
parameters[7].Value = model.plHintquestion;
parameters[8].Value = model.plCreateTime;
parameters[9].Value = model.plUpdateTime;
parameters[10].Value = model.plLastErrTime;
parameters[11].Value = model.test;
object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void ShowInfo(int PLID)
{
Bsam.Core.Model.Models.BLL.PasswordLib bll = new Bsam.Core.Model.Models.BLL.PasswordLib();
Bsam.Core.Model.Models.Model.PasswordLib model = bll.GetModel(PLID);
this.lblPLID.Text = model.PLID.ToString();
this.lblIsDeleted.Text = model.IsDeleted?"是":"否";
this.lblplURL.Text = model.plURL;
this.lblplPWD.Text = model.plPWD;
this.lblplAccountName.Text = model.plAccountName;
this.lblplStatus.Text = model.plStatus.ToString();
this.lblplErrorCount.Text = model.plErrorCount.ToString();
this.lblplHintPwd.Text = model.plHintPwd;
this.lblplHintquestion.Text = model.plHintquestion;
this.lblplCreateTime.Text = model.plCreateTime.ToString();
this.lblplUpdateTime.Text = model.plUpdateTime.ToString();
this.lblplLastErrTime.Text = model.plLastErrTime.ToString();
this.lbltest.Text = model.test;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.PasswordLib GetModel(int PLID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select PLID,IsDeleted,plURL,plPWD,plAccountName,plStatus,plErrorCount,plHintPwd,plHintquestion,plCreateTime,plUpdateTime,plLastErrTime,test from PasswordLib ");
strSql.Append(" where PLID=@PLID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@PLID", DbType.Int32, 4)
};
parameters[0].Value = PLID;
Bsam.Core.Model.Models.Model.PasswordLib model = new Bsam.Core.Model.Models.Model.PasswordLib();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtplURL.Text.Trim().Length == 0)
{
strErr += "plURL不能为空！\\n";
}
if (this.txtplPWD.Text.Trim().Length == 0)
{
strErr += "plPWD不能为空！\\n";
}
if (this.txtplAccountName.Text.Trim().Length == 0)
{
strErr += "plAccountName不能为空！\\n";
}
if (!PageValidate.IsNumber(txtplStatus.Text))
{
strErr += "plStatus格式错误！\\n";
}
if (!PageValidate.IsNumber(txtplErrorCount.Text))
{
strErr += "plErrorCount格式错误！\\n";
}
if (this.txtplHintPwd.Text.Trim().Length == 0)
{
strErr += "plHintPwd不能为空！\\n";
}
if (this.txtplHintquestion.Text.Trim().Length == 0)
{
strErr += "plHintquestion不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtplCreateTime.Text))
{
strErr += "plCreateTime格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtplUpdateTime.Text))
{
strErr += "plUpdateTime格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtplLastErrTime.Text))
{
strErr += "plLastErrTime格式错误！\\n";
}
if (this.txttest.Text.Trim().Length == 0)
{
strErr += "test不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
bool IsDeleted = this.chkIsDeleted.Checked;
string plURL = this.txtplURL.Text;
string plPWD = this.txtplPWD.Text;
string plAccountName = this.txtplAccountName.Text;
int plStatus = int.Parse(this.txtplStatus.Text);
int plErrorCount = int.Parse(this.txtplErrorCount.Text);
string plHintPwd = this.txtplHintPwd.Text;
string plHintquestion = this.txtplHintquestion.Text;
DateTime plCreateTime = DateTime.Parse(this.txtplCreateTime.Text);
DateTime plUpdateTime = DateTime.Parse(this.txtplUpdateTime.Text);
DateTime plLastErrTime = DateTime.Parse(this.txtplLastErrTime.Text);
string test = this.txttest.Text;
Bsam.Core.Model.Models.Model.PasswordLib model = new Bsam.Core.Model.Models.Model.PasswordLib();
model.IsDeleted = IsDeleted;
model.plURL = plURL;
model.plPWD = plPWD;
model.plAccountName = plAccountName;
model.plStatus = plStatus;
model.plErrorCount = plErrorCount;
model.plHintPwd = plHintPwd;
model.plHintquestion = plHintquestion;
model.plCreateTime = plCreateTime;
model.plUpdateTime = plUpdateTime;
model.plLastErrTime = plLastErrTime;
model.test = test;
Bsam.Core.Model.Models.BLL.PasswordLib bll = new Bsam.Core.Model.Models.BLL.PasswordLib();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.PasswordLib DataRowToModel(DataRow row)
{
Bsam.Core.Model.Models.Model.PasswordLib model = new Bsam.Core.Model.Models.Model.PasswordLib();
if (row != null)
{
if (row["PLID"] != null && row["PLID"].ToString() != "")
{
model.PLID = int.Parse(row["PLID"].ToString());
}
if (row["IsDeleted"] != null && row["IsDeleted"].ToString() != "")
{
if ((row["IsDeleted"].ToString() == "1") || (row["IsDeleted"].ToString().ToLower() == "true"))
{
model.IsDeleted = true;
}
else
{
model.IsDeleted = false;
}
}
if (row["plURL"] != null)
{
model.plURL = row["plURL"].ToString();
}
if (row["plPWD"] != null)
{
model.plPWD = row["plPWD"].ToString();
}
if (row["plAccountName"] != null)
{
model.plAccountName = row["plAccountName"].ToString();
}
if (row["plStatus"] != null && row["plStatus"].ToString() != "")
{
model.plStatus = int.Parse(row["plStatus"].ToString());
}
if (row["plErrorCount"] != null && row["plErrorCount"].ToString() != "")
{
model.plErrorCount = int.Parse(row["plErrorCount"].ToString());
}
if (row["plHintPwd"] != null)
{
model.plHintPwd = row["plHintPwd"].ToString();
}
if (row["plHintquestion"] != null)
{
model.plHintquestion = row["plHintquestion"].ToString();
}
if (row["plCreateTime"] != null && row["plCreateTime"].ToString() != "")
{
model.plCreateTime = DateTime.Parse(row["plCreateTime"].ToString());
}
if (row["plUpdateTime"] != null && row["plUpdateTime"].ToString() != "")
{
model.plUpdateTime = DateTime.Parse(row["plUpdateTime"].ToString());
}
if (row["plLastErrTime"] != null && row["plLastErrTime"].ToString() != "")
{
model.plLastErrTime = DateTime.Parse(row["plLastErrTime"].ToString());
}
if (row["test"] != null)
{
model.test = row["test"].ToString();
}
}
return(model);
}
