public List<BaseInfoModel> ShowBaseInfo()
{
SqlDataReader dr= SqlHelp.ExecuteReader("prc_ShowBaseInfo", CommandType.StoredProcedure);
dr.Read();
List<BaseInfoModel> list = new List<BaseInfoModel>();
if (dr.HasRows)
{
BaseInfoModel baseInfo = new BaseInfoModel();
baseInfo.ID = Convert.ToInt32(dr[0]);
baseInfo.HomeName = dr[1].ToString();
baseInfo.MainHead = dr[2].ToString();
baseInfo.BuildDate = Convert.ToDateTime(dr[3]);
baseInfo.BuildArea = Convert.ToDouble(dr[4]);
baseInfo.Amount = Convert.ToInt32(dr[5]);
baseInfo.Address = dr[6].ToString();
baseInfo.GreenArea = Convert.ToDouble(dr[7]);
baseInfo.RoadArea = Convert.ToDouble(dr[8]);
baseInfo.Tel = dr[9].ToString();
baseInfo.ParkingArea = Convert.ToDouble(dr[10]);
baseInfo.Memo = dr[11].ToString();
list.Add(baseInfo);
}
dr.Close();
return list;
}
protected void Modify_Click(object sender, EventArgs e)
{
BaseInfoModel baseinfo = new BaseInfoModel();
baseinfo.HomeName = txtBaseName.Text.Trim();
baseinfo.MainHead = txtMainHead.Text.Trim();
baseinfo.BuildDate = DateTime.Parse(txtBuildDate.Value.Trim().ToString());
baseinfo.BuildArea = Double.Parse(txtBuildArea.Text.Trim());
baseinfo.RoadArea = Double.Parse(txtRoadArea.Text.Trim());
baseinfo.GreenArea = Double.Parse(txtGreenArea.Text.Trim());
baseinfo.ParkingArea = Double.Parse(txtParkArea.Text.Trim());
baseinfo.Amount = int.Parse(txtAmount.Text.Trim());
baseinfo.Tel = txtTelephone.Text.Trim();
baseinfo.Address = txtAddress.Text.Trim();
baseinfo.Memo = txtMemo.Text.Trim();
baseinfo.ID = (int)Session["BaseInfoID"];
bool flag = bll.UpdateBaseInfo(baseinfo);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('修改成功');location.href='BaseInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('修改失败');</script>");
}
}
public int InsertBaseInfo(BaseInfoModel baseinfo)
{
SqlParameter[] param = { new SqlParameter("@HomeName", SqlDbType.VarChar, 20), new SqlParameter("@MainHead", SqlDbType.VarChar, 20),
new SqlParameter("@BuildDate",SqlDbType.DateTime,10),new SqlParameter("@BuildArea",SqlDbType.Float),
new SqlParameter("@Amount",SqlDbType.Int,4),new SqlParameter("@Address",SqlDbType.VarChar,255),
new SqlParameter("@GreenArea",SqlDbType.Float),new SqlParameter("@RoadArea",SqlDbType.Float),
new SqlParameter("@Tel",SqlDbType.VarChar,18),new SqlParameter("@ParkingArea",SqlDbType.Float),
new SqlParameter("@Memo",SqlDbType.Text)
};
param[0].Value = baseinfo.HomeName;
param[1].Value = baseinfo.MainHead;
param[2].Value = baseinfo.BuildDate;
param[3].Value = baseinfo.BuildArea;
param[4].Value = baseinfo.Amount;
param[5].Value = baseinfo.Address;
param[6].Value = baseinfo.GreenArea;
param[7].Value = baseinfo.RoadArea;
param[8].Value = baseinfo.Tel;
param[9].Value = baseinfo.ParkingArea;
param[10].Value = baseinfo.Memo;
int result = SqlHelp.ExecuteNonQuery("prc_InsertBaseInfo", CommandType.StoredProcedure, param);
return result;
}
public bool UpdateBaseInfo(BaseInfoModel baseinfo)
{
int result = dal.UpdateBaseInfo(baseinfo);
return result == 0 ? false : true;
}
public bool InsertBaseInfo(BaseInfoModel baseinfo)
{
int result = dal.InsertBaseInfo(baseinfo);
return result == 0 ? false : true;
}