Пример #1
0
        public static string ListSeeds()
        {
            int    memberID = HttpContext.Current.Session["MemberID"].ToInt();
            var    info     = SeedProcess_Data.GetList(memberID, DateTime.Now);
            string result   = "";

            for (int i = 0; i < info.Rows.Count; i++)
            {
                DateTime StartTime = Convert.ToDateTime(info.Rows[i]["DateOfManufacture"]);
                DateTime EndTime   = new DateTime();
                if (info.Rows[i]["EndTime"].ToString() != "")
                {
                    EndTime = Convert.ToDateTime(info.Rows[i]["EndTime"]);
                }
                //if (EndTime > DateTime.Now)
                {
                    result += @"<table data-toggle='table' data-url='data1.json' data-cache='false' data-height='299' style='margin-bottom: -10px;margin-top: -10px;'>
                        <thead>
                            <tr>
                                <th class='col-sm-2'><img src='" + info.Rows[i]["Images"].ToString().Replace("..", "http://admin.vietgap.info") + "' style='width:80px;height:80px'/></th>" +
                              "<th class='col-sm-10'><font color='rgb(87, 7, 65)'>" + info.Rows[i]["SeedsName"] + "</font><br />Ngày trồng &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <b>" + StartTime.ToString("dd-MM-yyyy") + "</b><br />Ngày thu hoạch: <b>" + EndTime.ToString("dd-MM-yyyy") + "</b></th>" +
                              @"</tr>
                        </thead>
                        </table><hr/>";
                }
            }


            return(result);
        }
Пример #2
0
        protected void GrDelete(object sender, CommandEventArgs e)
        {
            int nPageNumber             = int.Parse(txtPageNumber.Text);
            int nPageSize               = int.Parse(txtPageSize.Text);
            SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];

            nUserLogin.CheckRole("CU0001");
            if (!nUserLogin.Role.Del)
            {
                Response.Write("<script >alert('Bạn không có quyền xóa danh mục này!')</script>");
            }
            else
            {
                try
                {
                    int             mKey = int.Parse(e.CommandArgument.ToString());
                    SeedProces_Info info = new SeedProces_Info(mKey);
                    info.Delete();
                    DataTable nTable = SeedProcess_Data.GetList(Convert.ToInt16(Session["EmployeeKey"]), nPageSize, nPageNumber, DDLSeeds.SelectedValue.ToInt());
                    if (nTable.Rows.Count == 0)
                    {
                        nTable.Rows.Add(0, 0, "", 0, 0, 0, "", "", 0, "", "", "", 0, 0, null, null, 0, 0, 0, "", 0, 0, "", "", "", 0, "");
                    }
                    GV_SeedProcess.DataSource = nTable;
                    GV_SeedProcess.DataBind();
                    LoadPages();
                }
                catch
                {
                    Response.Write("<script >alert('Có lỗi gì đó vui lòng thử lại!')</script>");
                }
            }
        }
Пример #3
0
        protected void cmdView_Click1(object sender, ImageClickEventArgs e)
        {
            txtPageNumber.Text = "1";
            int nPageNumber             = int.Parse(txtPageNumber.Text);
            int nPageSize               = int.Parse(txtPageSize.Text);
            SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];
            DateTime         dtfrom     = DateTime.ParseExact(txtfromDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            DateTime         dtto       = DateTime.ParseExact(txttoDatetime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
            DataTable        nTable     = SeedProcess_Data.GetList(dtfrom, dtto, Convert.ToInt16(Session["EmployeeKey"]), nPageSize, nPageNumber, DDLSeeds.SelectedValue.ToInt());

            GV_SeedProcess.DataSource = nTable;
            GV_SeedProcess.DataBind();
            LoadPages();
        }
Пример #4
0
        public static string Listwork(string time)
        {
            string result   = "";
            int    memberID = HttpContext.Current.Session["MemberID"].ToInt();
            var    infos    = SeedProcess_Data.GetList(time, memberID);

            if (infos.Rows.Count > 0)
            {
                for (int i = 0; i < infos.Rows.Count; i++)
                {
                    result += "$" + infos.Rows[i]["SeedProcessKey"].ToString() + "-" + infos.Rows[i]["SeedsName"].ToString();
                }
            }
            return(result);
        }
Пример #5
0
        private void LoadData()
        {
            int nPageNumber             = int.Parse(txtPageNumber.Text);
            int nPageSize               = int.Parse(txtPageSize.Text);
            SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];
            DataTable        nTable     = SeedProcess_Data.GetList(Convert.ToInt16(Session["EmployeeKey"]), nPageSize, nPageNumber, DDLSeeds.SelectedValue.ToInt());

            if (nTable.Rows.Count == 0)
            {
                nTable.Rows.Add(0, 0, "", 0, 0, 0, "", "", 0, "", "", "", 0, 0, null, null, 0, 0, 0, "", 0, 0, "", "", "", 0, "");
            }
            GV_SeedProcess.DataSource = nTable;
            GV_SeedProcess.DataBind();
            txtfromDatetime.Text = "01/" + DateTime.Now.ToString("MM/yyyy");
            txttoDatetime.Text   = DateTime.Now.ToString("dd/MM/yyyy");
            LoadPages();
        }
Пример #6
0
        protected void LoadPages()
        {
            int nPageNumber = int.Parse(txtPageNumber.Text);
            int nPageSize   = int.Parse(txtPageSize.Text);

            int nTotalRecord = SeedProcess_Data.Count(Session["EmployeeKey"].ToInt(), DDLSeeds.SelectedValue.ToInt());

            if (nTotalRecord > nPageSize)
            {
                PageNumbers.Visible = true;
                DataTable nTable = TNLibrary.WEB.LoadDataToToolboxWeb.LoadPageSize(nPageSize, nTotalRecord, nPageNumber);

                PageNumbers.SelectedIndex = (nPageNumber - 1) - (int.Parse(nTable.Rows[0][0].ToString()) - 1);
                PageNumbers.DataSource    = nTable;
                PageNumbers.DataBind();
            }
            else
            {
                PageNumbers.Visible = false;
            }
        }
Пример #7
0
        public static string ListDate(string Year, string Month)
        {
            int    memberID = HttpContext.Current.Session["MemberID"].ToInt();
            var    infos    = SeedProcess_Data.GetListDate(memberID, Month.ToInt(), Year.ToInt());
            string cities   = "";

            for (int i = 0; i < infos.Rows.Count; i++)
            {
                DateTime date = DateTime.Parse(infos.Rows[i]["DateOfManufacture"].ToString());
                string   day  = date.ToString("yyyy-MM-dd");
                if (i + 1 < infos.Rows.Count)
                {
                    cities += '"' + day + "\":{\"number\":\"" + infos.Rows[i]["Count"].ToInt() + "\"},";
                }
                else
                {
                    cities += '"' + day + "\":{\"number\":\"" + infos.Rows[i]["Count"].ToInt() + "\"}";
                }
            }
            cities = "{" + cities + "}";
            return(cities);
        }