protected void btnok_Click(object sender, EventArgs e)
{
Maticsoft.BLL.FuWuInfo fuwubll = new Maticsoft.BLL.FuWuInfo();
Maticsoft.Model.FuWuInfo fuwumodel = fuwubll.GetModel(1);
if (txtfuwuTitle.Text.Trim() == "")
{
lblfuwutitle.Text = "请填写服务标题！";
return;
}
fuwumodel.fuwuTitle = txtfuwuTitle.Text.Trim();
lblfuwutitle.Text = "";
if (txtFatime.Text.Trim() == "")
{
lblfuwutime.Text = "请填写服务发布时间！";
return;
}
fuwumodel.Fatime = Convert.ToDateTime(txtFatime.Text.Trim());
lblfuwutime.Text = "";
fuwumodel.Fuwucontent = txtFuwucontent.Text.Trim();
fuwumodel.FuwuTypeID = DrpFuwuType.SelectedIndex + 1;
tu.Visible = true;
fuwumodel.ImageURL = Image1.ImageUrl;
if (txtWrite.Text.Trim() == "")
{
lblfuwuwrite.Text = "请填写发布人！";
return;
}
fuwumodel.Write = txtWrite.Text.Trim();
lblfuwuwrite.Text = "";
fuwubll.Update(fuwumodel);
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('信息添加成功！')</script>");
bind();
}
protected void datading_ItemDataBound(object sender, DataListItemEventArgs e)
{
int index = int.Parse(datafuwu.DataKeys[e.Item.ItemIndex].ToString());
Maticsoft.BLL.FuWuInfo fuwubll = new Maticsoft.BLL.FuWuInfo();
Maticsoft.Model.FuWuInfo fuwumodel = fuwubll.GetModel(index);
Maticsoft.BLL.FuWuTypeInfo typebll = new Maticsoft.BLL.FuWuTypeInfo();
Maticsoft.Model.FuWuTypeInfo typemodel = typebll.GetModel(int.Parse(fuwumodel.FuwuTypeID.ToString()));
((Label)e.Item.FindControl("lnltype")).Text = typemodel.FuwuTypeName;
}
private void bind()
{
Maticsoft.BLL.FuWuInfo fuwubll = new Maticsoft.BLL.FuWuInfo();
Maticsoft.Model.FuWuInfo fuwumodel = fuwubll.GetModel(1);
DataSet ds = fuwubll.GetAllList();
datafuwu.DataSource = ds;
datafuwu.DataKeyField = "fuwuID";
datafuwu.DataBind();
}
private void ShowInfo(int fuwuID)
{
Maticsoft.BLL.FuWuInfo bll = new Maticsoft.BLL.FuWuInfo();
Maticsoft.Model.FuWuInfo model = bll.GetModel(fuwuID);
this.lblfuwuID.Text = model.fuwuID.ToString();
this.lblfuwuTitle.Text = model.fuwuTitle;
this.lblFatime.Text = model.Fatime.ToString();
this.lblFuwuTypeID.Text = model.FuwuTypeID.ToString();
this.lblWrite.Text = model.Write;
this.lblFuwucontent.Text = model.Fuwucontent;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Maticsoft.BLL.FuWuInfo fuwubll = new Maticsoft.BLL.FuWuInfo();
Maticsoft.Model.FuWuInfo fuwumodel = fuwubll.GetModel(1);
DataSet ds = fuwubll.GetAllList();
dalistfuwu.DataSource = ds;
dalistfuwu.DataBind();
}
}
private void bind(int fuwuID)
{
Maticsoft.BLL.FuWuInfo fuwubll = new Maticsoft.BLL.FuWuInfo();
Maticsoft.Model.FuWuInfo fuwumodel = fuwubll.GetModel(fuwuID);
Maticsoft.BLL.FuWuTypeInfo typebll = new Maticsoft.BLL.FuWuTypeInfo();
Maticsoft.Model.FuWuTypeInfo typemodel = typebll.GetModel(int.Parse(fuwumodel.FuwuTypeID.ToString()));
lblFatime.Text = Convert.ToDateTime(fuwumodel.Fatime.ToString()).ToString("yyyy-MM-dd");
lblFuwucontent.Text = fuwumodel.Fuwucontent;
lblWrite.Text = fuwumodel.Write;
lblFuwuTypeName.Text = typemodel.FuwuTypeName;
lbltitle.Text = fuwumodel.fuwuTitle;
}
private void bind()
{
int fuwuid = int.Parse(Request.QueryString["fuwuID"].ToString());
Maticsoft.BLL.FuWuInfo fuwubll = new Maticsoft.BLL.FuWuInfo();
Maticsoft.Model.FuWuInfo fuwumodel = fuwubll.GetModel(fuwuid);
txtFatime.Text = Convert.ToDateTime(fuwumodel.Fatime.ToString()).ToString("yyyy-MM-dd");
Image1.ImageUrl = fuwumodel.ImageURL;
txtFuwucontent.Text = fuwumodel.Fuwucontent;
txtfuwuTitle.Text = fuwumodel.fuwuTitle;
txtWrite.Text = fuwumodel.Write;
DrpFuwuType.SelectedValue = fuwumodel.FuwuTypeID.ToString();
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtfuwuTitle.Text.Trim().Length == 0)
{
strErr += "fuwuTitle不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtFatime.Text))
{
strErr += "Fatime格式错误！\\n";
}
if (!PageValidate.IsNumber(txtFuwuTypeID.Text))
{
strErr += "FuwuTypeID格式错误！\\n";
}
if (this.txtWrite.Text.Trim().Length == 0)
{
strErr += "Write不能为空！\\n";
}
if (this.txtFuwucontent.Text.Trim().Length == 0)
{
strErr += "Fuwucontent不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int fuwuID = int.Parse(this.lblfuwuID.Text);
string fuwuTitle = this.txtfuwuTitle.Text;
DateTime Fatime = DateTime.Parse(this.txtFatime.Text);
int FuwuTypeID = int.Parse(this.txtFuwuTypeID.Text);
string Write = this.txtWrite.Text;
string Fuwucontent = this.txtFuwucontent.Text;
Maticsoft.Model.FuWuInfo model = new Maticsoft.Model.FuWuInfo();
model.fuwuID = fuwuID;
model.fuwuTitle = fuwuTitle;
model.Fatime = Fatime;
model.FuwuTypeID = FuwuTypeID;
model.Write = Write;
model.Fuwucontent = Fuwucontent;
Maticsoft.BLL.FuWuInfo bll = new Maticsoft.BLL.FuWuInfo();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.FuWuInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FuWuInfo set ");
strSql.Append("fuwuTitle=@fuwuTitle,");
strSql.Append("Fatime=@Fatime,");
strSql.Append("ImageURL=@ImageURL,");
strSql.Append("FuwuTypeID=@FuwuTypeID,");
strSql.Append("Write=@Write,");
strSql.Append("Fuwucontent=@Fuwucontent");
strSql.Append(" where fuwuID=@fuwuID");
SqlParameter[] parameters =
{
new SqlParameter("@fuwuID", SqlDbType.Int, 4),
new SqlParameter("@fuwuTitle", SqlDbType.VarChar, 200),
new SqlParameter("@Fatime", SqlDbType.DateTime),
new SqlParameter("@ImageURL", SqlDbType.Text),
new SqlParameter("@FuwuTypeID", SqlDbType.Int, 4),
new SqlParameter("@Write", SqlDbType.VarChar, 200),
new SqlParameter("@Fuwucontent", SqlDbType.Text)
};
parameters[0].Value = model.fuwuID;
parameters[1].Value = model.fuwuTitle;
parameters[2].Value = model.Fatime;
parameters[3].Value = model.ImageURL;
parameters[4].Value = model.FuwuTypeID;
parameters[5].Value = model.Write;
parameters[6].Value = model.Fuwucontent;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.FuWuInfo GetModel(int fuwuID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 fuwuID,fuwuTitle,Fatime,ImageURL,FuwuTypeID,Write,Fuwucontent from FuWuInfo ");
strSql.Append(" where fuwuID=@fuwuID");
SqlParameter[] parameters =
{
new SqlParameter("@fuwuID", SqlDbType.Int, 4)
};
parameters[0].Value = fuwuID;
Maticsoft.Model.FuWuInfo model = new Maticsoft.Model.FuWuInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["fuwuID"].ToString() != "")
{
model.fuwuID = int.Parse(ds.Tables[0].Rows[0]["fuwuID"].ToString());
}
model.fuwuTitle = ds.Tables[0].Rows[0]["fuwuTitle"].ToString();
if (ds.Tables[0].Rows[0]["Fatime"].ToString() != "")
{
model.Fatime = DateTime.Parse(ds.Tables[0].Rows[0]["Fatime"].ToString());
}
model.ImageURL = ds.Tables[0].Rows[0]["ImageURL"].ToString();
if (ds.Tables[0].Rows[0]["FuwuTypeID"].ToString() != "")
{
model.FuwuTypeID = int.Parse(ds.Tables[0].Rows[0]["FuwuTypeID"].ToString());
}
model.Write = ds.Tables[0].Rows[0]["Write"].ToString();
model.Fuwucontent = ds.Tables[0].Rows[0]["Fuwucontent"].ToString();
return(model);
}
else
{
return(null);
}
}
private void bind()
{
int fuwuid = int.Parse(Request.QueryString["fuwuID"].ToString());
Maticsoft.BLL.FuWuInfo fuwubll = new Maticsoft.BLL.FuWuInfo();
Maticsoft.Model.FuWuInfo fuwumodel = fuwubll.GetModel(fuwuid);
Maticsoft.BLL.FuWuTypeInfo fuwutypebll = new Maticsoft.BLL.FuWuTypeInfo();
lblfaren.Text = fuwumodel.Write;
lblfatime.Text = Convert.ToDateTime(fuwumodel.Fatime.ToString()).ToString("yyyy-MM-dd");
lbltitle.Text = fuwumodel.fuwuTitle;
string fuwutype = fuwutypebll.GetModel(Convert.ToInt32(fuwumodel.FuwuTypeID.ToString())).ToString();
lbltype.Text = fuwutype;
if (fuwumodel.ImageURL == "")
{
tu.Visible = false;
}
else
{
tu.Visible = true;
Image1.ImageUrl = fuwumodel.ImageURL;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.FuWuInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FuWuInfo(");
strSql.Append("fuwuTitle,Fatime,ImageURL,FuwuTypeID,Write,Fuwucontent)");
strSql.Append(" values (");
strSql.Append("@fuwuTitle,@Fatime,@ImageURL,@FuwuTypeID,@Write,@Fuwucontent)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@fuwuTitle", SqlDbType.VarChar, 200),
new SqlParameter("@Fatime", SqlDbType.DateTime),
new SqlParameter("@ImageURL", SqlDbType.Text),
new SqlParameter("@FuwuTypeID", SqlDbType.Int, 4),
new SqlParameter("@Write", SqlDbType.VarChar, 200),
new SqlParameter("@Fuwucontent", SqlDbType.Text)
};
parameters[0].Value = model.fuwuTitle;
parameters[1].Value = model.Fatime;
parameters[2].Value = model.ImageURL;
parameters[3].Value = model.FuwuTypeID;
parameters[4].Value = model.Write;
parameters[5].Value = model.Fuwucontent;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
