public int InsertAreaFact(AreaFactModel areafact)
{
SqlParameter[] param = { new SqlParameter("@FactName", SqlDbType.VarChar, 50), new SqlParameter("@MainHead", SqlDbType.VarChar, 20),
new SqlParameter("@Tel", SqlDbType.VarChar, 13), new SqlParameter("@TypeID", SqlDbType.Int), new SqlParameter("@Memo", SqlDbType.Text) };
param[0].Value = areafact.FactName;
param[1].Value = areafact.MainHead;
param[2].Value = areafact.Tel;
param[3].Value = areafact.TypeID;
param[4].Value = areafact.Memo;
int result = SqlHelp.ExecuteNonQuery("prc_InsertAreaFact", CommandType.StoredProcedure, param);
return(result);
}
public List <AreaFactModel> ShowAllAreafact()
{
SqlDataReader dr = SqlHelp.ExecuteReader("prc_ShowAllAreafact", CommandType.StoredProcedure);
List <AreaFactModel> list = new List <AreaFactModel>();
while (dr.Read())
{
AreaFactModel arefact = new AreaFactModel();
arefact.ID = Convert.ToInt32(dr[0]);
arefact.FactName = dr[1].ToString();
arefact.MainHead = dr[2].ToString();
arefact.Tel = dr[3].ToString();
arefact.Memo = dr[5].ToString();
arefact.TypeName = dr[6].ToString();
list.Add(arefact);
}
dr.Close();
return(list);
}
protected void Add_Click(object sender, EventArgs e)
{
AreaFactModel areafact = new AreaFactModel();
areafact.FactName = txtFactName.Text.Trim();
areafact.MainHead = txtMainHead.Text.Trim();
areafact.TypeID = Convert.ToInt32(DDLAreaType.SelectedValue);
areafact.Tel = txtTelphone.Text.Trim();
areafact.Memo = ftbMemo.Text.Trim();
bool flag = afbll.InsertAreaFact(areafact);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加成功');location.href='BaseInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加失败');</script>");
}
}
public AreaFactModel GetAreaFactByID(int id)
{
SqlParameter param = new SqlParameter("@ID", SqlDbType.Int);
param.Value = id;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetAreaFactByID", CommandType.StoredProcedure, param);
AreaFactModel areafact = new AreaFactModel();
dr.Read();
if (dr.HasRows)
{
areafact.ID = Convert.ToInt32(dr[0]);
areafact.FactName = dr[1].ToString();
areafact.MainHead = dr[2].ToString();
areafact.Tel = dr[3].ToString();
areafact.Memo = dr[5].ToString();
areafact.TypeName = dr[6].ToString();
}
dr.Close();
return(areafact);
}
protected void Edit_Click(object sender, EventArgs e)
{
AreaFactModel areafact = new AreaFactModel();
areafact.FactName = txtFactName.Text.Trim();
areafact.MainHead = txtMainHead.Text.Trim();
areafact.TypeID = Convert.ToInt32(DDLAreaType.SelectedValue);
areafact.Tel = txtTelphone.Text.Trim();
areafact.Memo = ftbMemo.Text.Trim();
areafact.ID = int.Parse(Request.QueryString["ID"]);
bool flag = afbll.UpdateAreaFact(areafact);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('修改成功');location.href='AreaFactInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('修改失败');</script>");
}
}
public List <AreaFactModel> GetAreaFactByCondition(string condition)
{
SqlParameter param = new SqlParameter("@Condition", SqlDbType.VarChar, 255);
param.Value = condition;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetAreaFactByCondition", CommandType.StoredProcedure, param);
List <AreaFactModel> list = new List <AreaFactModel>();
while (dr.Read())
{
AreaFactModel arefact = new AreaFactModel();
arefact.ID = Convert.ToInt32(dr[0]);
arefact.FactName = dr[1].ToString();
arefact.MainHead = dr[2].ToString();
arefact.Tel = dr[3].ToString();
arefact.Memo = dr[5].ToString();
arefact.TypeName = dr[6].ToString();
list.Add(arefact);
}
dr.Close();
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
user = (UserModel)Session["User"];
if (Session["User"] == null || Session["User"].ToString() == "" || user.UserType != 1)
{
Response.Redirect("../Login.aspx");
}
else
{
if (!IsPostBack)
{
int id = int.Parse(Request.QueryString["ID"]);
DDLAreaType.DataSource = bll.GetType("AreaFact");
DDLAreaType.DataBind();
AreaFactModel areafact = afbll.GetAreaFactByID(id);
txtFactName.Text = areafact.FactName;
txtMainHead.Text = areafact.MainHead;
DDLAreaType.SelectedValue = areafact.TypeID.ToString();
txtTelphone.Text = areafact.Tel;
ftbMemo.Text = areafact.Memo;
}
}
}
public bool UpdateAreaFact(AreaFactModel areafact)
{
int result = dal.UpdateAreaFact(areafact);
return(result == 0 ? false : true);
}
public bool InsertAreaFact(AreaFactModel areafact)
{
int result = dal.InsertAreaFact(areafact);
return(result == 0 ? false : true);
}
