protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("6-7-10"))
{
bDate = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("bDate"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("bDate"))) : DateTime.Now.AddDays(-(DateTime.Now.Day) + 1);
eDate = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("eDate"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("eDate"))) : DateTime.Now;
sType = HTTPRequest.GetInt("sType", 0);
status = HTTPRequest.GetInt("get_status", 0);//0=全部；1=已审核
if (ispost)
{
//按时间统计
if (sType == 0)
{
kList = CostDetails.getFeeSubjectID(bDate, eDate);
DataSet ds = new DataSet();
for (int i = 0; i < kList.Rows.Count; i++)
{
DataTable dt = CostDetails.getOccurrenceAndBalanceDetails(bDate, eDate, Convert.ToInt32(kList.Rows[i][0]), status);
dList = dt.Copy();
dList.TableName = "t_" + i;
ds.Tables.Add(dList);
}
if (ds.Tables.Count > 0)
{
sCost = ds.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] objArray = new object[sCost.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < ds.Tables.Count; m++)
{
if (ds.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < ds.Tables[m].Rows.Count; n++)
{
ds.Tables[m].Rows[n].ItemArray.CopyTo(objArray, 0); //将表的一行的值存放数组中
sCost.Rows.Add(objArray); //将数组的值添加到新表中
}
}
}
}
}
}
//按科目统计
if (sType == 1)
{
DataSet classDataSet = new DataSet();
getTreeNode = HTTPRequest.GetString("get_treeNode");
result = getTreeNode.Split(',');
//把选择的科目整理到dataset中
for (int i = 0; i < result.Length - 1; i++)
{
DataTable tr = CostDetails.getObjectsListName(Convert.ToInt32(result[i]));
if (tr != null)
{
for (int p = 0; p < tr.Rows.Count; p++)
{
TreeName += tr.Rows[p][0].ToString() + ",";
}
}
else
{
TreeName = "";
}
//获得科目名称
DataTable className = CostDetails.getClassName(result[i]);
DataTable ddt = className.Copy();
ddt.TableName = "k" + i + c_count;
classDataSet.Tables.Add(ddt);
c_count++;
}
if (classDataSet.Tables.Count > 0)
{
//把dataset中的datatable合并到一张表中
newTable = classDataSet.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] objArray = new object[newTable.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < classDataSet.Tables.Count; m++)
{
if (classDataSet.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < classDataSet.Tables[m].Rows.Count; n++)
{
classDataSet.Tables[m].Rows[n].ItemArray.CopyTo(objArray, 0); //将表的一行的值存放数组中
newTable.Rows.Add(objArray); //将数组的值添加到新表中
}
}
}
if (TreeName.Length > 2)
{
TreeName = TreeName.Substring(0, TreeName.Length - 1);
}
}
}
}
else
{
AddErrLine("权限不足!");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("6-7-10"))
{
//接收打印类型
sType = HTTPRequest.GetInt("dType", 0);
//接收日期参数
bDate = (HTTPRequest.GetString("bDate").Trim() != "") ? Convert.ToDateTime(HTTPRequest.GetString("bDate").Trim()) : DateTime.Now; //获得日期
eDate = (HTTPRequest.GetString("eDate").Trim() != "") ? Convert.ToDateTime(HTTPRequest.GetString("eDate").Trim()) : DateTime.Now; //获得日期
//页面日期格式转换
bTime = bDate.ToString("yyyy.MM");
eTime = eDate.ToString("yyyy.MM");
pTime = pDate.ToString("yyyy.MM.dd");
uiName = tbUserInfo.GetUserInfoModel(this.userid);
status = HTTPRequest.GetInt("status", 0);
//1、时间打印
if (sType == 0)
{
//读出数据
kList = CostDetails.getFeeSubjectID(bDate, eDate);
if (kList.Rows.Count > 0)
{
DataSet ds = new DataSet();
for (int i = 0; i < kList.Rows.Count; i++)
{
DataTable dt = CostDetails.getOccurrenceAndBalanceDetails(bDate, eDate, Convert.ToInt32(kList.Rows[i][0]), status);
dList = dt.Copy();
dList.TableName = "t_" + i;
ds.Tables.Add(dList);
}
sCost = ds.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] objArray = new object[sCost.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < ds.Tables.Count; m++)
{
if (ds.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < ds.Tables[m].Rows.Count; n++)
{
ds.Tables[m].Rows[n].ItemArray.CopyTo(objArray, 0); //将表的一行的值存放数组中
sCost.Rows.Add(objArray); //将数组的值添加到新表中
}
}
}
if (sCost.Rows.Count > 0)
{
detailsCount = sCost.Rows.Count;
int p = 0;
dt = sCost.Clone();
foreach (DataRow dr in sCost.Rows)
{
dt.ImportRow(dr);
p++;
if (p % MaxDetailsCount == 0)
{
dsDetails.Tables.Add(dt);
dt.TableName = "t_" + p;
dt = sCost.Clone();
}
}
if (dt.Rows.Count > 0)
{
//剩下的行数
dsDetails.Tables.Add(dt);
dt = sCost.Clone();
dt.TableName = "t_" + (p + 1);
}
}
else
{
AddErrLine("无数据打印，请查询后再次打印数据！");
}
}
else
{
AddErrLine("未能获得科目编号！");
}
}
//2、科目打印
if (sType == 1)
{
//1.找到科目名称;
DataSet classDataSet = new DataSet();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
getTreeNode = HTTPRequest.GetString("feeID");
result = getTreeNode.Split(',');
//把选择的科目整理到dataset中
for (int i = 0; i < result.Length - 1; i++)
{
//--==================获得科目名称================
DataTable className = CostDetails.getClassName(result[i]);
DataTable ddt = className.Copy();
ddt.TableName = "k" + i + c_count;
classDataSet.Tables.Add(ddt);
c_count++;
}
//-==========================合成科目名称表=============================
//把dataset中的datatable合并到一张表中
newTable = classDataSet.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] objArray = new object[newTable.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < classDataSet.Tables.Count; m++)
{
if (classDataSet.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < classDataSet.Tables[m].Rows.Count; n++)
{
classDataSet.Tables[m].Rows[n].ItemArray.CopyTo(objArray, 0); //将表的一行的值存放数组中
newTable.Rows.Add(objArray); //将数组的值添加到新表中
}
}
}
dsDetails.Tables.Add(newTable);
}
}
else
{
AddErrLine("权限不足!");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X") || CheckUserPopedoms("6-7-8"))
{
Act = HTTPRequest.GetString("Act").Trim();
tType = HTTPRequest.GetInt("tType", 0);
feeType = HTTPRequest.GetInt("feeType", 0);
get_direction = HTTPRequest.GetInt("get_direction", 0);//借贷方向
//获得科目节点选择
getTreeNode = HTTPRequest.GetString("get_treeNode").Trim();
string[] result = getTreeNode.Split(',');
if (ispost)
{
maori_ID = HTTPRequest.GetInt("maori_ID", 0); //销售类型：0=购销；1=联营：2=直销
moriType = HTTPRequest.GetInt("moriType", 0); //毛利统计类别
sDate = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("sDate"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("sDate"))) : DateTime.Now;
stDate = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("stDate"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("stDate"))) : DateTime.Now;
//1.费用统计_门店
if (tType == 1 && feeType == 0)
{
//获得科目名称
for (int i = 0; i < result.Length - 1; i++)
{
DataTable dttp = CostDetails.getObjectsListName(Convert.ToInt32(result[i]));
if (dttp != null)
{
for (int pp = 0; pp < dttp.Rows.Count; pp++)
{
TreeName += dttp.Rows[0][0] + ",";
}
}
else
{
TreeName = "";
}
}
if (TreeName.Length > 2)
{
TreeName = TreeName.Substring(0, TreeName.Length - 1);
}
for (int i = 0; i < result.Length - 1; i++)
{
//判断是否有子节点
bool tl = DataClass.ExistsFeesSubjectClassChild(Convert.ToInt32(result[i]));
if (tl)
{
dataclass = CostDetails.getTreeChildrenCount(result[i]);
string[] dclass = dataclass.Split(',');
for (int j = 0; j < dclass.Length - 1; j++)
{
//获得科目信息
kList = CostDetails.getTreeName(dclass[j].ToString());
DataTable dt = kList.Copy();
dt.TableName = "p_" + j + c_count;
kDateSetName.Tables.Add(dt);
//获得区域信息
rList = CostDetails.getRegionList(get_direction, dclass[j].ToString(), sDate, stDate);
DataTable rt = rList.Copy();
rt.TableName = "o_" + j + c_count;
rDateSet.Tables.Add(rt);
c_count = c_count + 1;
}
DataTable newDataTable = rDateSet.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] objArray = new object[newDataTable.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < rDateSet.Tables.Count; m++)
{
if (rDateSet.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < rDateSet.Tables[m].Rows.Count; n++)
{
rDateSet.Tables[m].Rows[n].ItemArray.CopyTo(objArray, 0); //将表的一行的值存放数组中
newDataTable.Rows.Add(objArray); //将数组的值添加到新表中
}
}
}
DataView dv = new DataView(newDataTable);
dv.Sort = "RegionID";
nTable = dv.ToTable(true, "RegionID", "rName");
}
else
{
//获得科目信息
kList = CostDetails.getTreeName(result[i]);
DataTable dt = kList.Copy();
dt.TableName = "m_" + i;
kDateSetName.Tables.Add(dt);
//获得区域信息
rList = CostDetails.getRegionList(get_direction, result[i], sDate, stDate);
DataTable rt = rList.Copy();
rt.TableName = "f_" + i;
rDateSet.Tables.Add(rt);
DataTable newDataTable = rDateSet.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] objArray = new object[newDataTable.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < rDateSet.Tables.Count; m++)
{
if (rDateSet.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < rDateSet.Tables[m].Rows.Count; n++)
{
rDateSet.Tables[m].Rows[n].ItemArray.CopyTo(objArray, 0); //将表的一行的值存放数组中
newDataTable.Rows.Add(objArray); //将数组的值添加到新表中
}
}
}
DataView dv = new DataView(newDataTable);
dv.Sort = "RegionID";
nTable = dv.ToTable(true, "RegionID", "rName");
}
}
}
//2.费用统计_科目
if (tType == 1 && feeType == 1)
{
//获得科目名称
for (int i = 0; i < result.Length - 1; i++)
{
DataTable dttp = CostDetails.getObjectsListName(Convert.ToInt32(result[i]));
if (dttp != null)
{
for (int pp = 0; pp < dttp.Rows.Count; pp++)
{
TreeName += dttp.Rows[0][0] + ",";
}
}
else
{
TreeName = "";
}
}
if (TreeName.Length > 2)
{
TreeName = TreeName.Substring(0, TreeName.Length - 1);
}
//把选择的科目整理到dataset中
for (int i = 0; i < result.Length - 1; i++)
{
className = CostDetails.getClassName(result[i]);
DataTable ddt = className.Copy();
ddt.TableName = "k" + i + c_count;
classDataSet.Tables.Add(ddt);
c_count++;
}
//把dataset中的datatable合并到一张表中
newTable = classDataSet.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] objArray = new object[newTable.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < classDataSet.Tables.Count; m++)
{
if (classDataSet.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < classDataSet.Tables[m].Rows.Count; n++)
{
classDataSet.Tables[m].Rows[n].ItemArray.CopyTo(objArray, 0); //将表的一行的值存放数组中
newTable.Rows.Add(objArray); //将数组的值添加到新表中
}
}
}
}
//3.费用统计_业务员
if (tType == 1 && feeType == 2)
{
//获得科目名称
for (int i = 0; i < result.Length - 1; i++)
{
DataTable dttp = CostDetails.getObjectsListName(Convert.ToInt32(result[i]));
if (dttp != null)
{
for (int pp = 0; pp < dttp.Rows.Count; pp++)
{
TreeName += dttp.Rows[0][0] + ",";
}
}
else
{
TreeName = "";
}
}
if (TreeName.Length > 2)
{
TreeName = TreeName.Substring(0, TreeName.Length - 1);
}
for (int i = 0; i < result.Length - 1; i++)
{
//判断是否有子节点
bool tl = DataClass.ExistsFeesSubjectClassChild(Convert.ToInt32(result[i]));
if (tl)
{
dataclass = CostDetails.getTreeChildrenCount(result[i]);
string[] dclass = dataclass.Split(',');
for (int j = 0; j < dclass.Length - 1; j++)
{
//获得科目信息
kList = CostDetails.getTreeName(dclass[j].ToString());
DataTable dt = kList.Copy();
dt.TableName = "p_" + j + c_count;
kDateSetName.Tables.Add(dt);
staffList = CostDetails.getStaffName(get_direction, sDate, stDate, Convert.ToInt32(dclass[j]));
DataTable stl = staffList.Copy();
stl.TableName = "qp_" + j + c_count;
sDataSet.Tables.Add(stl);
c_count++;
}
}
else
{
//获得科目信息
kList = CostDetails.getTreeName(result[i]);
DataTable dt = kList.Copy();
dt.TableName = "m_" + i;
kDateSetName.Tables.Add(dt);
//获取业务员名称
staffList = CostDetails.getStaffName(get_direction, sDate, stDate, Convert.ToInt32(result[i]));
DataTable stl = staffList.Copy();
stl.TableName = "we_" + i + c_count;
sDataSet.Tables.Add(stl);
}
}
sCostTable = sDataSet.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] objArray = new object[sCostTable.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < sDataSet.Tables.Count; m++)
{
if (sDataSet.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < sDataSet.Tables[m].Rows.Count; n++)
{
sDataSet.Tables[m].Rows[n].ItemArray.CopyTo(objArray, 0); //将表的一行的值存放数组中
sCostTable.Rows.Add(objArray); //将数组的值添加到新表中
}
}
}
DataView dv = new DataView(sCostTable);
dv.Sort = "StaffID";
tnTable = dv.ToTable(true, "StaffID", "sName");
}
//4.费用统计_赠品
if (tType == 1 && feeType == 3)
{
DataTable dt = CostDetails.getGiftCost(0, sDate, stDate);
if (dt.Rows.Count > 0)
{
gList_stor = dt.Copy();
}
gList = CostDetails.getGiftCost(0, sDate, stDate);
}
//1.毛利统计
if (tType == 0)
{
mList = CostDetails.getMoriOfRegion(moriType, 0, sDate, stDate);
}
}
else
{
if (Act.IndexOf("act") > -1)
{
sDate = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("bDate"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("bDate"))) : DateTime.Now;
stDate = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("eDate"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("eDate"))) : DateTime.Now;
DataTable dt = new DataTable();
DataSet ds = new DataSet();
if (tType == 0)
{
moriType = HTTPRequest.GetInt("mType", 0);
mList = CostDetails.getMoriOfRegion(moriType, 0, sDate, stDate);
dt = mList.Copy();
ds.Tables.Add(dt);
if (moriType == 0)
{
ds.Tables[0].Columns[0].ColumnName = "区域名称";
}
if (moriType == 1)
{
ds.Tables[0].Columns[0].ColumnName = "客户名称";
}
if (moriType == 2)
{
ds.Tables[0].Columns[0].ColumnName = "业务员名称";
}
if (moriType == 3)
{
ds.Tables[0].Columns[0].ColumnName = "品牌名称";
}
if (moriType == 4)
{
ds.Tables[0].Columns[0].ColumnName = "单品名称";
}
ds.Tables[0].Columns[1].ColumnName = "销售金额";
ds.Tables[0].Columns[2].ColumnName = "成本金额";
ds.Tables[0].Columns[3].ColumnName = "利润金额";
CreateExcel(ds.Tables[0], "毛利统计_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls");
}
if (tType == 1)
{
DataSet dss = new DataSet();
if (feeType == 3)
{
gList = CostDetails.getGiftCost(0, sDate, stDate);
dt = gList.Copy();
dt.Columns.RemoveAt(0);
dt.Columns.RemoveAt(0);
dt.Columns.RemoveAt(1);
ds.Tables.Add(dt);
ds.Tables[0].Columns[0].ColumnName = "门店名称";
ds.Tables[0].Columns[1].ColumnName = "商品名称";
ds.Tables[0].Columns[2].ColumnName = "商品条码";
ds.Tables[0].Columns[3].ColumnName = "赠品单数量";
ds.Tables[0].Columns[4].ColumnName = "销售单数量";
ds.Tables[0].Columns[5].ColumnName = "赠品金额";
CreateExcel(ds.Tables[0], "赠品数据_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls");
}
else
{
for (int i = 0; i < result.Length - 1; i++)
{
//判断是否有子节点
bool tl = DataClass.ExistsFeesSubjectClassChild(Convert.ToInt32(result[i]));
if (tl)
{
dataclass = CostDetails.getTreeChildrenCount(result[i]);
string[] dclass = dataclass.Split(',');
for (int j = 0; j < dclass.Length - 1; j++)
{
//客户
if (feeType == 0)
{
rList = CostDetails.getCostOfStorehouse(-1, dclass[j].ToString(), get_direction, sDate, stDate);
dt = rList.Copy();
dt.TableName = "k_" + j;
ds.Tables.Add(dt);
newData = ds.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] obj = new object[newData.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < ds.Tables.Count; m++)
{
if (ds.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < ds.Tables[m].Rows.Count; n++)
{
ds.Tables[m].Rows[n].ItemArray.CopyTo(obj, 0); //将表的一行的值存放数组中
newData.Rows.Add(obj); //将数组的值添加到新表中
}
}
}
}
//科目
if (feeType == 1)
{
rList = CostDetails.getClassCost(get_direction, dclass[j].ToString(), sDate, stDate);
dt = rList.Copy();
dt.TableName = "c_" + j;
ds.Tables.Add(dt);
newData = ds.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] obj = new object[newData.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < ds.Tables.Count; m++)
{
if (ds.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < ds.Tables[m].Rows.Count; n++)
{
ds.Tables[m].Rows[n].ItemArray.CopyTo(obj, 0); //将表的一行的值存放数组中
newData.Rows.Add(obj); //将数组的值添加到新表中
}
}
}
}
//业务员
if (feeType == 2)
{
rList = CostDetails.getCostOfStaffID(get_direction, sDate, stDate, Convert.ToInt32(dclass[j].ToString()), -1);
dt = rList.Copy();
dt.TableName = "y_" + j;
ds.Tables.Add(dt);
newData = ds.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] obj = new object[newData.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < ds.Tables.Count; m++)
{
if (ds.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < ds.Tables[m].Rows.Count; n++)
{
ds.Tables[m].Rows[n].ItemArray.CopyTo(obj, 0); //将表的一行的值存放数组中
newData.Rows.Add(obj); //将数组的值添加到新表中
}
}
}
}
}
}
else
{
//客户
if (feeType == 0)
{
rList = CostDetails.getCostOfStorehouse(-1, result[i], get_direction, sDate, stDate);
dt = rList.Copy();
dt.TableName = "k_" + i;
ds.Tables.Add(dt);
newData = ds.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] obj = new object[newData.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < ds.Tables.Count; m++)
{
if (ds.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < ds.Tables[m].Rows.Count; n++)
{
ds.Tables[m].Rows[n].ItemArray.CopyTo(obj, 0); //将表的一行的值存放数组中
newData.Rows.Add(obj); //将数组的值添加到新表中
}
}
}
}
//科目
if (feeType == 1)
{
rList = CostDetails.getClassCost(get_direction, result[i], sDate, stDate);
dt = rList.Copy();
dt.TableName = "c_" + i;
ds.Tables.Add(dt);
newData = ds.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] obj = new object[newData.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < ds.Tables.Count; m++)
{
if (ds.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < ds.Tables[m].Rows.Count; n++)
{
ds.Tables[m].Rows[n].ItemArray.CopyTo(obj, 0); //将表的一行的值存放数组中
newData.Rows.Add(obj); //将数组的值添加到新表中
}
}
}
}
//业务员
if (feeType == 2)
{
rList = CostDetails.getCostOfStaffID(get_direction, sDate, stDate, Convert.ToInt32(result[i]), -1);
dt = rList.Copy();
dt.TableName = "y_" + i;
ds.Tables.Add(dt);
newData = ds.Tables[0].Clone(); //创建新表 克隆以有表的架构
object[] obj = new object[newData.Columns.Count]; //定义与表列数相同的对象数组 存放表的一行的值
for (int m = 0; m < ds.Tables.Count; m++)
{
if (ds.Tables[m].Rows.Count > 0)
{
for (int n = 0; n < ds.Tables[m].Rows.Count; n++)
{
ds.Tables[m].Rows[n].ItemArray.CopyTo(obj, 0); //将表的一行的值存放数组中
newData.Rows.Add(obj); //将数组的值添加到新表中
}
}
}
}
}
dt = newData.Copy();
//客户
if (feeType == 0)
{
dt.Columns.RemoveAt(0);
dss.Tables.Add(dt);
dss.Tables[0].Columns[0].ColumnName = "客户名称";
dss.Tables[0].Columns[1].ColumnName = "发生金额";
}
//科目
if (feeType == 1)
{
dt.Columns.RemoveAt(0);
dss.Tables.Add(dt);
dss.Tables[0].Columns[0].ColumnName = "科目名称";
dss.Tables[0].Columns[1].ColumnName = "发生金额";
}
//业务员
if (feeType == 2)
{
dss.Tables.Add(dt);
dss.Tables[0].Columns[0].ColumnName = "业务名称";
dss.Tables[0].Columns[1].ColumnName = "发生金额";
}
CreateExcel(dss.Tables[0], "费用统计_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls");
}
}
}
}
}
}
else
{
AddErrLine("权限不足!");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}