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