protected void Page_Load(object sender, EventArgs e)
{
var bindId = Request.Params["BindId"];
//bindId = "369949";
try
{
var strSql =
string.Format(@"select spmc,sl,ddzt,to_char(cjsj, 'yyyy/mm/dd hh24:mi:ss') as cjsj
from BO_TX_DDMX
where cgdid='{0}'
order by cjsj desc",
bindId);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathAws).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
var arry = 0;
Json = JsonConvert.SerializeObject(arry);
return;
}
var arrays = new Leo.Data.Table(dt).ToArray();
Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrays) + ")";
}
catch (Exception ex)
{
LogTool.WriteLog(typeof(GetPurchasingOrderDetail), ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
////身份校验
//if (!InterfaceTool.IdentityVerify(Request))
//{
// Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
// return;
//}
try
{
//获取上一个已评价
string strSql =
string.Format(@"select b.id from SER_EVALUATE a, HARBOR.TB_PRO_CONSIGNVEHICLE b
where a.createtime=(select max(createtime) from ser_evaluate) and a.veh_attest_no=b.ingateno");
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string strId = Convert.ToString(dt.Rows[0]["id"]);
Json = JsonConvert.SerializeObject(new DicPackage(true, strId, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取上一个已评价数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
/// <summary>
///
/// </summary>
/// <param name="strCodeCompany"></param>
/// <param name="strCodeStorage"></param>
/// <param name="strCodeAllocation"></param>
/// <param name="strCodeBooth"></param>
/// <returns></returns>
private string InsertAllocation(string strCodeCompany, string strCodeStorage, string strAllocation, string strCodeBooth)
{
string strSql = string.Empty;
string strCode = string.Empty;
strSql = string.Format(@"select count(*) as total from TB_CODE_ALLOCATION
where code_company='" + strCodeCompany + "' and code_storage='" + strCodeStorage + "' and code_booth='" + strCodeBooth + "' and allocation='" + strAllocation + "' ");
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCBase).ExecuteTable(strSql);
if (Convert.ToString(dt.Rows[0]["total"]) == "0")
{
//执行语句
strSql = string.Format(@"insert into TB_CODE_ALLOCATION(code_company,code_storage,code_booth,allocation)
values('{0}','{1}','{2}','{3}')", strCodeCompany, strCodeStorage, strCodeBooth, strAllocation);
new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCBase).ExecuteNonQuery(strSql);
strSql = string.Format(@"select CODE_ALLOCATION from TB_CODE_ALLOCATION
where code_company='" + strCodeCompany + "' and code_storage='" + strCodeStorage + "' and code_booth='" + strCodeBooth + "' and allocation='" + strAllocation + "' ");
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCBase).ExecuteTable(strSql);
if (dt.Rows.Count >= 0)
{
strCode = Convert.ToString(dt.Rows[0]["CODE_ALLOCATION"]);
}
}
else
{
strSql = "select distinct CODE_ALLOCATION from baseresource.TB_CODE_ALLOCATION where code_company='" + strCodeCompany + "' and ALLOCATION='" + strAllocation + "'";
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCBase).ExecuteTable(strSql);
if (dt.Rows.Count >= 0)
{
strCode = Convert.ToString(dt.Rows[0]["CODE_ALLOCATION"]);
}
}
return(strCode);
}
/// <summary>
/// 获取原始票货编码
/// </summary>
/// <param name="strGbno">源票货编码</param>
/// <returns></returns>
public string GetGbnofirst(string strGbno)
{
string strGbno2 = string.Empty;
string lGbno = string.Empty;
int c = 1;
string strSql = "select gbno from tb_hc_consign where gbno is not null and gbno<>'" + strGbno + "' and GBNO_FORCONSIGN='" + strGbno + "'";
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
if (dt.Rows.Count == 0)
{
return(strGbno);
}
strGbno2 = dt.Rows[0]["gbno"].ToString();
lGbno = strGbno + "," + strGbno2;
while (c > 0)
{
strSql = "select gbno from tb_hc_consign where gbno is not null and gbno not in (" + lGbno + ") and GBNO_FORCONSIGN='" + strGbno2 + "'";
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
c = dt.Rows.Count;
if (c == 0)
{
return(strGbno2);
}
strGbno2 = dt.Rows[0]["gbno"].ToString();
lGbno = lGbno + "," + strGbno2;
}
return(string.Empty);
}
/// <summary>
/// 获取理货单编码
/// </summary>
/// <param name="strCodeCompany">公司编码</param>
/// <returns></returns>
private string GetTbno()
{
string strJson = string.Empty;
string strSql = "select to_char(sysdate,'yyyymmdd') || lpad(to_char(TBNO_ID.Nextval),6,'0') as tbno from dual";
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "网络连接异常！").DicInfo());
return(strJson);
}
return(Convert.ToString(dt.Rows[0]["tbno"]));;
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//ID
string strId = Request.Params["Id"];
//strId = "41";
try
{
if (strId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取我的评价数据失败").DicInfo());
return;
}
//获取我的评价（处理结果）
string strSql =
string.Format(@"select evaluate,index_satisfy,to_char(evaluate_time, 'yyyy/mm/dd hh24:mi:ss') as evaluate_time
from ser_complain
where id='{0}'",
strId);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[] strArray = new string[3];
strArray[0] = Convert.ToString(dt.Rows[0]["evaluate"]);
string strIndex_satisfy = string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["index_satisfy"])) == true ? string.Empty : GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_satisfy"]));
strArray[1] = strIndex_satisfy;
strArray[2] = Convert.ToString(dt.Rows[0]["evaluate_time"]);
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取我的评价数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
/// <summary>
/// 更新采购订单明细
/// </summary>
/// <param name="strOrderId">采购单ID</param>
/// <param name="strOrderId">货物ID</param>
/// <param name="strOrderId">订单ID</param>
/// <param name="strOrderId">创建者</param>
/// <param name="strOrderState">订单状态</param>
/// <param name="strNum">数量</param>
/// <param name="strGoods">货物名称</param>
/// <returns>状态消息</returns>
private string UpdatePurchasingOrderDetail(string strPurchaseOrderId, string strGoodsId, string strOrderId, string strCreateUser, string strOrderState, int strNum, string strGoods)
{
string strJson = string.Empty;
try
{
//校验采购单货物数据
string strSql =
string.Format("select * from BO_TX_WZCGMX where BINDID='{0}' and ID='{1}'", strPurchaseOrderId, strGoodsId);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathAws).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "采购单ID、货物ID不存在！").DicInfo());
return(strJson);
}
strSql =
string.Format(@"select * from BO_TX_DDMX
where CGDID='{0}' and CPID='{1}' and DDID='{2}'",
strPurchaseOrderId, strGoodsId, strOrderId);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathAws).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
strSql =
string.Format(@"insert into BO_TX_DDMX(CGDID,CPID,DDID,DDZT,SL,SPMC)
values('{0}','{1}','{2}','{3}','{4}','{5}')",
strPurchaseOrderId, strGoodsId, strOrderId, strOrderState, Convert.ToString(strNum), strGoods);
}
else
{
strSql =
string.Format(@"update BO_TX_DDMX set DDZT='{0}',SL='{1}',SPMC='{2}'
where CGDID='{3}' and CPID='{4}' and DDID='{5}'",
strOrderState, Convert.ToString(strNum), strGoods, strPurchaseOrderId, strGoodsId, strOrderId);
// strSql =
// string.Format(@"update BO_DDMX set DDZT='{0}',SL='{1}',UPDATEDATE=to_date('{2}','yyyy/mm/dd hh24:mi:ss')
// where CGDID='{3}' and CPID='{4}' and DDID='{5}'",
// strOrderState, Convert.ToString(strNum), DateTime.Now, strPurchaseOrderId, strGoodsId, strOrderId);
}
new Leo.Oracle.DataAccess(RegistryKey.KeyPathAws).ExecuteNonQuery(strSql);
}
catch (Exception ex)
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：更新采购订单明细数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
return(strJson);
}
/// <summary>
/// 更新物资采购
/// </summary>
/// <param name="strPurchaseOrderId">采购单ID</param>
/// <param name="strGoodsId">货物ID</param>
/// <returns>状态消息</returns>
private string UpdateMaterialsPurchasing(string strPurchaseOrderId, string strGoodsId)
{
string strJson = string.Empty;
try
{
//订单收货数量总和
int sumOrderGoodsNum = 0;
//实际收货数量
int actualGoodsNum = 0;
//校验采购单货物数据
string strSql =
string.Format("select * from BO_TX_WZCGMX where BINDID='{0}' and ID='{1}'", strPurchaseOrderId, strGoodsId);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathAws).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "采购单ID、货物ID不存在！").DicInfo());
return(strJson);
}
actualGoodsNum = string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["SJDH"])) == true ? 0 : Convert.ToInt32(dt.Rows[0]["SJDH"]);
//校验数量
strSql =
string.Format("select SL from BO_TX_DDMX where CGDID='{0}' and CPID='{1}'", strPurchaseOrderId, strGoodsId);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathAws).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
sumOrderGoodsNum += Convert.ToInt32(dt.Rows[iRow]["SL"]);
}
}
if (sumOrderGoodsNum != actualGoodsNum)
{
strSql =
string.Format("update BO_TX_WZCGMX set SJDH='{0}' where BINDID='{1}' and ID='{2}'", sumOrderGoodsNum, strPurchaseOrderId, strGoodsId);
new Leo.Oracle.DataAccess(RegistryKey.KeyPathAws).ExecuteNonQuery(strSql);
}
}
catch (Exception ex)
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：更新物资采购数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
return(strJson);
}
/// <summary>
/// 保存作业票
/// </summary>
/// <param name="strGbno">TallyBillE对象</param>
/// <returns></returns>
public bool SaveTB(TallyBillE tb)
{
//校验作业票是否是重复生成
if (tb.Pmno != string.Empty)
{
string strFilter = string.Format(" where tbno='{0}'", tb.Tbno);
string strSql = string.Format("select * from tb_hs_tallybill{0}", strFilter);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)//已存在，更新
{
string strUpdate_Hs_Tallybill = @"update vw_reg_tallybill set code_department='{0}',amount='{1}',weight='{2}',code_tallyman='{3}',tallyman='{4}',code_company='{5}', modifier='{6}',modifiername='{7}',modifytime=to_date('{10}', 'yyyy/mm/dd hh24:mi:ss'),amount2='{8}',mark_finish='{9}'" + strFilter;
strSql = string.Format(strUpdate_Hs_Tallybill, tb.Code_Department, tb.Amount, tb.Weight, tb.Code_Tallyman, tb.Tallyman, tb.Code_Company,
tb.Creator, tb.Creatorname, tb.Amount2, tb.Mark_finish, tb.AuditTime);
da.ExecuteNonQuery(strSql);
}
else//不存在，插入
{
string strInsert_Hs_Tallybill = "insert into vw_reg_tallybill(tbno,pmno,gbno,signdate,code_department,taskno,cgno,code_storage,code_booth,CODE_ALLOCATION,vgno,cabin,code_carrier,carriernum,NSNO_BARGE,bargepro,pieceweight,amount,weight,volume,code_measure,begintime,endtime,code_operation,code_operation_fact,code_quality,code_workflow,code_trainroad,workteam,code_worktime,code_teamtype,code_tallyman,tallyman,code_storagelast,code_boothlast,CODE_ALLOCATIONLAST,vgnolast,cabinlast,code_carrierlast,carriernumlast,NSNO_BARGELAST,bargeprolast,carrier1,carrier1num,carrier2,carrier2num,code_opstype,remark,gbdisplay,tallynum,gbnolast,gbdisplaylast,gbnofirst,containernum,parenttbno,gbnofromstock,code_company,code_section,trainnum,tallydate,mark_comp_plan,mark_comp_goodsbill,mark_comp_ship,code_billtype,creator,creatorname,createtime,code_motorcade,code_storage_stock,code_booth_stock,CODE_ALLOCATION_STOCK,code_opstype_fact,drivernum,workernum,amount2,code_workteam,machine,CODE_WORKINGAREA,CODE_WORKINGAREALAST,mark_finish,CARRIER1A,CARRIER2A) " +
" values('{0}','{1}','{2}',to_date('{3}','yyyy-mm-dd hh24:mi:ss'),'{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}', '{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}','{33}','{34}','{35}','{36}','{37}','{38}','{39}','{40}','{41}','{42}','{43}','{44}','{45}','{46}','{47}','{48}','{49}','{50}','{51}','{52}','{53}','{54}','{55}','{56}','{57}','{58}',to_date('{59}','yyyy-mm-dd hh24:mi:ss'),'{60}','{61}','{62}','{63}','{64}','{65}',to_date('{79}', 'yyyy/mm/dd hh24:mi:ss'),'{66}','{67}','{68}','{69}','{70}','{71}','{72}','{73}','{74}','{75}','{76}','{77}','{78}','{79}','{80}')";
strSql = string.Format(strInsert_Hs_Tallybill, tb.Tbno, tb.Pmno, tb.Gbno, tb.Signdate.ToString(),
tb.Code_Department, tb.Taskno, tb.Cgno, tb.Code_Storage, tb.Code_Booth, tb.code_allocation, tb.Vgno,
tb.Cabin, tb.Code_Carrier, tb.Carriernum, tb.NSNO_BARGE, tb.Bargepro, tb.Pieceweight,
tb.Amount, tb.Weight, tb.Volume, tb.Code_Measure, tb.Begintime, tb.Endtime,
tb.Code_Operation, tb.Code_Operation_Fact, tb.Code_Quality, tb.Code_workflow, tb.Code_trainroad, tb.Workteam,
tb.Code_Worktime, tb.Code_Teamtype, tb.Code_Tallyman, tb.Tallyman, tb.Code_Storagelast,
tb.Code_Boothlast, tb.code_allocationlast, tb.Vgnolast, tb.Cabinlast, tb.Code_Carrierlast,
tb.Carriernumlast, tb.NSNO_BARGELAST, tb.Bargeprolast, tb.Carrier1, tb.Carrier1num, tb.Carrier2, tb.Carrier2num,
tb.Code_Opstype, tb.Remark, tb.Gbdisplay, tb.Tallynum, tb.Gbnolast,
tb.Gbdisplaylast, tb.Gbnofirst, tb.Containernum,
tb.Parenttbno, tb.Gbnofromstock, tb.Code_Company, tb.Code_Section, tb.Trainnum, tb.Tallydate,
tb.Mark_comp_plan, tb.Mark_comp_goodsbill, tb.Mark_comp_ship, tb.Code_billtype,
tb.Creator, tb.Creatorname, tb.Code_motorcade, tb.Code_Storage_Stock, tb.Code_Booth_Stock, tb.code_allocationstock,
tb.Code_opstype_fact, tb.Drivernum,
tb.Workernum, tb.Amount2, tb.Code_Workteam, tb.Machine, tb.code_workingarea, tb.code_workingarealast, tb.Mark_finish, tb.Carrier1A, tb.Carrier2A);
da.ExecuteNonQuery(strSql);
}
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//ID
string strId = Request.Params["Id"];
//strId = "211";
try
{
if (strId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取评价详情数据失败").DicInfo());
return;
}
//获取待评价详情
string strSql =
string.Format(@"select t.id,t.veh_attest_no,t.driverphone,t.finish_mark,t.evaluate_hall,t.evaluate_dock,t.evaluate_gate,t.index_attitude,t.index_audit,t.index_make,t.index_overall,to_char(t.createtime, 'yyyy/mm/dd hh24:ss:mi') as evaluatetime,
t.hall_comment,to_char(t.hall_time, 'yyyy/mm/dd hh24:mi:ss') as hall_time,t.dock_comment,to_char(t.dock_time, 'yyyy/mm/dd hh24:ss:mi') as dock_time,t.gate_comment,to_char(t.gate_time, 'yyyy/mm/dd hh24:ss:mi') as gate_time
from ser_evaluate t where t.id='{0}'",
strId);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[] strArray = new string[18];
strArray[0] = Convert.ToString(dt.Rows[0]["id"]);
strArray[1] = Convert.ToString(dt.Rows[0]["veh_attest_no"]);
strArray[2] = Convert.ToString(dt.Rows[0]["driverphone"]);
string strExplain = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["hall_time"])) || !string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["dock_time"])) || !string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["gate_time"])))
{
strExplain = "有说明";
}
strArray[3] = strExplain;
strArray[4] = Convert.ToString(dt.Rows[0]["evaluate_hall"]);
strArray[5] = Convert.ToString(dt.Rows[0]["evaluate_dock"]);
strArray[6] = Convert.ToString(dt.Rows[0]["evaluate_gate"]);
strArray[7] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_attitude"]));
strArray[8] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_audit"]));
strArray[9] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_make"]));
strArray[10] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_overall"]));
strArray[11] = Convert.ToString(dt.Rows[0]["evaluatetime"]);
strArray[12] = Convert.ToString(dt.Rows[0]["hall_comment"]);
strArray[13] = Convert.ToString(dt.Rows[0]["hall_time"]);
strArray[14] = Convert.ToString(dt.Rows[0]["dock_comment"]);
strArray[15] = Convert.ToString(dt.Rows[0]["dock_time"]);
strArray[16] = Convert.ToString(dt.Rows[0]["gate_comment"]);
strArray[17] = Convert.ToString(dt.Rows[0]["gate_time"]);
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取评价详情数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
/// <summary>
/// 保存班组
/// </summary>
/// <param name="strGbno">TallyBillE对象</param>
/// <returns></returns>
private string SaveWorkTeam(TallyBillE tb)
{
string strJson = string.Empty;
if (tb.TeamWorkData != string.Empty)
{
List <TeamWork> listTeamWork = JsonConvert.DeserializeObject <List <TeamWork> >(tb.TeamWorkData);
for (int iList = 0; iList < listTeamWork.Count; iList++)
{
Nullable <int> amount = null;
Nullable <decimal> weight = null;
Nullable <decimal> count = null;
TeamWork tw = listTeamWork[iList];
/*
*判断班组是否被选中，
* 1选中：判断是否已经存在；存在，更新；不存在，插入；
* 2未选中：判断是否已经存在；存在，删除；不存在，不用管；
*/
string strFilter = string.Format(" where tbno='{0}' and pmno='{1}' and code_workteam='{2}' and workno='{3}'", tb.Tbno, tb.Pmno, tw.code_workteam, tw.workno);
string strSql = string.Format("select * from TB_TALLY_WORKER{0}", strFilter);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
if (tw.select == "1")
{
if (string.IsNullOrWhiteSpace(tw.begintime) || string.IsNullOrWhiteSpace(tw.endtime))
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "班组起、至时间不能为空！").DicInfo());
return(strJson);
}
if (!TokenTool.VerifyHoursAndMinute(tw.begintime) || !TokenTool.VerifyHoursAndMinute(tw.endtime))
{
strJson = JsonConvert.SerializeObject(new DicPackage(false, null, "班组起、至时间格式不正确！").DicInfo());
return(strJson);
}
strJson = VerifyAndSetQuantityData(tw.amount, tw.weight, tw.count, ref amount, ref weight, ref count);
if (!string.IsNullOrWhiteSpace(strJson))
{
return(strJson);
}
Nullable <decimal> strWeightConfirm = tb.Mark_finish == '1' ? count : null;
if (dt.Rows.Count > 0)//已存在，更新
{
strSql =
string.Format(@"update TB_TALLY_WORKER set start_time='{0}',end_time='{1}',amount='{2}',weight='{3}',worknum='{4}',weight_confirm='{5}',modifytime=to_date('{6}','yyyy-mm-dd hh24:mi:ss'),modifier='{7}',modifiername='{8}'",
tw.begintime.Remove(2, 1), tw.endtime.Remove(2, 1), amount, weight, count, strWeightConfirm, tb.AuditTime, tb.Creator, tb.Creatorname);
}
else//不存在，插入
{
strSql =
string.Format(@"insert into TB_TALLY_WORKER(pmno,tbno,code_workteam,workno,start_time,end_time,amount,weight,worknum,code_department,weight_confirm,createtime,creator,creatorname)
values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}',to_date('{11}','yyyy-mm-dd hh24:mi:ss'),'{12}','{13}')",
tb.Pmno, tb.Tbno, tw.code_workteam, tw.workno, tw.begintime.Remove(2, 1), tw.endtime.Remove(2, 1), amount, weight, count, tb.Code_Department, strWeightConfirm, tb.AuditTime, tb.Creator, tb.Creatorname);
}
}
else
{
if (dt.Rows.Count > 0)//已存在，删除
{
strSql =
string.Format("delete from TB_TALLY_WORKER{0}", strFilter);
}
}
da.ExecuteNonQuery(strSql);
}
}
return(strJson);
}
protected void Page_Load(object sender, EventArgs e)
{
////http://218.92.115.55/M_Lhgl/Service/Slip/SaveTallyBill.aspx
var codeCompany = Request.Params["CodeCompany"];
var codeDepartment = Request.Params["CodeDepartment"];
var pmno = Request.Params["Pmno"];
var cgno = Request.Params["Cgno"];
var codeTallyman = Request.Params["CodeTallyman"];
var tallyman = Request.Params["Tallyman"];
var vgno = Request.Params["Vgno"];
var cabin = Request.Params["Cabin"];
var codeCarrier = Request.Params["CodeCarrier"];
var carrierNum = Request.Params["CarrierNum"];
var codeNvessel = Request.Params["CodeNvessel"];
var bargepro = Request.Params["Bargepro"];
var codeStorage = Request.Params["CodeStorage"];
var codeBooth = Request.Params["CodeBooth"];
var codeAllocation = Request.Params["CodeAllocation"];
var allocation = Request.Params["Allocation"].Trim();
//var allocation = Request.Params["CodeAllocation"];
var carrier1 = Request.Params["Carrier1"];
var carrier1Num = Request.Params["Carrier1Num"];
var vgnoLast = Request.Params["VgnoLast"];
var cabinLast = Request.Params["CabinLast"];
var codeCarrierLast = Request.Params["CodeCarrierLast"];
var carrierNumLast = Request.Params["CarrierNumLast"];
var codeNvesselLast = Request.Params["CodeNvesselLast"];
var bargeproLast = Request.Params["BargeproLast"];
var codeStorageLast = Request.Params["CodeStorageLast"];
var codeBoothLast = Request.Params["CodeBoothLast"];
var codeAllocationLast = Request.Params["CodeAllocationLast"].Trim();
var allocationLast = Request.Params["AllocationLast"].Trim();
//var allocationLast = Request.Params["CodeAllocationLast"].Trim();
var carrier2 = Request.Params["Carrier2"];
var carrier2Num = Request.Params["Carrier2num"];
var codeGoodsBill = Request.Params["CodeGoodsBill"];
var goodsBillDisplay = Request.Params["GoodsBillDisplay"];
var codeGbBusiness = Request.Params["CodeGbBusiness"];
var gbBusinessDisplay = Request.Params["GbBusinessDisplay"];
var codeSpecialMark = Request.Params["CodeSpecialMark"];
var codeWorkingArea = Request.Params["CodeWorkingArea"];
var codeWorkingAreaLast = Request.Params["CodeWorkingAreaLast"];
var quality = Request.Params["Quality"];
var amount = Request.Params["Amount"].Trim();
var weight = Request.Params["Weight"].Trim();
var count = Request.Params["Count"].Trim();
var amount2 = Request.Params["Amount2"].Trim();
var weight2 = Request.Params["Weight2"].Trim();
var count2 = Request.Params["Count2"].Trim();
var trainNum = Request.Params["TrainNum"].Trim();
var machine = Request.Params["Machine"];
var workTeam = Request.Params["WorkTeam"];
var tbno = Request.Params["Tbno"].Trim();
var markFinish = Request.Params["MarkFinish"].Trim();
var codeOperationFact = Request.Params["CodeOperationFact"];
tallyman = "PDA测试员";
// string message = string.Format(@"vgno:'{0}', cabin:'{1}', codeCarrier:'{2}', carrierNum:'{3}',codeNvessel:'{4}',
// bargepro:'{5}',codeStorage:'{6}',codeBooth:'{7}',codeAllocation:'{8}', +
// vgnoLast:'{9}', cabinLast:'{10}', codeCarrierLast:'{11}', carrierNumLast:'{12}',codeNvesselLast:'{13}',
// bargeproLast:'{14}',codeStorageLast:'{15}',codeBoothLast:'{16}',codeAllocationLast:'{17}' , +
// carrier1:'{18}', carrier1Num:'{19}', carrier2:'{20}', carrier2Num:'{21}'",
// vgno, cabin, codeCarrier, carrierNum, codeNvessel, bargepro, codeStorage, codeBooth, codeAllocation, vgnoLast, cabinLast, codeCarrierLast, carrierNumLast, codeNvesselLast, bargeproLast, codeStorageLast, codeBoothLast, codeAllocationLast, carrier1, carrier1Num, carrier2, carrier2Num);
// Json = JsonConvert.SerializeObject(new DicPackage(false, null, message).DicInfo());
// return;
////测试
//codeCompany = "14";
//codeDepartment = "24";
//pmno = "20151010000161";
//cgno = "d1bff20fa2d54a0b87e4385a5cb46914";
//codeTallyman = "227";
//tallyman = "申";
//vgno = "20151003000002";
//cabin = "";
//codeCarrier = "";
//carrierNum = "";
//CodeNvessel = "";
//bargepro = "";
//codeStorage = "1";
//codeBooth = "185";
//codeAllocation = "";
//carrier1 = "中韩之星_2099999";
//carrier1Num = "";
//vgnoLast = "";
//cabinLast = "";
//codeCarrierLast = "";
//carrierNumLast = "";
//codeNvesselLast = "";
//bargeproLast = "";
//codeStorageLast = "111";
//codeBoothLast = "183";
//codeAllocationLast = "";
//carrier2 = "009场";
//carrier2Num = "无";
//codeGoodsBill = "1facb087e4654ddead033fb25552e358";
//goodsBillDisplay = "淮钢/铁矿石/散/0吨/进口/内贸/中韩之星_20151003_1/b/0/12232";
//codeGbBusiness = "1facb087e4654ddead033fb25552e358";
//gbBusinessDisplay = "淮钢/铁矿石/散/0吨/进口/内贸/中韩之星_20151003_1/b/0/12232";
//codeSpecialMark = "";
//codeWorkingArea = "";
//codeWorkingAreaLast = "";
//quality = "合格";
//amount = "123";
//weight = "123.4";
//count = Request.Params["Count"];
//amount2 = Request.Params["Amount2"];
//weight2 = Request.Params["Weight2"];
//count2 = Request.Params["Count2"];
//machine = Request.Params["Machine"];
//workTeam = Request.Params["WorkTeam"];
//trainNum = "23";
//tbno = "20151112064082";
////tbno = string.Empty;
//markFinish = "1";
//var codeCompany = "14";
//var codeDepartment = "24";
//var pmno = "20151010000161";
//var cgno = "d1bff20fa2d54a0b87e4385a5cb46914";
//var codeTallyman = "227";
//var tallyman = "薛辉";
//var vgno = "20151003000002";
//var cabin = "";
//var codeCarrier = "";
//var carrierNum = "";
//var codeNvessel = "";
//var bargepro = "";
//var codeStorage = "";
//var codeBooth = "";
//var codeAllocation = "";
//var carrier1 = "中韩之星_2099999";
//var carrier1Num = "";
//var vgnoLast = "";
//var cabinLast = "";
//var codeCarrierLast = "";
//var carrierNumLast = "";
//var codeNvesselLast = "";
//var bargeproLast = "";
//var codeStorageLast = "";
//var codeBoothLast = "";
//var codeAllocationLast = "";
//var carrier2 = "";
//var carrier2Num = "";
//var codeGoodsBill = "1facb087e4654ddead033fb25552e358";
//var goodsBillDisplay = "淮钢/铁矿石/散/0吨/进口/内贸/中韩之星_20151003_1/b/0/12232";
//var codeGbBusiness = "";
//var gbBusinessDisplay = "";
//var codeSpecialMark = "101";
//var codeWorkingArea = "66D0FE5D86DB45AFB4B572C9AF09D939";
//var codeWorkingAreaLast = "66D0FE5D86DB45AFB4B572C9AF09D939";
//var quality = "合格";
//var amount = "10";
//var weight = "123";
//var count = "11";
//var amount2 = "";
//var weight2 = "";
//var count2 = "";
////var machine = "[{\"endtime\"1412\"\",\"amount\":\"\",\"pmno\":\"20151021000241\",\"weight\":\"\",\"workno\":\"\",\"count\":\"\",\"begintime\":\"1512\",\"select\":\"1\",\"name\":\"111\",\"code_machine\":\"2C-6-11\",\"machine\":\"6t叉车\"},{\"endtime\":\"\",\"amount\":\"\",\"pmno\":\"20151021000241\",\"weight\":\"\",\"workno\":\"\",\"count\":\"\",\"begintime\":\"\",\"select\":\"1\",\"name\":\"\",\"code_machine\":\"2Q-25-01\",\"machine\":\"牵引车\"}]";
//var machine = "[{\"endtime\":\"15:33\",\"amount\":\"11\",\"pmno\":\"20151010000161\",\"weight\":\"12.3\",\"workno\":\"3\",\"count\":\"\",\"begintime\":\"14:12\",\"select\":\"1\",\"name\":\"\",\"code_machine\":\"2ZJK-2D-12\",\"machine\":\"集卡\"}]";
//var workTeam = "";
//var trainNum = "";
////var tbno = "20151112064117";
//var tbno = string.Empty;
//var markFinish = "0";
//调发货标志
string strMarkExchange = string.Empty;
string strTallydate = string.Empty;
string strTaskNo = string.Empty;
string strGbno = string.Empty;
string strGbdisplay = string.Empty;
string strGbnolast = string.Empty;
string strGbdisplaylast = string.Empty;
string strCodeMeasure = string.Empty;
string strCodeOpstype = string.Empty;
string strCodeBillType = string.Empty;
string strGbnoFromStock = string.Empty;
string strCodeStorageStock = string.Empty;
string strCodeBoothStock = string.Empty;
string strCodeAllocationStock = string.Empty;
string strGbnoFirst = string.Empty;
string strCodeOperation = string.Empty;
string strCodeOperationFact = string.Empty;
string strCodeOpstypeFact = string.Empty;
string strCodeWorkflow = string.Empty;
string strCodeWorkTime = string.Empty;
string strCodeTeamType = string.Empty;
string strCodeTrainRode = string.Empty;
string strCodeMotorcade = string.Empty;
string strBeginTime = string.Empty;
string strEndTime = string.Empty;
string strNsnoBarge = string.Empty;
string strNsnoBargeLast = string.Empty;
DateTime strCurTime = DateTime.Now;
TallyBillE tallybille = new TallyBillE();
try
{
//获取调发货标志
string strSql =
string.Format("select mark_exchange,mark_last from vw_hc_consign where cgno='{0}'", cgno);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strMarkExchange = Convert.ToString(dt.Rows[0]["mark_exchange"]);;
}
//获取理货日期、进出库类别代码、分解过程的进出库类别代码
strSql =
string.Format(@"select code_storage,code_storagelast,mark_tallybill,code_operation,code_operation_fact,CODE_CARRIER_S,CODE_CARRIER_E,vgdisplay,vgno,cabin,code_carrier,nvessel,
code_nvessel,carrier1,nsno,tallydate,code_opstype,code_workflow,code_worktime,code_teamtype,code_trainroad,code_motorcade,begintime,endtime,nsno_barge,nsno_bargelast
from vw_ps_mission where pmno='{0}'",
pmno);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strTallydate = Convert.ToString(dt.Rows[0]["tallydate"]);
strCodeOpstype = Convert.ToString(dt.Rows[0]["code_opstype"]);
strCodeOpstypeFact = Convert.ToString(dt.Rows[0]["code_opstype"]);
strCodeWorkflow = Convert.ToString(dt.Rows[0]["code_workflow"]);
strCodeWorkTime = Convert.ToString(dt.Rows[0]["code_worktime"]);
strCodeTeamType = Convert.ToString(dt.Rows[0]["code_teamtype"]);
strCodeTrainRode = Convert.ToString(dt.Rows[0]["code_trainroad"]);
strCodeMotorcade = Convert.ToString(dt.Rows[0]["code_motorcade"]);
strBeginTime = Convert.ToString(dt.Rows[0]["begintime"]);
strEndTime = Convert.ToString(dt.Rows[0]["endtime"]);
strNsnoBarge = Convert.ToString(dt.Rows[0]["nsno_barge"]);
strNsnoBargeLast = Convert.ToString(dt.Rows[0]["nsno_bargelast"]);
strCodeOperation = Convert.ToString(dt.Rows[0]["code_operation"]);
strCodeOperationFact = Convert.ToString(dt.Rows[0]["code_operation_fact"]);
}
//获取任务号、目的票货编码、目的票货描述
strSql =
string.Format(@"select GBDISPLAY,GBNO,MARK_EXCHANGE,HZGOODSBILL,MARK_LAST,CODE_CARRIER_S,CODE_CARRIER_E,TASKNO from VW_HC_CONSIGN_GBNO where code_company='{0}' and cgno='{1}'",
codeCompany, cgno);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strTaskNo = Convert.ToString(dt.Rows[0]["taskno"]);
}
strGbnolast = codeGbBusiness;
strGbdisplaylast = gbBusinessDisplay;
//获取计量单位编码、票货类型、源票货编码、源票货描述....
strSql =
string.Format(@"select code_measure from tb_hc_goodsbill where gbno='{0}'",
codeGoodsBill);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strCodeMeasure = Convert.ToString(dt.Rows[0]["code_measure"]);
}
strCodeBillType = "0";
strGbno = codeGoodsBill;
strGbdisplay = goodsBillDisplay;
//校验和赋值货位（堆）数据
Json = VerifyAndSetAllocationData(codeCompany, codeStorage, allocation, codeBooth, strCodeOpstype, ref codeAllocation);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
Json = VerifyAndSetAllocationData(codeCompany, codeStorageLast, allocationLast, codeBoothLast, strCodeOpstype, ref codeAllocationLast);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
if (strMarkExchange == "1")//调发货
{
strGbno = codeGbBusiness;
strGbdisplay = gbBusinessDisplay;
//strSql =
// string.Format("select gbno,exdisplay,gbdisplay,code_storage,code_booth,storage,booth from vw_hc_consign_adjust2 where cgno='{0}'", cgno);
//dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathZCHarbor).ExecuteTable(strSql);
//if (dt.Rows.Count > 0)
//{
// codeStorage = Convert.ToString(dt.Rows[0]["code_storage"]);
// codeBooth = Convert.ToString(dt.Rows[0]["code_booth"]);
// carrier1 = Convert.ToString(dt.Rows[0]["storage"]);
// carrier1Num = Convert.ToString(dt.Rows[0]["booth"]);
//}
//codeStorage = Convert.ToString(dt.Rows[0]["code_storage"]);
//codeBooth = Convert.ToString(dt.Rows[0]["code_booth"]);
//carrier1 = Convert.ToString(dt.Rows[0]["storage"]);
//carrier1Num = Convert.ToString(dt.Rows[0]["booth"]);
strGbnoFromStock = codeGoodsBill;
strCodeStorageStock = codeStorage;
strCodeBoothStock = codeBooth;
if (strCodeOpstype == "1")//作业方式属于进港
{
//判断是否已存在，存在返回编码，不存在则插入，并取回生成的编码
strCodeAllocationStock = InsertAllocation(codeCompany, strCodeStorageStock, allocation, strCodeBoothStock);
}
else
{
strCodeAllocationStock = codeAllocation;
}
}
//获取原始票货编码
strGbnoFirst = GetGbnofirst(strGbno);
//获取理货单编码
if (markFinish == "0" && string.IsNullOrWhiteSpace(tbno))
{
tbno = GetTbno();
}
if (markFinish == "1" && string.IsNullOrWhiteSpace(tbno))
{
tbno = GetTbno();
}
//赋值
tallybille.Code_Company = codeCompany;
tallybille.Code_Department = codeDepartment;
tallybille.Cgno = cgno;
tallybille.Pmno = pmno;
tallybille.Code_Tallyman = codeTallyman;
tallybille.Tallyman = tallyman;
tallybille.Vgno = vgno;
tallybille.Cabin = cabin;
tallybille.Code_Carrier = codeCarrier;
tallybille.Carriernum = carrierNum;
tallybille.Code_nvessel = codeNvessel;
tallybille.Bargepro = bargepro;
tallybille.Code_Storage = codeStorage;
tallybille.Code_Booth = codeBooth;
tallybille.code_allocation = codeAllocation;
tallybille.Carrier1 = carrier1;
tallybille.Carrier1num = carrier1Num;
tallybille.Vgnolast = vgnoLast;
tallybille.Cabinlast = cabinLast;
tallybille.Code_Carrierlast = codeCarrierLast;
tallybille.Carriernumlast = carrierNumLast;
tallybille.Code_nvessellast = codeNvesselLast;
tallybille.Bargeprolast = bargeproLast;
tallybille.Code_Storagelast = codeStorageLast;
tallybille.Code_Boothlast = codeBoothLast;
tallybille.code_allocationlast = codeAllocationLast;
tallybille.Carrier2 = carrier2;
tallybille.Carrier2num = carrier2Num;
tallybille.Code_SpecialMark = codeSpecialMark;
tallybille.code_workingarea = codeWorkingArea;
tallybille.code_workingarealast = codeWorkingAreaLast;
tallybille.Code_Quality = quality == "合格" ? "01" : "02";
tallybille.Creator = codeTallyman;
tallybille.Creatorname = tallyman;
tallybille.Carrier1A = allocation;
tallybille.Carrier2A = allocationLast;
tallybille.Signdate = Convert.ToDateTime(strTallydate);
tallybille.Tallydate = Convert.ToDateTime(strTallydate);
tallybille.Code_Opstype = strCodeOpstype;
tallybille.Code_opstype_fact = strCodeOpstypeFact;
tallybille.Code_workflow = strCodeWorkflow;
tallybille.Code_Worktime = strCodeWorkTime;
tallybille.Code_Teamtype = strCodeTeamType;
tallybille.Code_trainroad = strCodeTrainRode;
tallybille.Code_motorcade = strCodeMotorcade;
tallybille.Begintime = strBeginTime;
tallybille.Endtime = strEndTime;
tallybille.NSNO_BARGE = strNsnoBarge;
tallybille.NSNO_BARGELAST = strNsnoBargeLast;
tallybille.Taskno = strTaskNo;
tallybille.Gbnolast = strGbnolast;
tallybille.Gbdisplaylast = strGbdisplaylast;
tallybille.Gbno = strGbno;
tallybille.Gbdisplay = strGbdisplay;
tallybille.Code_billtype = strCodeBillType;
tallybille.Gbnofromstock = strGbnoFromStock;
tallybille.Code_Storage_Stock = strCodeStorageStock;
tallybille.Code_Booth_Stock = strCodeBoothStock;
tallybille.code_allocationstock = strCodeAllocationStock;
tallybille.Gbnofirst = strGbnoFirst;
tallybille.Code_Operation = strCodeOperation;
tallybille.Code_Operation_Fact = strCodeOperationFact;
tallybille.Tbno = tbno;
tallybille.Mark_finish = Convert.ToChar(markFinish);
tallybille.MachineData = machine;
tallybille.TeamWorkData = workTeam;
tallybille.Mark_Audit = "1";
tallybille.AuditTime = strCurTime;
tallybille.Auditor = codeTallyman;
tallybille.Auditorname = tallyman;
//Json = JsonConvert.SerializeObject(new DicPackage(false, null, machine + '+' + workTeam).DicInfo());
//return;
//Json = JsonConvert.SerializeObject(new DicPackage(false, null, amount + weight).DicInfo());
//校验和赋值数量数据
Json = VerifyAndSetQuantityData(amount, amount2, weight, count, trainNum, ref tallybille);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
da.BeginTransaction();
//暂存或提交数据
if (tallybille.Mark_finish == '1')//提交
{
if (!SaveTB(tallybille))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "提交失败！").DicInfo());
}
Json = SaveMachine(tallybille);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
Json = SaveWorkTeam(tallybille);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
//if (!AuditTB(tallybille))
//{
// Json = JsonConvert.SerializeObject(new DicPackage(false, null, "提交失败！").DicInfo());
//}
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "提交成功！").DicInfo());
}
else//暂存
{
if (!SaveTB(tallybille))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "暂存失败！").DicInfo());
}
Json = SaveMachine(tallybille);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
Json = SaveWorkTeam(tallybille);
if (!string.IsNullOrWhiteSpace(Json))
{
return;
}
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "暂存成功！").DicInfo());
}
da.CommitTransaction();
//string strKeyPath = "Software\\HarborSoft\\NHarborService";
//new DataAccessC(strKeyPath).GetDataSetByStoredProcedure("{ call PK_TALLYBILL_ACCOUNT.P_TALLYBILL_PIECERATE_MATCH('" + tallybille.Tbno + "')}");
}
catch (Exception ex)
{
da.RollbackTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：提交数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
protected void Page_Load(object sender, EventArgs e)
{
//账号
var account = Request.Params["Account"];
//交易源ID（货源ID）
var originId = Request.Params["OriginId"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (account == null || originId == null)
{
info.Add("参数Account，OriginId不能为空！举例", "http://218.92.115.55/M_Sph/Deal/DealForDriver.aspx?Account=1F4BA283C3F95122E053A86401695122&OriginId=944");
Json = JsonConvert.SerializeObject(info);
return;
}
//查询此货物是否已结束交易
string sql =
string.Format("select MARK_DEAL from TB_SPH_ORDER where CODE_CARGO_SOURCE = '{0}' and CODE_USER_SECOND='{1}'", originId, account);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathWlxgx).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsDeal", "No");
info.Add("Message", "网络错误，请稍后再试！");
Json = JsonConvert.SerializeObject(info);
return;
}
else
{
if (dt.Rows[0]["MARK_DEAL"].ToString() == "1")
{
info.Add("IsDeal", "No");
info.Add("Message", "网络错误，请稍后再试！");
Json = JsonConvert.SerializeObject(info);
return;
}
}
da.BeginTransaction();
//更新乙方订单记录
Json = UpdateSecondOrderRecord(account, originId);
if (Json != string.Empty)
{
return;
}
//更新货源交易标志（货源表）
Json = UpdateCargoSourceDealMark(originId);
if (Json != string.Empty)
{
return;
}
////甲方账号
//string firstAccount = dt.Rows[0]["firstaccount"].ToString();
////交易金额
//string amount = dt.Rows[0]["amount"].ToString();
////获取甲方交易后余额
//sql =
// string.Format("select * from TB_YGPH_FUND where account='{0}' and roletype='{1}' order by dealtime desc", firstAccount, "2");
//dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHmw).ExecuteTable(sql);
//if (dt.Rows.Count == 0)
//{
// info.Add("IsDeal", "No");
// info.Add("Message", "网络错误，请稍后再试！");
// Json = JsonConvert.SerializeObject(info);
// return;
//}
//string firstBalance = Convert.ToString( Convert.ToDouble(dt.Rows[0]["balance"]) - Convert.ToDouble(amount));
////获取乙方交易后余额
//sql =
// string.Format("select * from TB_YGPH_FUND where account='{0}' and roletype='{1}' order by dealtime desc", account, "1");
//dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHmw).ExecuteTable(sql);
//if (dt.Rows.Count == 0)
//{
// info.Add("IsDeal", "No");
// info.Add("Message", "网络错误，请稍后再试！");
// Json = JsonConvert.SerializeObject(info);
// return;
//}
//string secondBalance = Convert.ToString( Convert.ToDouble(dt.Rows[0]["balance"]) + Convert.ToDouble(amount));
////插入资金交易记录
////甲方（货主）为支出
//sql =
// string.Format("insert into TB_YGPH_FUND (account,expense,balance,dealtime,roletype,content) values('{0}','{1}','{2}',to_date('{3}','YYYY-MM-DD HH24:MI:SS'),'{4}','{5}')", firstAccount, amount, firstBalance, DateTime.Now, "1", "交易");
//dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHmw).ExecuteTable(sql);
////乙方（司机）为收入
//sql =
// string.Format("insert into TB_YGPH_FUND (account,income,balance,dealtime,roletype,content) values('{0}','{1}','{2}',to_date('{3}','YYYY-MM-DD HH24:MI:SS'),'{4}','{5}')", account, amount, secondBalance, DateTime.Now, "2", "交易");
//dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHmw).ExecuteTable(sql);
info.Add("IsDeal", "Yes");
info.Add("Message", "交易成功！");
Json = JsonConvert.SerializeObject(info);
da.CommitTransaction();
}
catch (Exception ex)
{
info.Add("IsDeal", "No");
info.Add("Message", string.Format("{0}：提交数据发生异常。{1}", ex.Source, ex.Message));
Json = JsonConvert.SerializeObject(info);
da.RollbackTransaction();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//ID
string strId = Request.Params["Id"];
//strId = "6";
try
{
if (strId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取问题详情数据失败").DicInfo());
return;
}
//获取问题详情
string strSql =
string.Format(@"select a.id,a.type_mark,c.complain_name,b.department,a.vehicle,a.driverphone,to_char(a.createtime, 'yyyy/mm/dd hh24:mi:ss') as createtime,a.anonymous_mark,a.finish_mark,a.title,a.detail,a.deal_result,to_char(a.deal_time, 'yyyy/mm/dd hh24:ss:mi') as deal_time,a.evaluate,a.index_satisfy,to_char(a.evaluate_time, 'yyyy/mm/dd hh24:mi:ss') as evaluate_time,a.adjust_time,e.complain_name as complain_name_org,d.department as department_org
from SER_COMPLAIN a
left join HARBOR.V_SYS_DEPART_CONVERT b on a.code_company=b.code_department
left join SER_CODE_COMPLAIN c on a.code_complain=c.code_complain
left join HARBOR.V_SYS_DEPART_CONVERT d on a.code_company_org=d.code_department
left join SER_CODE_COMPLAIN e on a.code_complain_org=e.code_complain
where a.id='{0}'
order by a.finish_mark asc,a.createtime desc",
strId);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[] strArray = new string[16];
strArray[0] = Convert.ToString(dt.Rows[0]["id"]);
string strType = Convert.ToString(dt.Rows[0]["type_mark"]).Equals("0") == true ? "投诉" : "问题";
strArray[1] = strType;
string strComplain_Name = Convert.ToString(dt.Rows[0]["complain_name_org"]);
string strDepartment = Convert.ToString(dt.Rows[0]["department_org"]);
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["complain_name"])))
{
strComplain_Name = Convert.ToString(dt.Rows[0]["complain_name"]);
strDepartment = Convert.ToString(dt.Rows[0]["department"]);
}
strArray[2] = strComplain_Name;
strArray[3] = strDepartment;
strArray[4] = Convert.ToString(dt.Rows[0]["vehicle"]);
strArray[5] = Convert.ToString(dt.Rows[0]["driverphone"]);
strArray[6] = Convert.ToString(dt.Rows[0]["createtime"]);
string strAnonymous = Convert.ToString(dt.Rows[0]["anonymous_mark"]).Equals("0") == true ? "" : "匿名";
strArray[7] = strAnonymous;
string strState = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["evaluate_time"])))
{
strState = "已评价";
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["deal_time"])))
{
strState = "已解决";
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["adjust_time"])))
{
strState = "已受理";
}
else
{
strState = "待受理";
}
strArray[8] = strState;
strArray[9] = Convert.ToString(dt.Rows[0]["title"]);
strArray[10] = Convert.ToString(dt.Rows[0]["detail"]);
strArray[11] = Convert.ToString(dt.Rows[0]["deal_result"]);
strArray[12] = Convert.ToString(dt.Rows[0]["deal_time"]);
strArray[13] = Convert.ToString(dt.Rows[0]["evaluate"]);
string strIndex_satisfy = string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["index_satisfy"])) == true ? string.Empty : GetChineseEvaluate(Convert.ToInt16(dt.Rows[0]["index_satisfy"]));
strArray[14] = strIndex_satisfy;
strArray[15] = Convert.ToString(dt.Rows[0]["evaluate_time"]);
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取问题详情数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//数据起始行
var strStartRow = Request.Params["StartRow"];
//数据结束行
var strEndRow = Request.Params["EndRow"];
//账户
string strAccount = Request.Params["Account"];
//strStartRow = "1";
//strEndRow = "15";
//strAccount = "18936578716";
try
{
if (strStartRow == null || strEndRow == null || strAccount == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取待评价列表数据失败").DicInfo());
return;
}
//获取待评价列表数据
string strSql =
string.Format(@"select a.id,a.ingateno,b.fullorempty,b.vessel,b.cargo,a.vehicle,to_char(a.submittime, 'yyyy/mm/dd hh24:mi') as submittime,b.department
from TB_PRO_CONSIGNVEHICLE a, V_CONSIGN_QUICK b
where a.cgno=b.cgno and a.driverphone='{0}' and a.delete_mark_ser_evaluate='0'
order by a.submittime desc",
strAccount);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql, Convert.ToInt32(strStartRow), Convert.ToInt32(strEndRow));;
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 7];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["id"]);
strArray[iRow, 1] = Convert.ToString(dt.Rows[iRow]["ingateno"]);
strArray[iRow, 2] = Convert.ToString(dt.Rows[iRow]["department"]);
strArray[iRow, 3] = Convert.ToString(dt.Rows[iRow]["vessel"]);
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["cargo"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["vehicle"]);
strArray[iRow, 6] = Convert.ToString(dt.Rows[iRow]["submittime"]);
}
////获取待评价列表数据
//string strSql =
// string.Format(@"select a.id,a.ingateno,a.vehicle,to_char(a.submittime, 'yyyy/mm/dd hh24:mi') as submittime,a.cgno
// from TB_PRO_CONSIGNVEHICLE a
// where a.driverphone='{0}' and a.delete_mark_ser_evaluate='0'
// order by a.submittime desc",
// strAccount);
//var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql); ;
//if (dt.Rows.Count <= 0)
//{
// Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
// return;
//}
//List<List<string>> listArray = new List<List<string>>();
//for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
//{
// strSql =
// string.Format(@"select b.fullorempty,b.vessel,b.cargo
// from V_CONSIGN_QUICK b
// where b.cgno='{0}'",
// Convert.ToString(dt.Rows[iRow]["cgno"]));
// var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql);
// if (dt1.Rows.Count > 0)
// {
// List<string> list = new List<string>();
// list.Add(Convert.ToString(dt.Rows[iRow]["id"]));
// list.Add(Convert.ToString(dt.Rows[iRow]["ingateno"]));
// list.Add(Convert.ToString(dt1.Rows[0]["fullorempty"]));
// list.Add(Convert.ToString(dt1.Rows[0]["vessel"]));
// list.Add(Convert.ToString(dt1.Rows[0]["cargo"]));
// list.Add(Convert.ToString(dt.Rows[iRow]["vehicle"]));
// list.Add(Convert.ToString(dt.Rows[iRow]["submittime"]));
// listArray.Add(list);
// }
//}
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取待评价列表数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//账户
string strAccount = Request.Params["Account"];
//ID
string strId = Request.Params["Id"];
//停车办证
string strParkingCard = Request.Params["ParkingCard"];
//放行装卸
string strReleaseCargo = Request.Params["ReleaseCargo"];
//港区卡口
string strPortBayonet = Request.Params["PortBayonet"];
//服务态度
string strServiceAttitude = Request.Params["ServiceAttitude"];
//放行速度
string strReleaseSpeed = Request.Params["ReleaseSpeed"];
//装卸速度
string strUninstallSpeed = Request.Params["UninstallSpeed"];
//总体评价
string strOverallEvaluation = Request.Params["OverallEvaluation"];
AppLog log = new AppLog(Request);
log.strBehavior = "发布评价";
log.strBehaviorURL = "/Service/Evaluate/ReleaseEvaluate.aspx";
log.strAccount = strAccount;
try
{
if (strAccount == null || strId == null || strParkingCard == null || strReleaseCargo == null || strPortBayonet == null || strServiceAttitude == null || strReleaseSpeed == null || strUninstallSpeed == null || strOverallEvaluation == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，发布评价失败").DicInfo());
return;
}
//运输申报编号
string strVehicleAttestNo = string.Empty;
//部门
string strCodeDepartment = string.Empty;
//车号
string strVehicle = string.Empty;
//内部委托号
string strCgno = string.Empty;
//纸面委托号
string strTaskno = string.Empty;
//货名
string strCargo = string.Empty;
//船名
string strVessel = string.Empty;
//集疏运类别
string strFullorempty = string.Empty;
//手机号
string strMobile = string.Empty;
//获取运输申报数据
string strSql =
string.Format(@"select a.ingateno,a.code_department,a.vehicle,a.driverphone,a.cgno,b.taskno,b.cargo,b.vessel,b.fullorempty
from TB_PRO_CONSIGNVEHICLE a, V_CONSIGN_QUICK b
where a.cgno=b.cgno and a.id='{0}'",
strId);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strVehicleAttestNo = Convert.ToString(dt.Rows[0]["ingateno"]);
strCodeDepartment = Convert.ToString(dt.Rows[0]["code_department"]);
strVehicle = Convert.ToString(dt.Rows[0]["vehicle"]);
strCgno = Convert.ToString(dt.Rows[0]["cgno"]);
strTaskno = Convert.ToString(dt.Rows[0]["taskno"]);
strCargo = Convert.ToString(dt.Rows[0]["cargo"]);
strVessel = Convert.ToString(dt.Rows[0]["vessel"]);
strFullorempty = Convert.ToString(dt.Rows[0]["fullorempty"]);
strMobile = Convert.ToString(dt.Rows[0]["driverphone"]);;
}
//发布评价
strSql =
string.Format(@"insert into SER_EVALUATE (veh_attest_no,code_company,taskno,fullorempty,vessel,cargo,vehicle,driverphone,cgno,
evaluate_hall,evaluate_dock,evaluate_gate,index_attitude,index_audit,index_make,index_overall,account)
values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}',{12},{13},{14},{15},'{16}')",
strVehicleAttestNo, strCodeDepartment, strTaskno, strFullorempty, strVessel, strCargo, strVehicle, strMobile, strCargo,
strParkingCard, strReleaseCargo, strPortBayonet, strServiceAttitude, strReleaseSpeed, strUninstallSpeed, strOverallEvaluation, strAccount);
new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteNonQuery(strSql);
//删除我的评估
strSql =
string.Format(@"update TB_PRO_CONSIGNVEHICLE t
set t.delete_mark_ser_evaluate='1'
where t.id='{0}'",
strId);
new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteNonQuery(strSql);
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "发布成功").DicInfo());
log.LogCatalogSuccess();
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：发布评价发生异常。{1}", ex.Source, ex.Message)).DicInfo());
log.LogCatalogFailure(string.Format("{0}：发布评价发生异常。{1}", ex.Source, ex.Message));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//航次编码
string strShip_Id = Request.Params["Ship_Id"];
string strCodeInOut = Request.Params["CodeInOut"];
//strShip_Id = "2015";
//strCodeInOut = "1";
try
{
if (strShip_Id == null || strCodeInOut == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "参数错误，获取个统计理货员数据数据失败！").DicInfo());
return;
}
//strShip_Id = string.IsNullOrWhiteSpace(strShip_Id) ? string.Empty : strShip_Id;
//strCodeInOut = string.IsNullOrWhiteSpace(strCodeInOut) ? string.Empty : strCodeInOut;
string strSql = string.Empty;
string strAbnormalSql = string.Empty;
FullStatisticsE fullStatisticsE = new FullStatisticsE();
if (strCodeInOut.Equals("0"))
{
strSql =
string.Format(@"select SIZE_CON,FULLOREMPTY,count(*) allCon,count(case when unload_mark='1' then 1 end) tallyCon
from con_image t
WHERE SHIP_ID='{0}' and CODE_UNLOAD_PORT LIKE '%LYG' AND MOVED='0'
GROUP BY SIZE_CON,FULLOREMPTY",
strShip_Id);
strAbnormalSql =
string.Format(@"select SIZE_CON,FULLOREMPTY,count(*) abnormalCon
from con_image t
WHERE SHIP_ID='{0}' and CODE_UNLOAD_PORT LIKE '%LYG' AND BAY_OPERTIME is not null
GROUP BY SIZE_CON,FULLOREMPTY",
strShip_Id);
}
else
{
strSql =
string.Format(@"select SIZE_CON,FULLOREMPTY,count(*) allCon,count(case when unload_mark='1' then 1 end) tallyCon
from con_image t
WHERE SHIP_ID='{0}' and CODE_LOAD_PORT LIKE '%LYG' AND MOVED='0'
GROUP BY SIZE_CON,FULLOREMPTY",
strShip_Id);
strAbnormalSql =
string.Format(@"select SIZE_CON,FULLOREMPTY,count(*) abnormalCon
from con_image t
WHERE SHIP_ID='{0}' and CODE_LOAD_PORT LIKE '%LYG' AND BAY_OPERTIME is not null
GROUP BY SIZE_CON,FULLOREMPTY",
strShip_Id);
}
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
if (dt.Rows[iRow]["FULLOREMPTY"].Equals("E"))
{
if (dt.Rows[iRow]["SIZE_CON"].Equals("20"))
{
fullStatisticsE.Forecast_E_20 = Convert.ToInt16(dt.Rows[iRow]["ALLCON"]);
fullStatisticsE.Tally_E_20 = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
else if (dt.Rows[iRow]["SIZE_CON"].Equals("40"))
{
fullStatisticsE.Forecast_E_40 = Convert.ToInt16(dt.Rows[iRow]["ALLCON"]);
fullStatisticsE.Tally_E_40 = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
else
{
fullStatisticsE.Forecast_E_other = Convert.ToInt16(dt.Rows[iRow]["ALLCON"]);
fullStatisticsE.Tally_E_other = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
}
if (dt.Rows[iRow]["FULLOREMPTY"].Equals("F"))
{
if (dt.Rows[iRow]["SIZE_CON"].Equals("20"))
{
fullStatisticsE.Forecast_F_20 = Convert.ToInt16(dt.Rows[iRow]["ALLCON"]);
fullStatisticsE.Tally_F_20 = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
else if (dt.Rows[iRow]["SIZE_CON"].Equals("40"))
{
fullStatisticsE.Forecast_F_40 = Convert.ToInt16(dt.Rows[iRow]["ALLCON"]);
fullStatisticsE.Tally_F_40 = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
else
{
fullStatisticsE.Forecast_F_other = Convert.ToInt16(dt.Rows[iRow]["ALLCON"]);
fullStatisticsE.Tally_F_other = Convert.ToInt16(dt.Rows[iRow]["TALLYCON"]);
}
}
}
}
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strAbnormalSql);
if (dt.Rows.Count > 0)
{
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
if (dt.Rows[iRow]["FULLOREMPTY"].Equals("E"))
{
if (dt.Rows[iRow]["SIZE_CON"].Equals("20"))
{
fullStatisticsE.Abnormal_E_20 = Convert.ToInt16(dt.Rows[iRow]["ABNORMALCON"]);
}
else if (dt.Rows[iRow]["SIZE_CON"].Equals("40"))
{
fullStatisticsE.Abnormal_E_40 = Convert.ToInt16(dt.Rows[iRow]["ABNORMALCON"]);
}
else
{
fullStatisticsE.Abnormal_E_other = Convert.ToInt16(dt.Rows[iRow]["ABNORMALCON"]);
}
}
if (dt.Rows[iRow]["FULLOREMPTY"].Equals("F"))
{
if (dt.Rows[iRow]["SIZE_CON"].Equals("20"))
{
fullStatisticsE.Abnormal_F_20 = Convert.ToInt16(dt.Rows[iRow]["ABNORMALCON"]);
}
else if (dt.Rows[iRow]["SIZE_CON"].Equals("40"))
{
fullStatisticsE.Abnormal_F_40 = Convert.ToInt16(dt.Rows[iRow]["ABNORMALCON"]);
}
else
{
fullStatisticsE.Abnormal_F_other = Convert.ToInt16(dt.Rows[iRow]["ABNORMALCON"]);
}
}
}
}
int[] strArray = new int[27];
strArray[0] = fullStatisticsE.Forecast_total;
strArray[1] = fullStatisticsE.Forecast_E_20;
strArray[2] = fullStatisticsE.Forecast_E_40;
strArray[3] = fullStatisticsE.Forecast_E_other;
strArray[4] = fullStatisticsE.Forecast_E_total;
strArray[5] = fullStatisticsE.Forecast_F_20;
strArray[6] = fullStatisticsE.Forecast_F_40;
strArray[7] = fullStatisticsE.Forecast_F_other;
strArray[8] = fullStatisticsE.Forecast_F_total;
strArray[9] = fullStatisticsE.Tally_total;
strArray[10] = fullStatisticsE.Tally_E_20;
strArray[11] = fullStatisticsE.Tally_E_40;
strArray[12] = fullStatisticsE.Tally_E_other;
strArray[13] = fullStatisticsE.Tally_E_total;
strArray[14] = fullStatisticsE.Tally_F_20;
strArray[15] = fullStatisticsE.Tally_F_40;
strArray[16] = fullStatisticsE.Tally_F_other;
strArray[17] = fullStatisticsE.Tally_F_total;
strArray[18] = fullStatisticsE.Abnormal_total;
strArray[19] = fullStatisticsE.Abnormal_E_20;
strArray[20] = fullStatisticsE.Abnormal_E_40;
strArray[21] = fullStatisticsE.Abnormal_E_other;
strArray[22] = fullStatisticsE.Abnormal_E_total;
strArray[23] = fullStatisticsE.Abnormal_F_20;
strArray[24] = fullStatisticsE.Abnormal_F_40;
strArray[25] = fullStatisticsE.Abnormal_F_other;
strArray[26] = fullStatisticsE.Abnormal_F_total;
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取全统计数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//数据起始行
var strStartRow = Request.Params["StartRow"];
//数据结束行
var strEndRow = Request.Params["EndRow"];
//账户
string strAccount = Request.Params["Account"];
//strStartRow = "1";
//strEndRow = "15";
//strAccount = "13812347543";
try
{
if (strStartRow == null || strEndRow == null || strAccount == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取我的评价列表数据失败").DicInfo());
return;
}
//获取我的评价列表数据
string strSql =
string.Format(@"select t.id,t.veh_attest_no,t.driverphone,t.finish_mark,to_char(t.createtime, 'yyyy/mm/dd') as createtime,t.evaluate_hall,t.evaluate_dock,t.evaluate_gate,t.index_attitude,t.index_audit,t.index_make,t.index_overall,t.hall_time,t.dock_time,t.gate_time
from SER_EVALUATE t where t.account='{0}' and t.finish_mark = '0'
order by t.createtime desc",
strAccount);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteTable(strSql, Convert.ToInt32(strStartRow), Convert.ToInt32(strEndRow));;
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 12];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["id"]);
strArray[iRow, 1] = Convert.ToString(dt.Rows[iRow]["veh_attest_no"]);
strArray[iRow, 2] = Convert.ToString(dt.Rows[iRow]["driverphone"]);
string strExplain = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["hall_time"])) || !string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["dock_time"])) || !string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["gate_time"])))
{
strExplain = "有说明";
}
strArray[iRow, 3] = strExplain;
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["createtime"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["evaluate_hall"]);
strArray[iRow, 6] = Convert.ToString(dt.Rows[iRow]["evaluate_dock"]);
strArray[iRow, 7] = Convert.ToString(dt.Rows[iRow]["evaluate_gate"]);
strArray[iRow, 8] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[iRow]["index_attitude"]));
strArray[iRow, 9] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[iRow]["index_audit"]));
strArray[iRow, 10] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[iRow]["index_make"]));
strArray[iRow, 11] = GetChineseEvaluate(Convert.ToInt16(dt.Rows[iRow]["index_overall"]));
}
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取我的评价列表数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误").DicInfo());
return;
}
//数据起始行
var strStartRow = Request.Params["StartRow"];
//数据结束行
var strEndRow = Request.Params["EndRow"];
//账户
string strAccount = Request.Params["Account"];
try
{
if (strAccount == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取我的投诉列表数据失败").DicInfo());
return;
}
//获取我的投诉列表
string strSql =
string.Format(@"select a.id,a.type_mark,c.complain_name,b.department,a.vehicle,a.driverphone,to_char(a.createtime, 'yyyy/mm/dd') as createtime,a.anonymous_mark,a.finish_mark,a.title,a.detail,a.adjust_time,a.deal_time,a.evaluate_time,e.complain_name as complain_name_org,d.department as department_org
from SER_COMPLAIN a
left join HARBOR.V_SYS_DEPART_CONVERT b on a.code_company=b.code_department
left join SER_CODE_COMPLAIN c on a.code_complain=c.code_complain
left join HARBOR.V_SYS_DEPART_CONVERT d on a.code_company_org=d.code_department
left join SER_CODE_COMPLAIN e on a.code_complain_org=e.code_complain
where a.type_mark='0' and a.account='{0}' and a.finish_mark='0'
order by a.createtime desc",
strAccount);
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathCGate).ExecuteTable(strSql, Convert.ToInt32(strStartRow), Convert.ToInt32(strEndRow));
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, null).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 12];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["id"]);
string strType = Convert.ToString(dt.Rows[iRow]["type_mark"]).Equals("0") == true ? "投诉" : "问题";
strArray[iRow, 1] = strType;
string strComplain_Name = Convert.ToString(dt.Rows[iRow]["complain_name_org"]);
string strDepartment = Convert.ToString(dt.Rows[iRow]["department_org"]);
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["complain_name"])))
{
strComplain_Name = Convert.ToString(dt.Rows[iRow]["complain_name"]);
strDepartment = Convert.ToString(dt.Rows[iRow]["department"]);
}
strArray[iRow, 2] = strComplain_Name;
strArray[iRow, 3] = strDepartment;
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["vehicle"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["driverphone"]);
strArray[iRow, 6] = Convert.ToString(dt.Rows[iRow]["createtime"]);
string strAnonymous = Convert.ToString(dt.Rows[iRow]["anonymous_mark"]).Equals("0") == true ? "" : "匿名";
strArray[iRow, 7] = strAnonymous;
string strState = string.Empty;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["evaluate_time"])))
{
strState = "已评价";
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["deal_time"])))
{
strState = "已解决";
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[iRow]["adjust_time"])))
{
strState = "已受理";
}
else
{
strState = "待受理";
}
strArray[iRow, 8] = strState;
strArray[iRow, 9] = Convert.ToString(dt.Rows[iRow]["title"]);
strArray[iRow, 10] = Convert.ToString(dt.Rows[iRow]["detail"]);
}
Json = JsonConvert.SerializeObject(new DicPackage(true, strArray, null).DicInfo());
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：获取我的投诉列表数据发生异常。{1}", ex.Source, ex.Message)).DicInfo());
}
}