Esempio n. 1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (this.userid > 0)
            {
                if (CheckUserPopedoms("X") || CheckUserPopedoms("7-2-3-8"))
                {
                    selectID  = HTTPRequest.GetInt("aid", 0);
                    bDate     = Convert.ToDateTime(HTTPRequest.GetString("bDate"));
                    eDate     = Convert.ToDateTime(HTTPRequest.GetString("eDate"));
                    staffName = HTTPRequest.GetString("staffName");
                    staffID   = HTTPRequest.GetInt("staffID", 0);
                    treeNode  = HTTPRequest.GetString("kID");

                    string[] kList_Arrary = treeNode.Split(',');
                    for (int i = 0; i < kList_Arrary.Length - 1; i++)
                    {
                        //判断是否有子节点
                        bool tl = DataClass.ExistsFeesSubjectClassChild(Convert.ToInt32(kList_Arrary[i]));
                        if (tl)
                        {
                            dataclass = CostDetails.getTreeChildrenCount(kList_Arrary[i]);
                            string[] dclass = dataclass.Split(',');
                            for (int j = 0; j < dclass.Length - 1; j++)
                            {
                                sList = CostDetails.getCostOfStaffDetails(selectID, bDate, eDate, staffID, dclass[j].ToString());

                                DataTable dt = sList.Copy();
                                dt.TableName = "p" + j + c_count;
                                sDateSet.Tables.Add(dt);
                                c_count++;
                            }
                        }
                        else
                        {
                            sList = CostDetails.getCostOfStaffDetails(selectID, bDate, eDate, staffID, kList_Arrary[i].ToString());
                            DataTable dt = sList.Copy();
                            dt.TableName = "f" + i + c_count;
                            sDateSet.Tables.Add(dt);
                            c_count++;
                        }
                    }
                    //把dataset中的datatable合并到一张表中
                    newTable = sDateSet.Tables[0].Clone();                  //创建新表 克隆以有表的架构
                    object[] objArray = new object[newTable.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
                    for (int m = 0; m < sDateSet.Tables.Count; m++)
                    {
                        if (sDateSet.Tables[m].Rows.Count > 0)
                        {
                            for (int n = 0; n < sDateSet.Tables[m].Rows.Count; n++)
                            {
                                sDateSet.Tables[m].Rows[n].ItemArray.CopyTo(objArray, 0); //将表的一行的值存放数组中
                                newTable.Rows.Add(objArray);                              //将数组的值添加到新表中
                            }
                        }
                    }
                }
                else
                {
                    AddErrLine("权限不足!");
                }
            }
            else
            {
                AddErrLine("请先登录!");
                SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
                SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
            }
        }
Esempio n. 2
0
        public string lastName      = "";//修改前的名称
        protected virtual void Page_Load(object sender, EventArgs e)
        {
            if (this.userid > 0)
            {
                if (CheckUserPopedoms("X") || CheckUserPopedoms("2-1-5"))
                {
                    Act           = HTTPRequest.GetString("Act");
                    rClassName    = HTTPRequest.GetString("tName").Trim();
                    regionClassID = HTTPRequest.GetInt("classID", 0);
                    lastName      = HTTPRequest.GetString("lastName").Trim();
                    if (regionClassID > 0)
                    {
                        pi = tbRegionInfo.GetRegionInfoModel(regionClassID);
                    }

                    if (ispost)
                    {
                        //添加
                        if (Act.IndexOf("add") > -1)
                        {
                            RegionInfo li = new RegionInfo();
                            if (rClassName != "")
                            {
                                li.rUpID       = regionClassID;
                                li.rName       = rClassName;
                                li.rOrder      = HTTPRequest.GetInt("tOrder", 0);
                                li.rAppendTime = DateTime.Now;

                                bool hValue = tbRegionInfo.ExistsRegionInfo(HTTPRequest.GetString("tName"), regionClassID);
                                if (hValue)
                                {
                                    AddErrLine("操作失败,该条分类已经存在,请核对后重新添加!");
                                }
                                else
                                {
                                    int addCount = tbRegionInfo.AddRegionInfo(li);
                                    if (addCount > 0)
                                    {
                                        //记录成功操作
                                        Logs.AddEventLog(this.userid, "添加" + rClassName + "地区分类");
                                        AddMsgLine("操作成功!");
                                        AddScript("window.setTimeout('window.parent.HidBox();',1000);");
                                    }
                                    else
                                    {
                                        AddErrLine("操作失败,请重新添加!");
                                    }
                                }
                            }
                            else
                            {
                                AddErrLine("操作失败,请重新添加!");
                            }
                        }
                        //修改
                        if (Act.IndexOf("update") > -1)
                        {
                            if (rClassName != "")
                            {
                                pi.RegionID    = regionClassID;
                                pi.rName       = rClassName;
                                pi.rAppendTime = DateTime.Now;

                                int count = tbRegionInfo.UpdateRegionInfo(pi);
                                if (count > 0)
                                {
                                    //记录修改操作
                                    Logs.AddEventLog(this.userid, "将" + lastName + "地区修改为" + rClassName);
                                    AddMsgLine("修改成功!");
                                    AddScript("window.setTimeout('window.parent.HidBox();',1000);");
                                }
                                else
                                {
                                    AddErrLine("修改失败!");
                                }
                            }
                            else
                            {
                                AddErrLine("修改失败!");
                            }
                        }
                    }
                }
                else
                {
                    AddErrLine("权限不足!");
                    AddScript("window.parent.HidBox();");
                }
            }
            else
            {
                AddErrLine("请先登录!");
                SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
                SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
            }
        }