private void ShowInfo()
{
YueDuLibrary.BLL.Library bll = new YueDuLibrary.BLL.Library();
YueDuLibrary.Model.Library model = bll.GetModel();
this.txtlibarayName.Text = model.libarayName;
this.txtcurator.Text = model.curator;
this.txttel.Text = model.tel;
this.txtAddresss.Text = model.Addresss;
this.txtemail.Text = model.email;
this.txturl.Text = model.url;
this.txtcreateDate.Text = model.createDate.ToString();
this.txtremark.Text = model.remark;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YueDuLibrary.Model.Library model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Library set ");
strSql.Append("libarayName=@libarayName,");
strSql.Append("curator=@curator,");
strSql.Append("tel=@tel,");
strSql.Append("Addresss=@Addresss,");
strSql.Append("email=@email,");
strSql.Append("url=@url,");
strSql.Append("createDate=@createDate,");
strSql.Append("remark=@remark");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@libarayName", SqlDbType.VarChar, 50),
new SqlParameter("@curator", SqlDbType.VarChar, 20),
new SqlParameter("@tel", SqlDbType.VarChar, 20),
new SqlParameter("@Addresss", SqlDbType.VarChar, 100),
new SqlParameter("@email", SqlDbType.VarChar, 100),
new SqlParameter("@url", SqlDbType.VarChar, 100),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@remark", SqlDbType.Text)
};
parameters[0].Value = model.libarayName;
parameters[1].Value = model.curator;
parameters[2].Value = model.tel;
parameters[3].Value = model.Addresss;
parameters[4].Value = model.email;
parameters[5].Value = model.url;
parameters[6].Value = model.createDate;
parameters[7].Value = model.remark;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YueDuLibrary.Model.Library DataRowToModel(DataRow row)
{
YueDuLibrary.Model.Library model = new YueDuLibrary.Model.Library();
if (row != null)
{
if (row["libarayName"] != null)
{
model.libarayName = row["libarayName"].ToString();
}
if (row["curator"] != null)
{
model.curator = row["curator"].ToString();
}
if (row["tel"] != null)
{
model.tel = row["tel"].ToString();
}
if (row["Addresss"] != null)
{
model.Addresss = row["Addresss"].ToString();
}
if (row["email"] != null)
{
model.email = row["email"].ToString();
}
if (row["url"] != null)
{
model.url = row["url"].ToString();
}
if (row["createDate"] != null && row["createDate"].ToString() != "")
{
model.createDate = DateTime.Parse(row["createDate"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(YueDuLibrary.Model.Library model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Library(");
strSql.Append("libarayName,curator,tel,Addresss,email,url,createDate,remark)");
strSql.Append(" values (");
strSql.Append("@libarayName,@curator,@tel,@Addresss,@email,@url,@createDate,@remark)");
SqlParameter[] parameters =
{
new SqlParameter("@libarayName", SqlDbType.VarChar, 50),
new SqlParameter("@curator", SqlDbType.VarChar, 20),
new SqlParameter("@tel", SqlDbType.VarChar, 20),
new SqlParameter("@Addresss", SqlDbType.VarChar, 100),
new SqlParameter("@email", SqlDbType.VarChar, 100),
new SqlParameter("@url", SqlDbType.VarChar, 100),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@remark", SqlDbType.Text)
};
parameters[0].Value = model.libarayName;
parameters[1].Value = model.curator;
parameters[2].Value = model.tel;
parameters[3].Value = model.Addresss;
parameters[4].Value = model.email;
parameters[5].Value = model.url;
parameters[6].Value = model.createDate;
parameters[7].Value = model.remark;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YueDuLibrary.Model.Library GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 libarayName,curator,tel,Addresss,email,url,createDate,remark from Library ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
YueDuLibrary.Model.Library model = new YueDuLibrary.Model.Library();
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.txtlibarayName.Text.Trim().Length == 0)
{
strErr += "libarayName不能为空！\\n";
}
if (this.txtcurator.Text.Trim().Length == 0)
{
strErr += "curator不能为空！\\n";
}
if (this.txttel.Text.Trim().Length == 0)
{
strErr += "tel不能为空！\\n";
}
if (this.txtAddresss.Text.Trim().Length == 0)
{
strErr += "Addresss不能为空！\\n";
}
if (this.txtemail.Text.Trim().Length == 0)
{
strErr += "email不能为空！\\n";
}
if (this.txturl.Text.Trim().Length == 0)
{
strErr += "url不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtcreateDate.Text))
{
strErr += "createDate格式错误！\\n";
}
if (this.txtremark.Text.Trim().Length == 0)
{
strErr += "remark不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string libarayName = this.txtlibarayName.Text;
string curator = this.txtcurator.Text;
string tel = this.txttel.Text;
string Addresss = this.txtAddresss.Text;
string email = this.txtemail.Text;
string url = this.txturl.Text;
DateTime createDate = DateTime.Parse(this.txtcreateDate.Text);
string remark = this.txtremark.Text;
YueDuLibrary.Model.Library model = new YueDuLibrary.Model.Library();
model.libarayName = libarayName;
model.curator = curator;
model.tel = tel;
model.Addresss = Addresss;
model.email = email;
model.url = url;
model.createDate = createDate;
model.remark = remark;
YueDuLibrary.BLL.Library bll = new YueDuLibrary.BLL.Library();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
