修改一行gridview中一行的数据后,数据不更新,还是原来的数据。
我是选取gridview中的一行,通过旁边的“更改”按钮进入修改这行数据的页面,修改后数据还是原来数据,但是提示“修改成功”了,程序编译没有提示错误,求解,谢谢...
代码如下:
public partial class Admin_fitEdit : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
/*验证是否登陆了系统*/
if (Session["adminFlag"] == null)
{
Response.Write("<script>top.location.href='../Login.aspx';</script>");
return;
}
}
InitView();
}
protected void Btn_Update_Click(object sender, EventArgs e)
{
//建立维修数据模型
string houseId = Request.QueryString["HouseId"];
FitModel fitModel = new FitModel();
fitModel.HouseId = Request.QueryString["HouseId"];
fitModel.Inform = this.Inform.Text;
fitModel.Time = this.Time.Text;
fitModel.Result = this.Result.Text;
fitModel.Type = this.Type.Text;
fitModel.Fee = this.Fee.Text;
fitModel.Remarks = this.Remarks.Text;
//执行维修信息的更新
FitLogic fitLogic = new FitLogic();
if (fitLogic.UpdateFitInfo(fitModel))
{
Response.Write("<script>alert('维修信息更新成功!');location.href='fitEdit.aspx?HouseId=" + houseId + "';</script>");
}
else
{
Response.Write("<script>alert('" + fitLogic.ErrMessage + "');</script>");
}
}
private void InitView()
{
string houseId = Request.QueryString["HouseId"];
FitLogic fitLogic = new FitLogic();
FitModel fitModel = fitLogic.GetFitInfo(houseId);
this.HouseId.Text = fitModel.HouseId;
this.Inform.Text = fitModel.Inform;
this.Time.Text = fitModel.Time;
this.Result.Text = fitModel.Result;
this.Type.Text = fitModel.Type;
this.Fee.Text = fitModel.Fee;
this.Remarks.Text = fitModel.Remarks;
}
protected void Btn_Cancle_Click(object sender, EventArgs e)
{
Response.Write("<script>location.href='fitment.aspx';</script>");
}
}
=============
GetFitInfo和UpdateFitInfo在FitLogic类里面
public FitModel GetFitInfo(string houseId)
{
string sqlString = "select * from fitment where HouseId=" + houseId;
DataSet ds = DBoperator.GetDataSet(DBoperator.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null);
if (ds.Tables[0].Rows.Count == 0) return null;
DataRow dr = ds.Tables[0].Rows[0];
FitModel fitModel = new FitModel();
fitModel.HouseId = dr["HouseId"].ToString();
fitModel.Inform = dr["Inform"].ToString();
fitModel.Time = dr["Time"].ToString();
fitModel.Result = dr["Result"].ToString();
fitModel.Type = dr["Type"].ToString();
fitModel.Fee = dr["Fee"].ToString();
fitModel.Remarks = dr["Remarks"].ToString();
return fitModel;
}
//更新维修信息
public bool UpdateFitInfo(FitModel fitModel)
{
string sqlString = "update fitment set ";
sqlString = sqlString + "HouseId='" + fitModel.HouseId + "',";
sqlString = sqlString + "Inform='" + fitModel.Inform + "',";
sqlString = sqlString + "Time='" + fitModel.Time + "',";
sqlString = sqlString + "Result='" + fitModel.Result + "',";
sqlString = sqlString + "Type='" + fitModel.Type + "',";
sqlString = sqlString + "Fee='" + fitModel.Fee + "',";
sqlString = sqlString + "Remarks='" + fitModel.Remarks + "'";
sqlString += "where HouseId=" + fitModel.HouseId;
if (DBoperator.ExecuteNonQuery(DBoperator.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null) < 0)
{
this.errMessage = "更新维修信息时发生了错误";
return false;
}
return true;
}