前台:
复制代码 代码如下:
function selectproject() {
            var a = new array;
            var r = window.showmodaldialog('selproject.aspx', a, dialogwidth=1000px; dialogheight=600px; resizable: yes);
            if (typeof (r) != 'undefined') {
                var arr = r.split(;);
                $(#hidprojectinnerid).val(arr[0]);
                $(#txtprojectno).val(arr[1]);
                $.getjson(../handler/getprojectinfor.ashx, { key: paymentstatement, innerid: $(#hidprojectinnerid).val() },
                        function (json) {
                            $(#labfinalcustomer).text(json.finalclient);
                            $(#laborderno).text(json.orderno);
                            var strdevicetr = ;
                            $.each(json.workinghours, function (i, item) {
                                strdevicetr += + item.description + ;
                                strdevicetr +=    ;
                                strdevicetr += + item.hoursdays + ;
                                strdevicetr +=   0.8 ;
                                strdevicetr += + item.workinghour + ;
                                strdevicetr +=   0.8 ;
                                strdevicetr += + item.workinghour + ;
                                strdevicetr +=   ;
                                strdevicetr +=
;
                            });
                            $(#infor).append(strdevicetr);
                        });
            }
        }
ashx
 复制代码 代码如下:
string innerid = commonclass.request.getrequest(innerid, );
            string key = commonclass.request.getrequest(key, );
            string result = ;
            if (key == stockoutapp && innerid != )
            {
                result = stockoutapp(innerid);
                context.response.write(result);
            }
            else if (key == paymentstatement && innerid != )
            {
                result = paymentstatement(innerid);
                context.response.write(result);
            }
#region 结算单信息
        public string paymentstatement(string _innerid)
        {
            try
            {
                string sql = @select innerid,pfinalclient,porderno from se_projectmain where innerid=' + _innerid + ';
                datatable dt = sqlshift.getdatatable(sql);
                if (!commonclass.dtrow.checkdtisempty(dt))
                {
                    stringbuilder json = new stringbuilder();
                     json.append(innerid:+dt.rows[0][innerid].tostring()+);
                     json.append(,finalclient: + dt.rows[0][pfinalclient].tostring() + );
                     json.append(,orderno: + dt.rows[0][porderno].tostring() + );
                    json.append(,workinghours: + getworkinghours(_innerid));
                    return { + json.tostring().trim(',') + };
                }
                else
                {
                    return string.empty;
                }
            }
            catch (exception ex)
            {
                applog.write(项目获取异常！[异常信息： + ex.message + ], applog.logmessagetype.info);
                return string.empty;
            }
        }
        public string getworkinghours(string _innerid)
        {
            try
            {
                string sql = @select innerid, wdescription,wworkinghour,whours_days from se_projectworkinghour where wprojectid=' + _innerid + ';
                datatable dt = sqlshift.getdatatable(sql);
                if (!commonclass.dtrow.checkdtisempty(dt))
                {
                    stringbuilder json = new stringbuilder();
                    for (int i = 0; i                     {
                        json.append({);
                        json.append(innerid: + dt.rows[0][innerid].tostring() + );
                        json.append(,description: + dt.rows[0][wdescription].tostring() + );
                        json.append(,workinghour: + dt.rows[0][wworkinghour].tostring() + );
                        json.append(,hoursdays: + dt.rows[0][whours_days].tostring() + );
                        json.append(},);
                    }
                    return [ + json.tostring().trim(',') + ];
                }
                else
                {
                    return string.empty;
                }
            }
            catch (exception ex)
            {
                applog.write(项目获取异常！[异常信息： + ex.message + ], applog.logmessagetype.info);
                return string.empty;
            }
        }
        #endregion