Exemple #1
0
        public int UpdateHomeReportForProcess(HomeReportModel homereport)
        {
            SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@FinishText", SqlDbType.Text) };
            param[0].Value = homereport.ID;
            param[1].Value = homereport.FinshText;
            int result = SqlHelp.ExecuteNonQuery("prc_UpdateHomeReportForProcess", CommandType.StoredProcedure, param);

            return(result);
        }
Exemple #2
0
        public int InsertHomeReport(HomeReportModel homereport)
        {
            SqlParameter[] param = { new SqlParameter("@ID",         SqlDbType.VarChar,                            20), new SqlParameter("@Code", SqlDbType.VarChar, 9),
                                     new SqlParameter("@ReportText", SqlDbType.Text),   new SqlParameter("@ReportMemo", SqlDbType.Text) };
            param[0].Value = homereport.ID;
            param[1].Value = homereport.Code;
            param[2].Value = homereport.ReportText;
            param[3].Value = homereport.ReportMemo;
            int result = SqlHelp.ExecuteNonQuery("prc_InsertHomeReport", CommandType.StoredProcedure, param);

            return(result);
        }
Exemple #3
0
 protected void Page_Load(object sender, EventArgs e)
 {
     homereport.ID = Request.QueryString["ID"].ToString();
     user          = (UserModel)Session["User"];
     if (Session["User"] == null || Session["User"].ToString() == "" || user.UserType != 1)
     {
         Response.Redirect("../Login.aspx");
     }
     else
     {
         homereport        = bll.ShowHomeReportByID(homereport.ID);
         lbReportText.Text = homereport.ReportText;
         lbReportDate.Text = homereport.ReportDate.ToString("yyy年MM月dd日");
         lbReportMemo.Text = homereport.ReportMemo;
     }
 }
Exemple #4
0
        protected void Add_Click(object sender, EventArgs e)
        {
            HomeReportModel homereport = new HomeReportModel();

            homereport.ID         = lbID.Text;
            homereport.Code       = user.Code;
            homereport.ReportText = txtTitle.Text.Trim();
            homereport.ReportMemo = txtMemo.Text.Trim();
            bool flag = bll.InsertHomeReport(homereport);

            if (flag)
            {
                Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加成功');location.href='MyComplaints.aspx';</script>");
            }
            else
            {
                Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加失败');</script>");
            }
        }
Exemple #5
0
        public List <HomeReportModel> GetHomeReport()
        {
            SqlDataReader          dr   = SqlHelp.ExecuteReader("prc_GetHomeReport", CommandType.StoredProcedure);
            List <HomeReportModel> list = new List <HomeReportModel>();

            while (dr.Read())
            {
                HomeReportModel homereport = new HomeReportModel();
                homereport.ID         = dr[0].ToString();
                homereport.Code       = dr[1].ToString();
                homereport.ReportDate = Convert.ToDateTime(dr[2]);
                homereport.ReportText = dr[3].ToString();
                homereport.Sign       = Convert.ToInt32(dr[4]);
                homereport.RoomID     = dr[5].ToString();
                list.Add(homereport);
            }
            dr.Close();
            return(list);
        }
Exemple #6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string id = Request.QueryString["ID"].ToString();

            user = (UserModel)Session["User"];
            if (Session["User"] == null || Session["User"].ToString() == "" || user.UserType != 0)
            {
                Response.Redirect("../Login.aspx");
            }
            else
            {
                if (!IsPostBack)
                {
                    homereport    = bll.ShowHomeReportByID(id);
                    lbID.Text     = homereport.ID;
                    txtTitle.Text = homereport.ReportText;
                    txtMemo.Text  = homereport.ReportMemo;
                }
            }
        }
Exemple #7
0
        public HomeReportModel ShowHomeReportByID(string id)
        {
            SqlParameter param = new SqlParameter("@ID", SqlDbType.VarChar, 20);

            param.Value = id;
            SqlDataReader   dr         = SqlHelp.ExecuteReader("prc_GetHomeReportByID", CommandType.StoredProcedure, param);
            HomeReportModel homereport = new HomeReportModel();

            dr.Read();
            if (dr.HasRows)
            {
                homereport.ID         = dr[0].ToString();
                homereport.ReportText = dr[1].ToString();
                homereport.ReportMemo = dr[2].ToString();
                homereport.ReportDate = (DateTime)dr[3];
                homereport.FinshText  = dr[4].ToString();
            }
            dr.Close();
            return(homereport);
        }
Exemple #8
0
        public List <HomeReportModel> ShowHomeReportByCode(string code)
        {
            SqlParameter param = new SqlParameter("@Code", SqlDbType.VarChar, 20);

            param.Value = code;
            SqlDataReader          dr   = SqlHelp.ExecuteReader("prc_GetHomeReportByCode", CommandType.StoredProcedure, param);
            List <HomeReportModel> list = new List <HomeReportModel>();

            while (dr.Read())
            {
                HomeReportModel homereport = new HomeReportModel();
                homereport.ID         = dr[0].ToString();
                homereport.Code       = dr[1].ToString();
                homereport.ReportDate = Convert.ToDateTime(dr[2]);
                homereport.ReportText = dr[3].ToString();
                homereport.Sign       = Convert.ToInt32(dr[4]);

                list.Add(homereport);
            }
            dr.Close();
            return(list);
        }
Exemple #9
0
        public bool UpdateHomeReportForProcess(HomeReportModel homereport)
        {
            int result = dal.UpdateHomeReportForProcess(homereport);

            return(result == 0 ? false : true);
        }
Exemple #10
0
        public bool InsertHomeReport(HomeReportModel homereport)
        {
            int result = dal.InsertHomeReport(homereport);

            return(result == 0 ? false : true);
        }