帝王谷资源网 Design By www.wdxyy.com
前台:
复制代码 代码如下:
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 += "<tr><td><lable name="infor"> " + item.description + "</lable> </td>";
strDeviceTr += "<td> </td>";
strDeviceTr += " <td><lable name="infor"> " + item.hoursdays + "</lable></td>";
strDeviceTr += "<td> 0.8</td>";
strDeviceTr += "<td><lable name="infor"> " + item.workinghour + " </lable></td>";
strDeviceTr += "<td> 0.8</td>";
strDeviceTr += "<td><lable name="infor"> " + item.workinghour + "</lable></td>";
strDeviceTr += "<td> </td>";
strDeviceTr += "</tr>";
});
$("#infor").append(strDeviceTr);
});
}
}
ashx
复制代码 代码如下:
string innerid = CommonClass.Request.GetRequest<string>("InnerID", "");
string key = CommonClass.Request.GetRequest<string>("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 < dt.Rows.Count; 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
复制代码 代码如下:
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 += "<tr><td><lable name="infor"> " + item.description + "</lable> </td>";
strDeviceTr += "<td> </td>";
strDeviceTr += " <td><lable name="infor"> " + item.hoursdays + "</lable></td>";
strDeviceTr += "<td> 0.8</td>";
strDeviceTr += "<td><lable name="infor"> " + item.workinghour + " </lable></td>";
strDeviceTr += "<td> 0.8</td>";
strDeviceTr += "<td><lable name="infor"> " + item.workinghour + "</lable></td>";
strDeviceTr += "<td> </td>";
strDeviceTr += "</tr>";
});
$("#infor").append(strDeviceTr);
});
}
}
ashx
复制代码 代码如下:
string innerid = CommonClass.Request.GetRequest<string>("InnerID", "");
string key = CommonClass.Request.GetRequest<string>("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 < dt.Rows.Count; 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
帝王谷资源网 Design By www.wdxyy.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
帝王谷资源网 Design By www.wdxyy.com
暂无评论...
更新日志
2024年10月28日
2024年10月28日
- 群星2013-青春缤纷辑压箱宝大公开3CD2[新加坡限量版][WAV整轨]
- 林育群.2013-BalladShow(日本版)【环球】【WAV+CUE】
- 陈加洛.1992-痛到感觉不到【宝丽金】【WAV+CUE】
- 群星.2023-宿命之敌电视剧原声带【韶愔音乐】【FLAC分轨】
- 東京事変-大発見[FLAC+CUE]
- 椎名林檎-三文ゴシップ[FLAC+CUE]
- 2024年08月04日
- 裘德《裘德「最后的水族馆」演唱会LIVE》[320K/MP3][228.89MB]
- 裘德《裘德「最后的水族馆」演唱会LIVE》[24bit 48kHz][FLAC/分轨][2.08G]
- 基因三重奏《如果你什么都不说 音乐会现场录音》[320K/MP3][145.37MB]
- 孟庭苇.1996-月亮说话(2020环球24KGOLD限量版)【上华】【WAV+CUE】
- 群星.1997-新艺宝优质音响系列·国语精选监听版【新艺宝】【WAV+CUE】
- 阿桑.2005-寂寞在唱歌(星外星引进版)【华研国际】【WAV+CUE】
- 基因三重奏《如果你什么都不说 音乐会现场录音》[FLAC/分轨][287.43MB]
- 蔡题谦《我爱你,却依然要看你走》[320K/MP3][88.65MB]