整理项目2

原创 于 2013-11-13 10:54:16 发布 · 664 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

供方管理整理 。

1、首先是导入模板的更改：在report/ 合格供方名录.xls      文件夹下修改为如下内容：

分类

序号

单位名称

单位地址

业务范围

供方等级

涉及型号

备注

关键部(组)件

1

电子所

地址

在名称

B

FY-2

备注备注

 

2、修改ExcelUploadXML50.xml 里面的内容，在根目录下 <table>标签下的所有内容如下：

 <Table table_name="50" xls_name="合格供方名录">
    <Column  WordItemName="分类" ColNum="1" FiledName="1" GrpType="5" PrimaryCheck="N"  KeyLength ="5000">
      <List WordItemName="分类"  ResultColumn="CONTENTVALUE" SearchTable="reportStruct" SearchColumn="CONTENTVALUE" WhereCondition =""/>
    </Column>
    <Column  WordItemName="序号" ColNum="2" FiledName="0" GrpType="0" PrimaryCheck="N"  KeyLength ="5000"></Column>
    <Column  WordItemName="单位名称" ColNum="3" FiledName="2" GrpType="1" PrimaryCheck="N"  KeyLength ="5000"></Column>
    <Column  WordItemName="单位地址" ColNum="4" FiledName="3" GrpType="1" PrimaryCheck="N"  KeyLength ="5000"></Column>
    <Column  WordItemName="业务范围" ColNum="5" FiledName="4" GrpType="1" PrimaryCheck="N"  KeyLength ="5000"></Column>
    <Column  WordItemName="等级类别" ColNum="6" FiledName="5" GrpType="5" PrimaryCheck="N"  KeyLength ="5000">
      <List WordItemName="等级类别"  ResultColumn="CONTENTVALUE" SearchTable="reportStruct" SearchColumn="CONTENTVALUE" WhereCondition =""/>
    </Column>
    <Column  WordItemName="涉及型号" ColNum="7" FiledName="6" GrpType="1" PrimaryCheck="N"  KeyLength ="5000"> </Column>  
    <Column  WordItemName="备注" ColNum="8" FiledName="7" GrpType="1" PrimaryCheck="N"  KeyLength ="5000">  </Column>
  </Table>

3 修改 fullQuarteryEditer.aspx.cs   第4246行到4333行

  if (rpt4 == "" || rpt4 == Session["ID"].ToString()) //申请表中一个报告只能有一个认定表报告相对应
                                        {
                                            rpt4 = Session["ID"].ToString();
                                            IARREP.updateLink("rpt4", rpt4, AllName); //更新rpt4(供方认定表)的值
                                            updateState(Session["ID"].ToString(), Session["TYPE"].ToString());

                                            //生成合格供方名录 Save(db,"");
                                            string idML = Guid.NewGuid().ToString("N");
                                            string[] objML = new string[8];
                                            string[] objMore = new string[8];
                                            objML[0] = ((string[])Session["obj"])[7].ToString(); //分类
                                            objMore[0] = ((string[])Session["obj2"])[7].ToString();

                                            objML[1] = Name;
                                            objMore[1] = "";
                                            SqlDataReader dsType = IARREP.GetReportByID(db, rpt1);
                                            string tabletype = "51";
                                            if (dsType.Read())
                                            {
                                                tabletype = dsType["TABLETYPE"].ToString();
                                            }
                                            DataSet dsSQ = IARREP.GetReportDetail(rpt1, tabletype);
                                            if (dsSQ != null)
                                            {
                                                if (dsSQ.Tables[0].Rows.Count > 0)
                                                {
                                                    objML[2] = dsSQ.Tables[0].Rows[5]["DETAILCONTENT"].ToString(); //地址
                                                    objMore[2] = "";
                                                    //objML[3] = dsSQ.Tables[0].Rows[6]["DETAILCONTENT"].ToString(); //负责人
                                                    //objMore[3] = "";
                                                    //objML[4] = dsSQ.Tables[0].Rows[7]["DETAILCONTENT"].ToString();//电话
                                                    //objMore[4] = "";
                                                    string xiezuo="";
                                                    if (tabletype == "51")
                                                    {
                                                        xiezuo = dsSQ.Tables[0].Rows[8]["DETAILCONTENT"].ToString();//名称
                                                    }
                                                    else if (tabletype == "57")
                                                    {
                                                        xiezuo = dsSQ.Tables[0].Rows[16]["DETAILCONTENT"].ToString(); //业务范围
                                                    }
                                                    objML[3] = xiezuo;//协作内容
                                                    objMore[3] = "";
                                                    string dateTime = dsSQ.Tables[0].Rows[2]["DETAILCONTENT"].ToString();
                                                    if (dateTime == "")
                                                    {
                                                        dateTime = DateTime.Now.ToString();
                                                    }
                                                    objML[7] = Convert.ToDateTime(dateTime).ToString("yyyy.MM.dd");//申请时间
                                                    objMore[7] = "";
                                                }
                                            }
                                            objML[5] = ((string[])Session["obj"])[5].ToString(); //涉及型号=名称
                                            objMore[5] = "";
                                            objML[6] = "";
                                            objMore[6] = "";


                                            DataSet dsPJ = IARREP.GetReportDetail(rpt3, "53");
                                            string moreV = "";
                                            if (dsPJ != null)
                                            {
                                                if (dsPJ.Tables[0].Rows.Count > 0)
                                                {
                                                    string dengji = dsPJ.Tables[0].Rows[10]["DETAILCONTENT"].ToString(); //供方等级
                                                    if (dengji != "")
                                                    {
                                                        int dj = Convert.ToInt32(dengji);
                                                        if (dj >= 90)
                                                        {
                                                            objML[4] = "1";
                                                            objMore[4] = "A";
                                                        }
                                                        else if (dj < 90 && dj >= 75)
                                                        {
                                                            objML[4] = "2";
                                                            objMore[4] = "B";
                                                        }
                                                        else if (dj < 75 && dj >= 60)
                                                        {
                                                            objML[4] = "3";
                                                            objMore[4] = "C";
                                                        }
                                                        else if (dj < 60)
                                                        {
                                                            objML[4] = "4";
                                                            objMore[4] = "D";
                                                        }
                                                    }
                                                }
                                            }

第4946行改成  html.AppendFormat(RESPONSE_SHOW_bind, no, ok, up, dw, name, width, title, sbHtml.ToString(), tag, bind,"");

 

4 数据库修改字段

tabletype  no     title    contentype                contentvalue

50               1       分类     4                      分系统,单机,关键部(组)件,部(组)件,工序外包,元器件筛选/原材料理化试验外包,试验外包,软件评测,计量外包,元器件,原材料,机电配套产品,仪器仪表,进口供应商 

isrequered    islistcol                                                     issearch

1                        1              NULL NULL NULL NULL   0


50 2 单位名称 1 NULL 1 1 NULL NULL NULL NULL 1
50 3 单位地址 1 NULL 1 0 NULL NULL NULL NULL 0
50 4 业务范围 1 NULL 1 0 NULL NULL NULL NULL 0
50 5 等级类别 4 A,B,C,D 1 1 NULL NULL NULL NULL 0
50 6 涉及型号 1 NULL 0 0 NULL NULL NULL NULL 0
50 7 备注 3 NULL 0 0 NULL NULL NULL NULL 1
50 8 认定时间 2 NULL 1 0 date NULL NULL NULL 0

5、cs/iar/iarReportColumn.cs

第1215行的10改成8.

 

6、secure/report/fullQuarteryEidter.aspx  

第127行

else if (GetQueryString("TYPE") == "11" && (i == 14 || i == 15 || i == 16 || i == 17))

第130行

 if (AllV[i - 14].checked)

 

7、secure/report/FullQuarterlyDisplay.aspx

第27行添加 “, 'input.print-button'”

 

7、cs/page/FullQuateryList.aspx.cs

第5389行到5391行

 string[] Cols50 = new string[] {"分类", "单位名称", "地址", "负责人(联系人)", "电话", "协作内容(主营业务)", "涉及型号", "供方等级", "备注" };
                   dt = iarRPTBColu.Converts(ds, Cols50, colds, strWhere);
                   Cols50 = new string[] { "分类","序号", "单位名称", "地址", "负责人(联系人)", "电话", "协作内容(主营业务)", "涉及型号", "供方等级", "备注" };

 

 

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值