/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.ClientSoftInfo DataRowToModel(DataRow row)
{
WebDemo.Model.WebDemo.ClientSoftInfo model = new WebDemo.Model.WebDemo.ClientSoftInfo();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["DanWeiName"] != null)
{
model.DanWeiName = row["DanWeiName"].ToString();
}
if (row["JiQiMa"] != null)
{
model.JiQiMa = row["JiQiMa"].ToString();
}
if (row["RenZhengMa"] != null)
{
model.RenZhengMa = row["RenZhengMa"].ToString();
}
if (row["SoftName"] != null)
{
model.SoftName = row["SoftName"].ToString();
}
if (row["SoftHao"] != null)
{
model.SoftHao = row["SoftHao"].ToString();
}
if (row["UsePassword"] != null)
{
model.UsePassword = row["UsePassword"].ToString();
}
if (row["JieTiCalDate"] != null)
{
model.JieTiCalDate = row["JieTiCalDate"].ToString();
}
if (row["SqlVersion"] != null && row["SqlVersion"].ToString() != "")
{
model.SqlVersion = int.Parse(row["SqlVersion"].ToString());
}
if (row["MeterTypes"] != null)
{
model.MeterTypes = row["MeterTypes"].ToString();
}
if (row["CardTypes"] != null)
{
model.CardTypes = row["CardTypes"].ToString();
}
if (row["PayTypes"] != null)
{
model.PayTypes = row["PayTypes"].ToString();
}
if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebDemo.Model.WebDemo.ClientSoftInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ClientSoftInfo set ");
strSql.Append("RenZhengMa=@RenZhengMa,");
strSql.Append("SoftName=@SoftName,");
strSql.Append("SoftHao=@SoftHao,");
strSql.Append("UsePassword=@UsePassword,");
strSql.Append("JieTiCalDate=@JieTiCalDate,");
strSql.Append("SqlVersion=@SqlVersion,");
strSql.Append("MeterTypes=@MeterTypes,");
strSql.Append("CardTypes=@CardTypes,");
strSql.Append("PayTypes=@PayTypes,");
strSql.Append("UpdateTime=@UpdateTime");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@RenZhengMa", SqlDbType.VarChar, 200),
new SqlParameter("@SoftName", SqlDbType.NVarChar, 200),
new SqlParameter("@SoftHao", SqlDbType.VarChar, 50),
new SqlParameter("@UsePassword", SqlDbType.VarChar, 100),
new SqlParameter("@JieTiCalDate", SqlDbType.VarChar, 50),
new SqlParameter("@SqlVersion", SqlDbType.Int, 4),
new SqlParameter("@MeterTypes", SqlDbType.VarChar, 4000),
new SqlParameter("@CardTypes", SqlDbType.VarChar, 4000),
new SqlParameter("@PayTypes", SqlDbType.VarChar, 4000),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@DanWeiName", SqlDbType.NVarChar, 200),
new SqlParameter("@JiQiMa", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.RenZhengMa;
parameters[1].Value = model.SoftName;
parameters[2].Value = model.SoftHao;
parameters[3].Value = model.UsePassword;
parameters[4].Value = model.JieTiCalDate;
parameters[5].Value = model.SqlVersion;
parameters[6].Value = model.MeterTypes;
parameters[7].Value = model.CardTypes;
parameters[8].Value = model.PayTypes;
parameters[9].Value = model.UpdateTime;
parameters[10].Value = model.Id;
parameters[11].Value = model.DanWeiName;
parameters[12].Value = model.JiQiMa;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebDemo.Model.WebDemo.ClientSoftInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ClientSoftInfo(");
strSql.Append("DanWeiName,JiQiMa,RenZhengMa,SoftName,SoftHao,UsePassword,JieTiCalDate,SqlVersion,MeterTypes,CardTypes,PayTypes,UpdateTime)");
strSql.Append(" values (");
strSql.Append("@DanWeiName,@JiQiMa,@RenZhengMa,@SoftName,@SoftHao,@UsePassword,@JieTiCalDate,@SqlVersion,@MeterTypes,@CardTypes,@PayTypes,@UpdateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@DanWeiName", SqlDbType.NVarChar, 200),
new SqlParameter("@JiQiMa", SqlDbType.VarChar, 200),
new SqlParameter("@RenZhengMa", SqlDbType.VarChar, 200),
new SqlParameter("@SoftName", SqlDbType.NVarChar, 200),
new SqlParameter("@SoftHao", SqlDbType.VarChar, 50),
new SqlParameter("@UsePassword", SqlDbType.VarChar, 100),
new SqlParameter("@JieTiCalDate", SqlDbType.VarChar, 50),
new SqlParameter("@SqlVersion", SqlDbType.Int, 4),
new SqlParameter("@MeterTypes", SqlDbType.VarChar, 4000),
new SqlParameter("@CardTypes", SqlDbType.VarChar, 4000),
new SqlParameter("@PayTypes", SqlDbType.VarChar, 4000),
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.DanWeiName;
parameters[1].Value = model.JiQiMa;
parameters[2].Value = model.RenZhengMa;
parameters[3].Value = model.SoftName;
parameters[4].Value = model.SoftHao;
parameters[5].Value = model.UsePassword;
parameters[6].Value = model.JieTiCalDate;
parameters[7].Value = model.SqlVersion;
parameters[8].Value = model.MeterTypes;
parameters[9].Value = model.CardTypes;
parameters[10].Value = model.PayTypes;
parameters[11].Value = model.UpdateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void ShowInfo(int Id)
{
WebDemo.BLL.WebDemo.ClientSoftInfo bll = new WebDemo.BLL.WebDemo.ClientSoftInfo();
WebDemo.Model.WebDemo.ClientSoftInfo model = bll.GetModel(Id);
this.lblId.Text = model.Id.ToString();
this.lblDanWeiName.Text = model.DanWeiName;
this.lblJiQiMa.Text = model.JiQiMa;
this.txtRenZhengMa.Text = model.RenZhengMa;
this.txtSoftName.Text = model.SoftName;
this.txtSoftHao.Text = model.SoftHao;
this.txtUsePassword.Text = model.UsePassword;
this.txtJieTiCalDate.Text = model.JieTiCalDate;
this.txtSqlVersion.Text = model.SqlVersion.ToString();
this.txtMeterTypes.Text = model.MeterTypes;
this.txtCardTypes.Text = model.CardTypes;
this.txtPayTypes.Text = model.PayTypes;
this.txtUpdateTime.Text = model.UpdateTime.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.ClientSoftInfo GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,DanWeiName,JiQiMa,RenZhengMa,SoftName,SoftHao,UsePassword,JieTiCalDate,SqlVersion,MeterTypes,CardTypes,PayTypes,UpdateTime from ClientSoftInfo ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
WebDemo.Model.WebDemo.ClientSoftInfo model = new WebDemo.Model.WebDemo.ClientSoftInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtRenZhengMa.Text.Trim().Length == 0)
{
strErr += "RenZhengMa不能为空！\\n";
}
if (this.txtSoftName.Text.Trim().Length == 0)
{
strErr += "SoftName不能为空！\\n";
}
if (this.txtSoftHao.Text.Trim().Length == 0)
{
strErr += "SoftHao不能为空！\\n";
}
if (this.txtUsePassword.Text.Trim().Length == 0)
{
strErr += "UsePassword不能为空！\\n";
}
if (this.txtJieTiCalDate.Text.Trim().Length == 0)
{
strErr += "JieTiCalDate不能为空！\\n";
}
if (!PageValidate.IsNumber(txtSqlVersion.Text))
{
strErr += "SqlVersion格式错误！\\n";
}
if (this.txtMeterTypes.Text.Trim().Length == 0)
{
strErr += "MeterTypes不能为空！\\n";
}
if (this.txtCardTypes.Text.Trim().Length == 0)
{
strErr += "CardTypes不能为空！\\n";
}
if (this.txtPayTypes.Text.Trim().Length == 0)
{
strErr += "PayTypes不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtUpdateTime.Text))
{
strErr += "UpdateTime格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int Id = int.Parse(this.lblId.Text);
string DanWeiName = this.lblDanWeiName.Text;
string JiQiMa = this.lblJiQiMa.Text;
string RenZhengMa = this.txtRenZhengMa.Text;
string SoftName = this.txtSoftName.Text;
string SoftHao = this.txtSoftHao.Text;
string UsePassword = this.txtUsePassword.Text;
string JieTiCalDate = this.txtJieTiCalDate.Text;
int SqlVersion = int.Parse(this.txtSqlVersion.Text);
string MeterTypes = this.txtMeterTypes.Text;
string CardTypes = this.txtCardTypes.Text;
string PayTypes = this.txtPayTypes.Text;
DateTime UpdateTime = DateTime.Parse(this.txtUpdateTime.Text);
WebDemo.Model.WebDemo.ClientSoftInfo model = new WebDemo.Model.WebDemo.ClientSoftInfo();
model.Id = Id;
model.DanWeiName = DanWeiName;
model.JiQiMa = JiQiMa;
model.RenZhengMa = RenZhengMa;
model.SoftName = SoftName;
model.SoftHao = SoftHao;
model.UsePassword = UsePassword;
model.JieTiCalDate = JieTiCalDate;
model.SqlVersion = SqlVersion;
model.MeterTypes = MeterTypes;
model.CardTypes = CardTypes;
model.PayTypes = PayTypes;
model.UpdateTime = UpdateTime;
WebDemo.BLL.WebDemo.ClientSoftInfo bll = new WebDemo.BLL.WebDemo.ClientSoftInfo();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
