private void ShowInfo()
{
Maticsoft.BLL.test.Table_1 bll = new Maticsoft.BLL.test.Table_1();
Maticsoft.Model.test.Table_1 model = bll.GetModel();
this.txtname.Text = model.name;
this.txtnianling.Text = model.nianling;
this.txtshenggao.Text = model.shenggao;
this.txtbianhao.Text = model.bianhao;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.test.Table_1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Table_1 set ");
if (model.name != null)
{
strSql.Append("name='" + model.name + "',");
}
else
{
strSql.Append("name= null ,");
}
if (model.nianling != null)
{
strSql.Append("nianling='" + model.nianling + "',");
}
else
{
strSql.Append("nianling= null ,");
}
if (model.shenggao != null)
{
strSql.Append("shenggao='" + model.shenggao + "',");
}
else
{
strSql.Append("shenggao= null ,");
}
if (model.bianhao != null)
{
strSql.Append("bianhao='" + model.bianhao + "',");
}
else
{
strSql.Append("bianhao= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where ");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.test.Table_1 model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.name != null)
{
strSql1.Append("name,");
strSql2.Append("'" + model.name + "',");
}
if (model.nianling != null)
{
strSql1.Append("nianling,");
strSql2.Append("'" + model.nianling + "',");
}
if (model.shenggao != null)
{
strSql1.Append("shenggao,");
strSql2.Append("'" + model.shenggao + "',");
}
if (model.bianhao != null)
{
strSql1.Append("bianhao,");
strSql2.Append("'" + model.bianhao + "',");
}
strSql.Append("insert into Table_1(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtname.Text.Trim().Length == 0)
{
strErr += "name不能为空！\\n";
}
if (this.txtnianling.Text.Trim().Length == 0)
{
strErr += "nianling不能为空！\\n";
}
if (this.txtshenggao.Text.Trim().Length == 0)
{
strErr += "shenggao不能为空！\\n";
}
if (this.txtbianhao.Text.Trim().Length == 0)
{
strErr += "bianhao不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string name = this.txtname.Text;
string nianling = this.txtnianling.Text;
string shenggao = this.txtshenggao.Text;
string bianhao = this.txtbianhao.Text;
Maticsoft.Model.test.Table_1 model = new Maticsoft.Model.test.Table_1();
model.name = name;
model.nianling = nianling;
model.shenggao = shenggao;
model.bianhao = bianhao;
Maticsoft.BLL.test.Table_1 bll = new Maticsoft.BLL.test.Table_1();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.test.Table_1 GetModel()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" name,nianling,shenggao,bianhao ");
strSql.Append(" from Table_1 ");
strSql.Append(" where ");
Maticsoft.Model.test.Table_1 model = new Maticsoft.Model.test.Table_1();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["name"] != null && ds.Tables[0].Rows[0]["name"].ToString() != "")
{
model.name = ds.Tables[0].Rows[0]["name"].ToString();
}
if (ds.Tables[0].Rows[0]["nianling"] != null && ds.Tables[0].Rows[0]["nianling"].ToString() != "")
{
model.nianling = ds.Tables[0].Rows[0]["nianling"].ToString();
}
if (ds.Tables[0].Rows[0]["shenggao"] != null && ds.Tables[0].Rows[0]["shenggao"].ToString() != "")
{
model.shenggao = ds.Tables[0].Rows[0]["shenggao"].ToString();
}
if (ds.Tables[0].Rows[0]["bianhao"] != null && ds.Tables[0].Rows[0]["bianhao"].ToString() != "")
{
model.bianhao = ds.Tables[0].Rows[0]["bianhao"].ToString();
}
return(model);
}
else
{
return(null);
}
}