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;
}
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;
}