protected void Page_Load(object sender, EventArgs e)
{
//集装箱
var sql = "SELECT * FROM view_new_remaintons where not worktime_begin is null and worktime_end is null and goods='集装箱' ";
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
this.JZX.DataSource = dt.DefaultView;
this.DataBind();
//件杂货
sql = "SELECT * FROM view_new_remaintons where not worktime_begin is null and worktime_end is null and goods='件杂货' ";
dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
this.JZH.DataSource = dt.DefaultView;
this.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//标题
int id = Convert.ToInt16(Request.Params["ID"]);
string[] ArrTitle = { "新闻中心", "公司新闻", "通知公告", "联系我们", "行业资讯", "40周年庆", "创优争先", "学习资料", "外理文苑", "美图欣赏", "外理状元", "外理亮点", "工作感悟", "学习资料", "我的作品", "管理启示", "安全警示", "相关法规", "行业新闻", "集团新闻", "公司简介" };
Title = ArrTitle[id];
//新闻
var sql = string.Format("SELECT * FROM WL_News_Topic WHERE Class_ID = {0} ORDER BY ID DESC", id);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
this.News.DataSource = dt.DefaultView;
this.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
int page = Convert.ToInt16(Request.Params["page"]);
//公司新闻-CompanyNewsFirst
var sql = string.Format("select top 8 * FROM WL_News_Topic WHERE Class_ID = 1 and isnw =1 and id not in(select top {0} id from WL_News_Topic WHERE Class_ID = 1 and isnw =1 ORDER BY ID DESC) ORDER BY ID DESC", (page - 1) * 8);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
this.CompanyNewsDetail.DataSource = dt.DefaultView;
this.DataBind();
sql = string.Format("select count(*)/8 FROM WL_News_Topic WHERE Class_ID = 1 and isnw =1");
dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
count = Convert.ToString(dt.Rows[0][0]);
}
protected void Page_Load(object sender, EventArgs e)
{
int page = Convert.ToInt16(Request.Params["page"]);
//公司新闻-CompanyNewsFirst
var sql = string.Format("select top 8 * FROM WL_News_Topic WHERE topic like '%{0}%' ORDER BY ID DESC", Request.Params["keywords"]);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
this.CompanyNewsDetail.DataSource = dt.DefaultView;
this.DataBind();
sql = string.Format("select count(*)/8 FROM WL_News_Topic WHERE topic like '%{0}%'", Request.Params["keywords"]);
dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
count = Convert.ToString(dt.Rows[0][0]);
}
private void button3_Click(object sender, EventArgs e)
{
var sql = string.Format("select * from TB_TALLY_CONTRACT where company_delegate like '%{0}%'", textBox1.Text);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
dt.Columns[0].ColumnName = "委托单位";
dt.Columns[1].ColumnName = "签约日期";
dt.Columns[2].ColumnName = "履约日期";
dt.Columns[3].ColumnName = "委托类别";
dt.Columns[4].ColumnName = "委托事项";
dt.Columns[5].ColumnName = "备注";
dt.Columns[6].ColumnName = "附件";
dt.Columns[7].ColumnName = "审核人";
dt.Columns[8].ColumnName = "审核部门";
dt.Columns[9].ColumnName = "审核状态";
dataGridView1.DataSource = dt;
}
private void button2_Click_1(object sender, EventArgs e)
{
try
{
string t1 = textBox1.Text;
string t2 = Convert.ToString(dateTimePicker1.Value);
string t3 = Convert.ToString(dateTimePicker2.Value);
string t4 = textBox4.Text;
string t5 = textBox5.Text;
string t6 = textBox6.Text;
string t7 = textBox7.Text;
string t8 = textBox8.Text;
string t9 = textBox9.Text;
string t10 = textBox2.Text;
string t11 = textBox11.Text;
string t12 = textBox3.Text;
string t13 = textBox10.Text;
string t14 = textBox12.Text;
string t15 = textBox13.Text;
string t16 = textBox19.Text;
string t17 = textBox20.Text;
string t18 = Convert.ToString(dateTimePicker3.Value);
string t19 = textBox14.Text;
string t20 = textBox15.Text;
string t21 = textBox16.Text;
string t22 = textBox17.Text;
string t23 = textBox18.Text;
var sql = string.Format("delete from TB_TALLY_CONTRACT where ATTACHMENT = '{0}'", filenamePr);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
sql = string.Format("INSERT INTO TB_TALLY_CONTRACT values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','已审核','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}')", t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20, t21, t22, t23);
dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
MessageBox.Show("添加成功");
this.Dispose();
refreshDelegate();
}
catch (Exception ex)
{
string a = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var message = Request.Params["message"];
var str = message.Split('=');
var str1 = str[1].Split(' ');
var newsId = str1[0];
string sql =
string.Format("select topic,convert(varchar(100), post_time, 20) as post_time,message from news_topic where id = '{0}'", newsId);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathYgwl).ExecuteTable(sql);
var array = new Leo.Data.Table(dt).ToArray();
Json = JsonConvert.SerializeObject(array);
}
catch (Exception ex)
{
LogTool.WriteLog(typeof(NewsDetail), ex);
}
}
/// <summary>
/// 校验过磅记录
/// </summary>
/// <param name="strNameArray">字段名称集合</param>
/// <returns></returns>
private string VerifyWeightRecord(string[] strNameArray)
{
string strJson = string.Empty;
Dictionary <string, object> info = new Dictionary <string, object>();
string strSql =
string.Format(@"select weight1,weight2,weightcargo,convert(varchar(100), recordtime, 120) as recordtime
from BALANCECENTER..V_MetageForComm
where RecordTime>getdate()-1 and CardNo='{0}' and Truck='{1}' and RecordTime>'{2}'
order by RecordTime desc ",
workE.StrCardNo, workE.StrVehicle, workE.StrAuditTime);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
info = GetAllInfo(strNameArray);
strJson = JsonConvert.SerializeObject(new DicPackage(false, info, "此车无过磅记录！").DicInfo());
return(strJson);
}
workE.StrRecordtime = Convert.ToString(dt.Rows[0]["recordtime"]);
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["weightcargo"])))
{
workE.StrWeightCargo = Convert.ToString(dt.Rows[0]["weightcargo"]);
info = GetAllInfo(strNameArray);
strJson = JsonConvert.SerializeObject(new DicPackage(false, info, "此车已过完磅！").DicInfo());
return(strJson);
}
//千克转换成吨
if (string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["weight1"])))
{
workE.StrWeight = string.Format("{0:N2}", Convert.ToInt32(dt.Rows[0]["weight2"]) / 1000);
}
else
{
workE.StrWeight = string.Format("{0:N2}", Convert.ToInt32(dt.Rows[0]["weight1"]) / 1000);
}
return(strJson);
}
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt16(Request.Params["ID"]);
//公司新闻-CompanyNews
var sql = string.Format("select * from VIEW_WL_News where id={0}", id);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
this.LabBT.Text = dt.DefaultView[0]["topic"].ToString();
string text = HttpUtility.UrlDecode(dt.DefaultView[0]["MESSAGE"].ToString());
if (text.Contains("/old"))
{
this.LabMessage.Text = text;
}
else
{
this.LabMessage.Text = text.Replace("/admin", "../old/admin");
}
this.Labtime.Text = " <font style='font-weight:normal'>" + (Convert.ToDateTime(dt.DefaultView[0]["POST_TIME"])).ToString("yyyy-MM-dd") + "</font>";
if (!(dt.DefaultView[0]["newname"] == DBNull.Value) & dt.DefaultView[0]["newname"].ToString() != "")
{
var oldname = (dt.DefaultView[0]["oldname"].ToString()).Split('|');
var newname = (dt.DefaultView[0]["newname"].ToString()).Split('|');
if (newname.Length == 1)
{
this.Labfj.Text = Server.HtmlDecode("附件: <a href=../old/upload_archive/" + dt.DefaultView[0]["newname"] + " target=_blank>" + dt.DefaultView[0]["oldname"].ToString() + "</a>");
}
else
{
for (int i = 0; i < oldname.Length; i++)
{
this.Labfj.Text += "<li>" + "<a href=../old/upload_archive/" + newname[i] + " target=_blank>" + oldname[i] + "</a>";
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//查询页数
var pages = Request.Params["Pages"];
Dictionary <string, Array> info = new Dictionary <string, Array>();
try
{
if (pages == null)
{
string[] arry = new string[1];
arry[0] = "举例：http://218.92.115.55/M_Yghy/Service/News/GetAllNewsList.aspx?Pages=1";
info.Add("参数Pages不能为null！", arry);
Json = JsonConvert.SerializeObject(info);
return;
}
int minRow = (Convert.ToInt16(pages) - 1) * 15 + 1;
int maxRow = Convert.ToInt16(pages) * 15;
string sql =
string.Format(
"select count(id) as total from news_topic where classid='1'");
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathYgwl).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "暂无新闻！";
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
sql =
string.Format(
"select top {1} id,topic,convert(varchar(100), post_time, 20) as post_time,classid from (select TOP {0} id,topic,post_time,classid from news_topic where classid='1' order by post_time asc)a order by post_time desc",
Convert.ToInt32(dt.Rows[0]["total"]) - minRow + 1, maxRow - minRow + 1);
dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathYgwl).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = "暂无更多新闻！";
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
return;
}
string[,] arrays = new string[dt.Rows.Count, 3];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
arrays[iRow, 0] = Convert.ToString(dt.Rows[iRow]["id"]);
arrays[iRow, 1] = Convert.ToString(dt.Rows[iRow]["topic"]);
arrays[iRow, 2] = Convert.ToString(dt.Rows[iRow]["post_time"]);
}
string[] arry2 = new string[1];
arry2[0] = "Yes";
info.Add("IsGet", arry2);
info.Add("NewsList", arrays);
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
string[] arry0 = new string[1];
arry0[0] = "NO";
info.Add("IsGet", arry0);
string[] arry1 = new string[1];
arry1[0] = ex.Message;
info.Add("Message", arry1);
Json = JsonConvert.SerializeObject(info);
}
}
private void button2_Click(object sender, EventArgs e)
{
http: //www.lygtally.com/Contract/
try
{
WebClient webclient = new WebClient();
if (this.openFileDialog1.FileName == "")
{
MessageBox.Show("请添加附件");
return;
}
byte[] responseArray = webclient.UploadFile("http://www.lygtally.com/Contract/upload.aspx", "POST", @"" + this.openFileDialog1.FileName + "");
string getPath = Encoding.GetEncoding("UTF-8").GetString(responseArray);
var arr = Leo.Json.JsonConvert.DeserializeObject <string[]>(getPath);
string t1 = textBox1.Text;
string t2 = Convert.ToString(dateTimePicker1.Value);
string t3 = Convert.ToString(dateTimePicker2.Value);
string t4 = textBox4.Text;
string t5 = textBox5.Text;
string t6 = textBox6.Text;
string t7 = arr[1];
string t8 = textBox8.Text;
string t9 = textBox9.Text;
string t10 = textBox2.Text;
string t11 = textBox11.Text;
string t12 = textBox3.Text;
string t13 = textBox10.Text;
string t14 = textBox12.Text;
string t15 = textBox13.Text;
string t16 = textBox19.Text;
string t17 = textBox20.Text;
string t18 = Convert.ToString(dateTimePicker3.Value);
string t19 = textBox14.Text;
string t20 = textBox15.Text;
string t21 = textBox16.Text;
string t22 = textBox17.Text;
string t23 = textBox18.Text;
if (arr[0] == "YES")
{
var sql = string.Format("INSERT INTO TB_TALLY_CONTRACT values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','已审核','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}')", t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20, t21, t22, t23);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(sql);
MessageBox.Show("添加成功");
this.Dispose();
refreshDelegate();
}
else
{
MessageBox.Show("上传附件失败，请检查网络");
}
}
catch (Exception ex)
{
string a = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string sql = string.Format("select code,Description from gpms2000_nbw..department_sr");
var dt0 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathNbwDept).ExecuteTable(sql);
if (dt0.Rows.Count == 0)
{
string error = "网络错误，请稍后再试！";
Json = JsonConvert.SerializeObject(error);
return;
}
sql =
string.Format(
@"select c.id,c.login_name,c.user_name,d.mobile as tel,c.email,c.company_id,c.company_name,c.dept_id,c.tel1,c.duty,c.tel2,c.pemail,c.phone1,c.head_pic
from (select a.id,a.username as login_name,a.truename as user_name,a.email,a.companyid as company_id,b.shortname as company_name,a.bumenid as dept_id,a.tel1,a.duty,a.tel2,a.pemail,a.phone1,a.head_pic
from user_info a, company_name b
where a.companyid='{0}' and substr(a.bumenid,1,4)=b.companyid order by user_name) c ,awsprod.orguser d
where c.login_name = d.userid",
"017929");
var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNbws).ExecuteTable(sql);
var infoArray = new List <Dictionary <string, string> >();
for (int iRow = 0; iRow < dt1.Rows.Count; iRow++)
{
string departmentName = "";
bool markWeibo = true;
var rows = dt0.Select(string.Format("CODE='{0}'", Convert.ToString(dt1.Rows[iRow]["dept_id"])));
if (rows.Length > 0)
{
departmentName = rows[0]["DESCRIPTION"] as string;
}
departmentName = departmentName == null ? string.Empty : departmentName;
markWeibo =
!(dt1.Rows[iRow]["EMAIL"] is DBNull) && !string.IsNullOrEmpty(dt1.Rows[iRow]["EMAIL"] as string) &&
!string.IsNullOrWhiteSpace(dt1.Rows[iRow]["EMAIL"] as string);
Dictionary <string, string> info = new Dictionary <string, string>();
info.Add("userID", Convert.ToString(dt1.Rows[iRow]["ID"]));
info.Add("name", Convert.ToString(dt1.Rows[iRow]["USER_NAME"]));
info.Add("company", Convert.ToString(dt1.Rows[iRow]["COMPANY_NAME"]));
info.Add("department", departmentName);
info.Add("duty", Convert.ToString(dt1.Rows[iRow]["DUTY"]));
info.Add("mobilephone", Convert.ToString(dt1.Rows[iRow]["TEL"]));
info.Add("backupmobilephone", Convert.ToString(dt1.Rows[iRow]["PHONE1"]));
info.Add("telephone", Convert.ToString(dt1.Rows[iRow]["TEL1"]));
info.Add("backuptelephone", Convert.ToString(dt1.Rows[iRow]["TEL2"]));
info.Add("workemail", Convert.ToString(dt1.Rows[iRow]["EMAIL"]));
info.Add("personalemail", Convert.ToString(dt1.Rows[iRow]["PEMAIL"]));
info.Add("weibo", markWeibo == true ? "已开通" : "未开通");
infoArray.Add(info);
}
Json = JsonConvert.SerializeObject(infoArray);
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var message = Request.Params["message"];
var str = message.Split(' ');
var businessItem = str[0];
var id = str[1];
var dataId = str[2];
string dataTable = "";
switch (businessItem)
{
case "GoodsBill":
case "ShipBusinessConsign":
case "NoShipBusinessConsign":
case "JobConsign":
case "VehicleTransport":
case "VehicleBalance":
case "CargoIn":
case "CargoOut":
case "CargoStock":
case "CargoDui":
case "NewLandBridgeWorkPlan":
case "PassedTransportation":
case "NoPassedTransportation":
case "CargoBalance": dataTable = Leo.RegistryKey.KeyPathHarbors; break;
case "ForeShip":
case "IndeedShip":
case "AnchorShip":
case "BerthShip":
case "PlanedShip":
case "VehicleDeclaration":
case "VehicleRegistration":
case "MoveShip": dataTable = Leo.RegistryKey.KeyPathBases; break;
case "PilotageFee":
case "CommunicationFee": dataTable = Leo.RegistryKey.KeyPathMas; break;
case "WeightNote": dataTable = Leo.RegistryKey.KeyPathBc; break;
default:
throw new Exception("错误的对象索引");
}
//数据项
var arry0 = TableTool_forBusiness.GetTableItemSet(Convert.ToInt16(id));
//sql
var sql = SQLTool_forBusiness.GetSQL(Convert.ToInt16(id));
sql = string.Format(sql, dataId);
var dt = new DataTable();
if (businessItem == "WeightNote")
{
dt = new Leo.SqlServer.DataAccess(Leo.RegistryKey.KeyPathBc).ExecuteTable(sql);
}
else
{
dt = new Leo.Oracle.DataAccess(dataTable).ExecuteTable(sql);
}
var arry1 = new Leo.Data.Table(dt).ToArray();
var arrys = new Array[2];
arrys[0] = arry0;
arrys[1] = arry1;
//Json = Request.QueryString.Get("callback") + "(" + JsonConvert.SerializeObject(arrys) + ")";
Json = JsonConvert.SerializeObject(arrys);
}
catch (Exception ex)
{
LogTool.WriteLog(typeof(Detail_Table_forBusiness), ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
var message = Request.Params["message"];
var str = message.ToString().Split(' ');
var userCode = str[0];
var DelegationNum = str[1];
var minRow = str[2];
var maxRow = str[3];
var sql =
string.Format(
"select count(consign) as sum from BalanceCenter..vw_Metages where Consign='{0}'", DelegationNum);
var dt = new Leo.SqlServer.DataAccess(Leo.RegistryKey.KeyPathBc).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
var arry = 0;
Json = JsonConvert.SerializeObject(arry);
return;
}
sql =
string.Format(
"select count(consign) as vehiclesum, sum(weight2) as roughsum,sum(weight1) as taresum, sum(weight2-weight1) as suttlesum from BalanceCenter..vw_Metages where Consign='{0}'",
DelegationNum);
var dt0 = new Leo.SqlServer.DataAccess(Leo.RegistryKey.KeyPathBc).ExecuteTable(sql);
if (dt0.Rows.Count == 0)
{
var arry = 0;
Json = JsonConvert.SerializeObject(arry);
return;
}
var arry0 = new Leo.Data.Table(dt0).ToArray();
sql =
string.Format(
"select sum(Weight2-Weight1)/count(Weight2-Weight1)*count(*) as WeightV from BalanceCenter..Metage where Consign='{0}'",
DelegationNum);
var dt1 = new Leo.SqlServer.DataAccess(Leo.RegistryKey.KeyPathBc).ExecuteTable(sql);
if (dt1.Rows.Count == 0)
{
var arry = 0;
Json = JsonConvert.SerializeObject(arry);
return;
}
var arry1 = new Leo.Data.Table(dt1).ToArray();
sql =
string.Format(
" select weight from BalanceCenter..consign where Consignno='{0}'",
DelegationNum);
var dt2 = new Leo.SqlServer.DataAccess(Leo.RegistryKey.KeyPathBc).ExecuteTable(sql);
if (dt2.Rows.Count == 0)
{
var arry = 0;
Json = JsonConvert.SerializeObject(arry);
return;
}
var arry2 = new Leo.Data.Table(dt2).ToArray();
sql =
string.Format(
"select top {2} consign,convert(varchar(100), finishtime, 2),Ticket,Truck,Amount,weight2,weight1,(weight2-weight1) weight ,operator2 from (select TOP {1} consign,finishtime,Ticket,Truck,Amount,weight2,weight1,(weight2-weight1) weight ,operator2 from BalanceCenter..vw_Metages where Consign='{0}' order by finishtime asc)a order by finishtime desc",
DelegationNum, Convert.ToInt32(dt.Rows[0]["sum"]) - Convert.ToInt32(minRow) + 1, Convert.ToInt32(maxRow) - Convert.ToInt32(minRow) + 1);
var dt3 = new Leo.SqlServer.DataAccess(Leo.RegistryKey.KeyPathBc).ExecuteTable(sql);
if (dt3.Rows.Count == 0)
{
var arry = 0;
Json = JsonConvert.SerializeObject(arry);
return;
}
var arry3 = new Leo.Data.Table(dt3).ToArray();
var arrys = new Array[4];
arrys[0] = arry0;
arrys[1] = arry1;
arrys[2] = arry2;
arrys[3] = arry3;
Json = JsonConvert.SerializeObject(arrys);
}
catch (Exception ex)
{
LogTool.WriteLog(typeof(WeightNote), ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//船图列表
string strShipImageList = Request.Params["ShipImageList"];
AppLog log = new AppLog(Request);
log.strBehavior = "上传已修改贝船图数据";
log.strBehaviorURL = "/Ship/UploadShipImages.aspx";
try
{
if (strShipImageList == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，上传已修改贝船图数据失败！").DicInfo());
return;
}
List <ShipImage> list = JsonConvert.DeserializeObject <List <ShipImage> >(strShipImageList);
log.strAccount = list[0].modifier;
List <string> containerNoList = new List <string>();
for (int i = 0; i < list.Count; i++)
{
ShipImage shipImage = list[i];
string strTempContainerNo = shipImage.container_no;
string strTempBaynum = shipImage.baynum;
//箱号不能为空
if (!string.IsNullOrWhiteSpace(strTempContainerNo) && !string.IsNullOrWhiteSpace(strTempBaynum) && !strTempBaynum.Equals("null") && containerNoList.IndexOf(strTempContainerNo) == -1)
{
//遍历是否有重复箱号的数据
int j;
for (j = i + 1; j < list.Count; j++)
{
if (strTempContainerNo.Equals(list[j].container_no) && list[j].bayno != null && !list[j].bayno.Equals("null") && !list[j].bayno.Equals(""))
{
if (!string.IsNullOrWhiteSpace(shipImage.baynum) && !shipImage.baynum.Equals("null"))
{
if (Convert.ToInt16(shipImage.baynum) > Convert.ToInt16(list[j].baynum))
{
shipImage = list[j];
}
}
}
}
if (i == list.Count - 1)
{
shipImage = list[i];
}
containerNoList.Add(shipImage.container_no);
string strOperareName = string.Empty;
string strSql = string.Format(@"select distinct name
from SYSTEM_USER_TABLE
where user_id='{0}'",
shipImage.modifier);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTallySqlServer).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strOperareName = dt.Rows[0]["name"].ToString();
}
strSql = string.Format(@"select MOVED,BAYNO,OLDBAYNO,USER_NAME,SIZE_CON,WORK_NO
from CON_IMAGE
where SHIP_ID='{0}' and CONTAINER_NO='{1}'",
shipImage.ship_id, shipImage.container_no);
dt = da.ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "暂无数据！").DicInfo());
log.LogCatalogFailure(string.Format("上传已修改贝船图数据发生异常。航次'{0}'、箱号'{1}'不存在", shipImage.ship_id, shipImage.container_no));
return;
}
string strBayno = string.Empty;
string strOldbayno = string.Empty;
string strUserName = string.Empty;
if (shipImage.bayno != null && !shipImage.bayno.Equals("null"))
{
strBayno = shipImage.bayno;
}
if (dt.Rows[0]["BAYNO"].ToString() != null && !dt.Rows[0]["BAYNO"].ToString().Equals("null"))
{
strOldbayno = dt.Rows[0]["BAYNO"].ToString();
}
if (strOperareName != null && !strOperareName.Equals("null"))
{
strUserName = strOperareName;
}
//保留原船图数据记录
strSql = string.Format(@"insert into TB_APP_TALLY_LOG (SHIP_ID,CONTAINER_NO,BAYNO,OLDBAYNO,MOVED,USER_NAME,BAY_OPERNAME,BAY_OPERTIME,SIZE_CON,WORK_NO,MOVEDBAYNO)
values('{0}','{1}','{2}','{3}','{4}','{5}','{6}',to_date('{7}','yyyy-mm-dd HH24:mi:ss'),'{8}','{9}','{10}')",
shipImage.ship_id, shipImage.container_no, dt.Rows[0]["BAYNO"].ToString(), dt.Rows[0]["OLDBAYNO"].ToString(),
dt.Rows[0]["MOVED"].ToString(), dt.Rows[0]["USER_NAME"].ToString(), shipImage.modifier, shipImage.modifytime,
dt.Rows[0]["SIZE_CON"].ToString(), dt.Rows[0]["WORK_NO"].ToString(), strBayno);
da.ExecuteNonQuery(strSql);
//更新
strSql = string.Format(@"update CON_IMAGE
set BAYNO='{0}',OLDBAYNO='{1}',BAY_OPERNAME='{2}',BAY_OPERTIME=to_date('{3}', 'yyyy-mm-dd HH24:mi:ss'),USER_NAME='{4}'
where SHIP_ID='{5}' and CONTAINER_NO='{6}'",
strBayno, strOldbayno, shipImage.modifier, shipImage.modifytime, strUserName, shipImage.ship_id, shipImage.container_no);
da.ExecuteNonQuery(strSql);
}
}
da.CommitTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "上传成功！").DicInfo());
log.LogCatalogSuccess();
}
catch (Exception ex)
{
da.RollbackTransaction();
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 strAccount = Request.Params["Account"];
//密码
string strPassword = Request.Params["Password"];
AppLog log = new AppLog(Request);
log.strAccount = strAccount;
log.strBehavior = "用户登陆";
log.strBehaviorURL = "/Entrance/Login.aspx";
try
{
if (strAccount == null || strPassword == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，登录失败！").DicInfo());
return;
}
string strSql = null;
strSql = string.Format("select username from tb_app_tally_user where logogram='{0}'", strAccount);
var dt0 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strSql);
if (dt0.Rows.Count >= 0)
{
strSql =
string.Format(@"select user_id,password,serial_nam,work_no from SYSTEM_USER_TABLE
where serial_nam='{0}' and password='******'",
strAccount, strPassword);
}
else
{
strSql =
string.Format(@"select user_id,password,serial_nam,work_no from SYSTEM_USER_TABLE
where serial_nam='{0}' and password='******' and work_no is not null",
strAccount, strPassword);
}
var dt1 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTallySqlServer).ExecuteTable(strSql);
if (dt1.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "用户名或密码错误！").DicInfo());
return;
}
//string[] strArray = new string[4];
//strArray[0] = Convert.ToString(dt.Rows[0]["user_id"].ToString());
//strArray[1] = Convert.ToString(dt.Rows[0]["serial_nam"].ToString());
//strArray[2] = Convert.ToString(dt.Rows[0]["password"].ToString());
//strArray[3] = Convert.ToString(dt.Rows[0]["work_no"].ToString());
Json = JsonConvert.SerializeObject(new DicPackage(true, dt1.Rows[0]["user_id"].ToString(), 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)
{
//用户ID
var codeUser = Request.Params["CodeUser"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (codeUser == null)
{
info.Add("参加CodeUser", "http://218.92.115.55/MobilePlatform/UserPermission/GetPerContactDetail.aspx?CodeUser=67545");
Json = JsonConvert.SerializeObject(info);
return;
}
string sql = string.Format("select code,Description from gpms2000_nbw..department_sr");
var dt0 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathNbwDept).ExecuteTable(sql);
if (dt0.Rows.Count == 0)
{
info.Add("IsGet", "No");
info.Add("Message", "网络错误，请稍后再试！");
Json = JsonConvert.SerializeObject(info);
return;
}
sql =
string.Format(
"select t.user_id,t.login_name,t.user_name,t.tel,t.email,t.company_id,t.company_name,t.dept_id,t.tel1,t.duty,t.tel2,t.pemail,t.phone1,t.head_pic from VW_SYS_USER t where t.user_id='{0}'",
codeUser);
var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathMa).ExecuteTable(sql);
if (dt1.Rows.Count == 0)
{
info.Add("IsGet", "No");
info.Add("Message", "用户ID不存在！");
Json = JsonConvert.SerializeObject(info);
return;
}
string departmentName = "";
bool markWeibo = true;
var rows = dt0.Select(string.Format("CODE='{0}'", Convert.ToString(dt1.Rows[0]["dept_id"])));
if (rows.Length > 0)
{
departmentName = rows[0]["DESCRIPTION"] as string;
}
markWeibo =
!(dt1.Rows[0]["EMAIL"] is DBNull) && !string.IsNullOrEmpty(dt1.Rows[0]["EMAIL"] as string) &&
!string.IsNullOrWhiteSpace(dt1.Rows[0]["EMAIL"] as string);
info.Add("姓名", Convert.ToString(dt1.Rows[0]["USER_NAME"]));
info.Add("机构", Convert.ToString(dt1.Rows[0]["COMPANY_NAME"]));
info.Add("部门", departmentName);
info.Add("职务", Convert.ToString(dt1.Rows[0]["DUTY"]));
info.Add("工作手机", Convert.ToString(dt1.Rows[0]["TEL"]));
info.Add("备用手机", Convert.ToString(dt1.Rows[0]["PHONE1"]));
info.Add("办公室电话", Convert.ToString(dt1.Rows[0]["TEL1"]));
info.Add("备用电话", Convert.ToString(dt1.Rows[0]["TEL2"]));
info.Add("集团邮箱", Convert.ToString(dt1.Rows[0]["EMAIL"]));
info.Add("个人邮箱", Convert.ToString(dt1.Rows[0]["PEMAIL"]));
info.Add("云之家微博", markWeibo == true ? "已开通" : "未开通");
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsGet", "No");
info.Add("Message", ex.Message);
Json = JsonConvert.SerializeObject(info);
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//应用名称
var appName = Request.Params["AppName"];
try
{
if (appName == null)
{
string warning = "参数AppName不能为null！举例：http://218.92.115.55/MobilePlatform/Contacts/GetPersonContactList.aspx?AppName=WLKG";
Json = JsonConvert.SerializeObject(warning);
return;
}
//获取App应用对应的公司，公司对应的内部网公司ID
string nbwCompanyId = DictionaryTool.GetNbwCompanyId(appName.ToUpper());
if (nbwCompanyId == string.Empty)
{
string warning = "应用名称错误！";
Json = JsonConvert.SerializeObject(warning);
return;
}
string sql = string.Format("select code,Description from gpms2000_nbw..department_sr");
var dt0 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathNbwDept).ExecuteTable(sql);
if (dt0.Rows.Count == 0)
{
string error = "网络错误，请稍后再试！";
Json = JsonConvert.SerializeObject(error);
return;
}
sql =
string.Format(
"select a.id,a.username as login_name,a.truename as user_name,a.tel,a.email,a.companyid as company_id,b.shortname as company_name,a.bumenid as dept_id,a.tel1,a.duty,a.tel2,a.pemail,a.phone1,a.head_pic from user_info a, company_name b where a.companyid='{0}' and substr(a.bumenid,1,4)=b.companyid order by user_name",
nbwCompanyId);
var dt1 = new Leo.Oracle.DataAccess(RegistryKey.KeyPathNbw).ExecuteTable(sql);
var infoArray = new List <Dictionary <string, string> >();
for (int iRow = 0; iRow < dt1.Rows.Count; iRow++)
{
string departmentName = "";
bool markWeibo = true;
var rows = dt0.Select(string.Format("CODE='{0}'", Convert.ToString(dt1.Rows[iRow]["dept_id"])));
if (rows.Length > 0)
{
departmentName = rows[0]["DESCRIPTION"] as string;
}
departmentName = departmentName == null ? string.Empty : departmentName;
markWeibo =
!(dt1.Rows[iRow]["EMAIL"] is DBNull) && !string.IsNullOrEmpty(dt1.Rows[iRow]["EMAIL"] as string) &&
!string.IsNullOrWhiteSpace(dt1.Rows[iRow]["EMAIL"] as string);
Dictionary <string, string> info = new Dictionary <string, string>();
info.Add("userID", Convert.ToString(dt1.Rows[iRow]["ID"]));
info.Add("name", Convert.ToString(dt1.Rows[iRow]["USER_NAME"]));
info.Add("company", Convert.ToString(dt1.Rows[iRow]["COMPANY_NAME"]));
info.Add("department", departmentName);
info.Add("duty", Convert.ToString(dt1.Rows[iRow]["DUTY"]));
info.Add("mobilephone", Convert.ToString(dt1.Rows[iRow]["TEL"]));
info.Add("backupmobilephone", Convert.ToString(dt1.Rows[iRow]["PHONE1"]));
info.Add("telephone", Convert.ToString(dt1.Rows[iRow]["TEL1"]));
info.Add("backuptelephone", Convert.ToString(dt1.Rows[iRow]["TEL2"]));
info.Add("workemail", Convert.ToString(dt1.Rows[iRow]["EMAIL"]));
info.Add("personalemail", Convert.ToString(dt1.Rows[iRow]["PEMAIL"]));
info.Add("weibo", markWeibo == true ? "已开通" : "未开通");
infoArray.Add(info);
}
Json = JsonConvert.SerializeObject(infoArray);
}
catch (Exception ex)
{
Json = JsonConvert.SerializeObject(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//航次Id
string strShipId = Request.Params["ShipId"];
//船舶Id
string strV_Id = Request.Params["V_Id"];
//箱号1
string strContainerNo1 = Request.Params["ContainerNo1"];
//箱号2
string strContainerNo2 = Request.Params["ContainerNo2"];
//目标贝号
string strEndBayno = Request.Params["EndBayno"];
//用户ID
string strUserId = Request.Params["UserId"];
//strShipId = "195";
//strV_Id = "6321";
////strContainerNo1 = "FCIU4708678";
//strContainerNo1 = "ZGXU2382004";
//strContainerNo2 = "CXDU2375239";
//strEndBayno = "090484";
//strUserId = "215";
AppLog log = new AppLog(Request);
log.strBehavior = "双吊";
log.strBehaviorURL = "/Move/DoubleLift.aspx";
log.strAccount = strUserId;
try
{
if (strShipId == null || strV_Id == null || strContainerNo1 == null || strContainerNo2 == null || strEndBayno == null || strUserId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，双吊失败！").DicInfo());
return;
}
da.BeginTransaction();
IMoveBay iMoveBay = new IMoveBay(log);
iMoveBay.setDataAccess(da);
//校验目标贝位号是否存在
if (!iMoveBay.isExistBayno(strV_Id, strEndBayno))
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "错误贝位号").DicInfo());
log.LogCatalogFailure(string.Format("错误贝位号"));
return;
}
//后通目标贝位号
String backEndBayno = Convert.ToString((Convert.ToInt16(strEndBayno.Substring(0, 2)) + 2)).PadLeft(2, '0') + strEndBayno.Substring(2).PadLeft(4, '0');
//校验后通目标贝位号是否存在
if (!iMoveBay.isExistBayno(strV_Id, backEndBayno))
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, Convert.ToString(strEndBayno.Substring(0, 2)) + "贝不通贝").DicInfo());
log.LogCatalogFailure(string.Format(Convert.ToString(strEndBayno.Substring(0, 2)) + "贝不通贝"));
return;
}
string strOperareName = string.Empty;
string strSql = string.Format(@"select distinct name
from SYSTEM_USER_TABLE
where user_id='{0}'",
strUserId);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTallySqlServer).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strOperareName = Convert.ToString(dt.Rows[0]["name"]);
}
//获取待移集装箱信息
strSql =
string.Format(@"select size_con,bayno
from con_image
where container_no='{0}' and ship_id={1}",
strContainerNo1, strShipId);
var dt1 = da.ExecuteTable(strSql);
if (dt1.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "待调集装箱号不存在").DicInfo());
log.LogCatalogFailure(string.Format("待调集装箱号不存在"));
return;
}
strSql =
string.Format(@"select size_con,bayno
from con_image
where container_no='{0}' and ship_id={1}",
strContainerNo2, strShipId);
var dt2 = da.ExecuteTable(strSql);
if (dt2.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "待调集装箱号不存在").DicInfo());
log.LogCatalogFailure(string.Format("待调集装箱号不存在"));
return;
}
Json = iMoveBay.DoubleLift(strShipId, strContainerNo1, Convert.ToString(dt1.Rows[0]["bayno"]), strContainerNo2, Convert.ToString(dt2.Rows[0]["bayno"]), strEndBayno, strOperareName);
if (Json != null)
{
return;
}
da.CommitTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "上传成功！").DicInfo());
log.LogCatalogSuccess();
}
catch (Exception ex)
{
da.RollbackTransaction();
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 strStartRow = Request.Params["StartRow"];
//行数
string strCount = Request.Params["Count"];
//用户ID
string strUserId = Request.Params["UserId"];
try
{
if (strStartRow == null || strCount == null || strUserId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，获取在港航次数据失败！").DicInfo());
return;
}
string strSql = null;
var dt = new DataTable();
strSql = string.Format("select username from tb_app_tally_user where user_id='{0}'", strUserId);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strSql =
string.Format(@"select ID SHIP_NEWID,V_ID,CODE_STATU,INOUTPORT,VOYAGE,CHI_VESSEL,ENG_VESSEL,TRADE,INOUT,WHEEL,VESSEL_CODE,VESSEL_IMO,SHIPAGENT_CHA,BERTHNO,GOODS
from VDD_SHIP_SHOW
WHERE CODE_STATU='2'
ORDER BY SHIP_NEWID DESC");
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathTally).ExecuteTable(strSql, Convert.ToInt32(strStartRow) - 1, Convert.ToInt32(strStartRow) + Convert.ToInt32(strCount));
}
else
{
strSql =
string.Format(@"select distinct c.ship_newid, a.ship_id,a.v_id,a.berthno,a.voyage,a.chi_vessel,a.inoutport,a.s_trade as trade, '' as wheel
from view_download_app a, system_user_table b, sship c
where a.ship_statu = 2 and a.dept_code = '26.11.12' and(a.work_no = b.work_no or a.work_tally = b.work_no) and a.ship_id = c.ship_id and c.ship_newid is not null and b.user_id='{0}'
order by a.ship_id desc ", strUserId);
dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTallySqlServer).ExecuteTable(strSql, Convert.ToInt32(strStartRow) - 1, Convert.ToInt32(strStartRow) + Convert.ToInt32(strCount));
}
if (dt.Rows.Count <= 0)
{
string strWarning = strStartRow == "1" ? "暂无数据！" : "暂无更多数据！";
Json = JsonConvert.SerializeObject(new DicPackage(true, null, strWarning).DicInfo());
return;
}
string[,] strArray = new string[dt.Rows.Count, 8];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = dt.Rows[iRow]["SHIP_NEWID"].ToString();
strArray[iRow, 1] = dt.Rows[iRow]["V_ID"].ToString();
strArray[iRow, 2] = dt.Rows[iRow]["BERTHNO"].ToString();
strArray[iRow, 3] = dt.Rows[iRow]["VOYAGE"].ToString();
strArray[iRow, 4] = dt.Rows[iRow]["CHI_VESSEL"].ToString();
strArray[iRow, 5] = dt.Rows[iRow]["INOUTPORT"].ToString();
strArray[iRow, 6] = dt.Rows[iRow]["TRADE"].ToString();
strArray[iRow, 7] = dt.Rows[iRow]["WHEEL"].ToString();
}
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)
{
//数据起始行
var startRow = Request.Params["StartRow"];
//行数
var count = Request.Params["Count"];
//公司编码
var codeDepartment = Request.Params["CodeDepartment"];
//白夜班
var dayNight = Request.Params["DayNight"];
//班组日期
var teamDate = Request.Params["TeamDate"];
codeDepartment = "11";
//startRow = "1";
//count = "30";
//dayNight = "白班";
//teamDate = "2015-09-22";
try
{
if (startRow == null || count == null || codeDepartment == null || dayNight == null || teamDate == null)
{
string warning = string.Format("参数StartRow，Count，CodeDepartment，TeamDate不能为null！举例：http://218.92.115.55/M_Lhgl/Service/Weighing/GetWeighting.aspx?StartRow=1&Count=14&CodeDepartment=11&DayNight=白班&TeamDate=2015-08-19");
Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo());
return;
}
// 每日过磅统计。
string VwDailyCount = "select consign,department,departmentname,client,ship,billnumber1,cargo,weight,sum(weight2-weight1) netweight,count(truck) trucknumber from BALANCECENTER..vw_metages ";
//获取班次统计时间
string strSql = string.Format("select DayTime,NightTime from BALANCECENTER..RunConfig where Department = {0}", codeDepartment);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql);
string day = " 06:00";
string night = " 17:00";
if (dt.Rows.Count > 0)
{
day = StringTool.ToDayNightForSql(dt.Rows[0]["DayTime"].ToString());
night = StringTool.ToDayNightForSql(dt.Rows[0]["NightTime"].ToString());
}
//拼接查询条件
string strFilter;
if (dayNight == "白班")//
{
strFilter =
string.Format(
"department='{0}' and FinishTime is not null and finishtime<'{1}' and finishtime>='{2}' ",
codeDepartment,
string.Concat(Convert.ToDateTime(teamDate).ToShortDateString(), night),
string.Concat(Convert.ToDateTime(teamDate).ToShortDateString(), day));
}
else
{
strFilter =
string.Format(
"department='{0}' and FinishTime is not null and ((finishtime>='{1}' and finishtime<='{2}') or (finishtime>='{3}' and finishtime<'{4}')) ",
codeDepartment,
string.Concat(Convert.ToDateTime(teamDate).ToShortDateString(), night),
string.Concat(Convert.ToDateTime(teamDate).AddDays(1).ToShortDateString(), " 00:00"),
string.Concat(Convert.ToDateTime(teamDate).AddDays(1).ToShortDateString(), " 00:00"),
string.Concat(Convert.ToDateTime(teamDate).AddDays(1).ToShortDateString(), day));
}
//获取当班数据、累计数据 拼入一个DataTab
strSql =
string.Format(
"{0} where {1} group by consign,department,departmentname,client,ship,billnumber1,cargo,weight ",
VwDailyCount, strFilter);
dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql, Convert.ToInt32(startRow), Convert.ToInt32(startRow) + Convert.ToInt32(count) - 1);
string[,] strArray = new string[dt.Rows.Count, 6];
for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
{
strArray[iRow, 0] = Convert.ToString(dt.Rows[iRow]["consign"]);
strArray[iRow, 1] = Convert.ToString(dt.Rows[iRow]["ship"]);
strArray[iRow, 2] = Convert.ToString(dt.Rows[iRow]["client"]);
strArray[iRow, 3] = Convert.ToString(dt.Rows[iRow]["cargo"]);
strArray[iRow, 4] = Convert.ToString(dt.Rows[iRow]["weight"]);
strArray[iRow, 5] = Convert.ToString(dt.Rows[iRow]["netweight"]);
}
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)
{
//号码
var no = Request.Params["No"];
//识别方式
var recognizeMethod = Request.Params["RecognizeMethod"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (no == null || recognizeMethod == null)
{
info.Add("IsGet", "No");
info.Add("参数ExterNo，ScanType不能为null！举例", "http://218.92.115.55/M_Hmw/GetService/Scan/GetBasicInfo.aspx?No=904250&RecognizeMethod=QR");
Json = JsonConvert.SerializeObject(info);
return;
}
//号码字段名称
string noFieldName = string.Empty;
//识别方式名称
string recognizeName = string.Empty;
//SQL
string sql = string.Empty;
//车号
string vehicle = string.Empty;
//卡号
string cardNo = string.Empty;
switch (recognizeMethod)
{
case "QR":
noFieldName = "EXTER_NO";
recognizeName = "二维码";
break;
case "NFC":
noFieldName = "PARK_CARD_NO";
recognizeName = "NFC";
break;
default:
throw new Exception("错误的对象索引");
}
//验证NO
sql =
string.Format("select exter_no,vehicle,card_no from TRANSIT.CARD where {0}='{1}'", noFieldName, no);
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsGet", "No");
info.Add("Message", "此卡不存在，读取失败！");
Json = JsonConvert.SerializeObject(info);
return;
}
vehicle = Convert.ToString(dt.Rows[0]["vehicle"]);
cardNo = Convert.ToString(dt.Rows[0]["card_no"]);
no = Convert.ToString(dt.Rows[0]["exter_no"]);
//申报时间
string submitTime = string.Empty;
//码头公司
string department = string.Empty;
//任务号
string taskno = string.Empty;
//类别
string fullorempty = string.Empty;
//货名
string cargo = string.Empty;
//场地货位
string storagebooth = string.Empty;
//到港时间
string preptime = string.Empty;
//放行时间
string audittime = string.Empty;
//内部委托号
string cgno = string.Empty;
//办证时间
string recordTime = string.Empty;
//进港时间
string gateInTime = string.Empty;
//离港时间
string gateOutTime = string.Empty;
//过磅时间
string recordTime1 = string.Empty;
//货重
string weightCargo = string.Empty;
//运输申报
sql =
string.Format(@"select INGATENO,to_char(SUBMITTIME, 'yyyy-MM-dd HH24:mi :ss') as SUBMITTIME,SUBMIT_COMP,SUBMIT_ADDR,DEPARTMENT,PERMITNO,WEIGHT,STORAGE || BOOTH as STORAGEBOOTH,to_char(PREPTIME, 'yyyy-MM-dd HH24:mi :ss') as PREPTIME,to_char(AUDITTIME, 'yyyy-MM-dd HH24:mi :ss') as AUDITTIME,CGNO
from Harbor.V_CONSIGN_VEHICLE_ONLY_QUICK where EXTER_NO='{0}' and VEHICLE='{1}'", no, vehicle);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
if (dt.Rows.Count != 0)
{
submitTime = Convert.ToString(dt.Rows[0]["SUBMITTIME"]);
department = Convert.ToString(dt.Rows[0]["DEPARTMENT"]);
storagebooth = Convert.ToString(dt.Rows[0]["STORAGEBOOTH"]);
preptime = Convert.ToString(dt.Rows[0]["PREPTIME"]);
audittime = Convert.ToString(dt.Rows[0]["AUDITTIME"]);
cgno = Convert.ToString(dt.Rows[0]["CGNO"]);
}
sql =
string.Format(@"select TASKNO,FULLOREMPTY,CARGO,CLIENT,VESSEL
from Harbor.V_CONSIGN_QUICK where CGNO='{0}'", cgno);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
if (dt.Rows.Count != 0)
{
taskno = Convert.ToString(dt.Rows[0]["TASKNO"]);
fullorempty = Convert.ToString(dt.Rows[0]["FULLOREMPTY"]);
cargo = Convert.ToString(dt.Rows[0]["CARGO"]);
}
//港区放行
sql =
string.Format(@"select OPER,to_char(RECORD_TIME, 'yyyy-MM-dd HH24:mi :ss') as RECORD_TIME,FEE_NAME,ENDDATE
from Transit.V_PARLOR_RECORD_ALL
where CARD_NO='{0}' and VEHICLE='{1}' and MARK_VALID='1' order by RECORD_TIME desc", cardNo, vehicle);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
if (dt.Rows.Count != 0)
{
recordTime = Convert.ToString(dt.Rows[0]["RECORD_TIME"]);
}
sql =
string.Format(@"select GATE_IN_NAME,GATE_OUT_NAME,to_char(GATE_IN_TIME, 'yyyy-MM-dd HH24:mi :ss') as GATE_IN_TIME,to_char(GATE_OUT_TIME, 'yyyy-MM-dd HH24:mi :ss') as GATE_OUT_TIME
from Transit.V_GATE_TIME
where CARD_NO='{0}' and VEHICLE='{1}' order by GATE_IN_TIME desc", cardNo, vehicle);
dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
if (dt.Rows.Count != 0)
{
gateInTime = Convert.ToString(dt.Rows[0]["GATE_IN_TIME"]);
gateOutTime = Convert.ToString(dt.Rows[0]["GATE_OUT_TIME"]);
}
//过磅记录
sql =
string.Format(@"select convert(varchar(100), RECORDTIME, 120) as RECORDTIME,WEIGHTCARGO,RECORD1,WEIGHT1,RECORD2,WEIGHT2
from BalanceCenter..V_MetageForComm
where CARDNO='{0}' and TRUCK='{1}' order by RECORDTIME desc", cardNo, vehicle);
dt = new Leo.SqlServer.DataAccess(Leo.RegistryKey.KeyPathBc).ExecuteTable(sql);
if (dt.Rows.Count != 0)
{
recordTime1 = Convert.ToString(dt.Rows[0]["RECORDTIME"]);
weightCargo = Convert.ToString(dt.Rows[0]["WEIGHTCARGO"]) == "" ? "" : string.Format("{0:N2}", Convert.ToDouble(dt.Rows[0]["WEIGHTCARGO"]) / 1000);
}
string[] nameArry = { "识别方式", "车牌号", "卡编号", "任务号", "码头公司", "类别", "货名", "场地货位", "申报时间",
"到港时间", "放行时间", "办证时间", "入港时间", "过磅时间", "货重", "离港时间" };
//排序字符串
string order = string.Empty;
order = nameArry[0] + "+" + nameArry[1] + "+" + nameArry[2] + "+" + nameArry[3] + "+" + nameArry[4] + "+" + nameArry[5] + "+" +
nameArry[6] + "+" + nameArry[7] + "+" + nameArry[8] + "+" + nameArry[9] + "+" + nameArry[10] + "+" + nameArry[11] + "+" +
nameArry[12] + "+" + nameArry[13] + "+" + nameArry[14] + "+" + nameArry[15];
info.Add(nameArry[0], recognizeName);
info.Add(nameArry[1], vehicle);
info.Add(nameArry[2], no);
info.Add(nameArry[3], taskno);
info.Add(nameArry[4], department);
info.Add(nameArry[5], fullorempty);
info.Add(nameArry[6], cargo);
info.Add(nameArry[7], storagebooth);
info.Add(nameArry[8], submitTime);
info.Add(nameArry[9], preptime);
info.Add(nameArry[10], audittime);
info.Add(nameArry[11], recordTime);
info.Add(nameArry[12], gateInTime);
info.Add(nameArry[13], recordTime1);
info.Add(nameArry[14], weightCargo);
info.Add(nameArry[15], gateOutTime);
info.Add("Order", order);
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsGet", "No");
info.Add("Message", ex.Message);
Json = JsonConvert.SerializeObject(info);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//航次Id
string strShipId = Request.Params["ShipId"];
//船舶Id
string strV_Id = Request.Params["V_Id"];
//箱号
string strContainerNo = Request.Params["ContainerNo"];
//目标贝号
string strEndBayno = Request.Params["EndBayno"];
//用户ID
string strUserId = Request.Params["UserId"];
//strShipId = "195";
//strV_Id = "6321";
//strContainerNo = "CXDU2283528";
//strEndBayno = "050304";
//strUserId = "215";
AppLog log = new AppLog(Request);
log.strBehavior = "移贝";
log.strBehaviorURL = "/Move/MoveBay.aspx";
log.strAccount = strUserId;
try
{
if (strShipId == null || strV_Id == null || strContainerNo == null || strEndBayno == null || strUserId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，移贝失败！").DicInfo());
log.LogCatalogFailure(string.Format("参数错误，移贝失败"));
return;
}
da.BeginTransaction();
IMoveBay iMoveBay = new IMoveBay(log);
iMoveBay.setDataAccess(da);
//校验目标贝位号是否存在
if (!iMoveBay.isExistBayno(strV_Id, strEndBayno))
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "错误贝位号").DicInfo());
log.LogCatalogFailure(string.Format("错误贝位号"));
return;
}
string strOperareName = string.Empty;
string strSql = string.Format(@"select distinct name
from SYSTEM_USER_TABLE
where user_id='{0}'",
strUserId);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTallySqlServer).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strOperareName = Convert.ToString(dt.Rows[0]["name"]);
}
//获取待移集装箱信息
strSql =
string.Format(@"select size_con,bayno
from con_image
where container_no='{0}' and ship_id={1}",
strContainerNo, strShipId);
dt = da.ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "待移集装箱号不存在").DicInfo());
log.LogCatalogFailure(string.Format("待移集装箱号不存在"));
return;
}
if (Convert.ToInt16(dt.Rows[0]["size_con"]) == 20)
{
Json = iMoveBay.MoveBayOfTwenty(strShipId, strContainerNo, Convert.ToString(dt.Rows[0]["bayno"]), strEndBayno, strOperareName);
}
else
{
Json = iMoveBay.MoveBayOfForty(strShipId, strContainerNo, Convert.ToString(dt.Rows[0]["bayno"]), strEndBayno, strOperareName);
}
if (Json != null)
{
return;
}
da.CommitTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "上传成功！").DicInfo());
log.LogCatalogSuccess();
}
catch (Exception ex)
{
da.RollbackTransaction();
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)
{
//号码（通行证号/NFC卡号）
var no = Request.Params["No"];
//公司编码
var codeCompany = Request.Params["CodeCompany"];
//识别方式
var recognizeMethod = Request.Params["RecognizeMethod"];
try
{
if (no == null || codeCompany == null || recognizeMethod == null)
{
string warning = string.Format("参数No,CodeCompany，RecognizeMethod不能为null！举例：http://218.92.115.55/M_Lhgl/Service/Vehicle/GetStartWork.aspx?No=690000&CodeCompany=77&RecognizeMethod=CARD");
Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo());
return;
}
//号码字段名称
string strNoFieldName = string.Empty;
//黑名单
string strBlackList = string.Empty;
//卡状态
string strState = string.Empty;
//卡禁用
string strForbidMark = string.Empty;
//车状态
string strVehState = string.Empty;
//车牌号
string strVehicle = string.Empty;
//卡号
string cardNo = string.Empty;
//场地
string strStorage = string.Empty;
//货位
string strBooth = string.Empty;
//ID
string strId = string.Empty;
//内部委托号
string strCgno = string.Empty;
//任务号
string strTaskno = string.Empty;
//货物
string strCargo = string.Empty;
//船名
string strVessel = string.Empty;
//货代
string strClient = string.Empty;
//集疏港
string strFullOrEmpty = string.Empty;
//装卸货
string strWorkStyle = string.Empty;
//衡重
string strWeight = string.Empty;
//申报时间
string strSubmittime = string.Empty;
string[] strNameArray = { "ID", "车号", "船名", "货代", "货物", "场地", "货位", "集疏港", "装卸车", "任务号", "通行证号", "申报时间", "衡重" };
Dictionary <string, object> info = new Dictionary <string, object>();
//号码字段名称
switch (recognizeMethod)
{
case "CARD":
strNoFieldName = "EXTER_NO";
break;
case "NFC":
strNoFieldName = "PARK_CARD_NO";
break;
default:
throw new Exception("错误的对象索引");
}
//校验状态：黑名单无效，卡状态不是在用无效，卡被禁用无效，车状态不在港内无效
string strSql =
string.Format("select blacklist,state,forbid_mark,veh_state,vehicle,exter_no,card_no from TRANSIT.V_VEH_CARD_HARBOR where {0}='{1}'", strNoFieldName, no.ToUpper());
var dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "此卡无效！").DicInfo());
return;
}
strBlackList = Convert.ToString(dt.Rows[0]["blacklist"]);
strState = Convert.ToString(dt.Rows[0]["state"]);
strForbidMark = Convert.ToString(dt.Rows[0]["forbid_mark"]);
strVehState = Convert.ToString(dt.Rows[0]["veh_state"]);
strVehicle = Convert.ToString(dt.Rows[0]["vehicle"]);
no = Convert.ToString(dt.Rows[0]["exter_no"]);
cardNo = Convert.ToString(dt.Rows[0]["card_no"]);
if (strState != "1")
{
info = GetAllInfo(strNameArray, strId, strVehicle, strVessel, strClient, strCargo, strStorage, strBooth, strFullOrEmpty, strWorkStyle, strTaskno, no, strSubmittime, strWeight);
Json = JsonConvert.SerializeObject(new DicPackage(false, info, "此卡当前状态无用！").DicInfo());
return;
}
if (strForbidMark == "1")
{
info = GetAllInfo(strNameArray, strId, strVehicle, strVessel, strClient, strCargo, strStorage, strBooth, strFullOrEmpty, strWorkStyle, strTaskno, no, strSubmittime, strWeight);
Json = JsonConvert.SerializeObject(new DicPackage(false, info, "此卡禁用！").DicInfo());
return;
}
if (strVehState != "1")
{
info = GetAllInfo(strNameArray, strId, strVehicle, strVessel, strClient, strCargo, strStorage, strBooth, strFullOrEmpty, strWorkStyle, strTaskno, no, strSubmittime, strWeight);
Json = JsonConvert.SerializeObject(new DicPackage(false, info, "此车不在港内！").DicInfo());
return;
}
//校验状态：未放行无效
strSql =
string.Format(@"select id,audit_mark,storage,booth,cgno,to_char(submittime, 'yyyy-MM-dd HH24:mi :ss') as submittime
from Harbor.V_CONSIGN_VEHICLE_ONLY_QUICK
where submittime>sysdate-1 and code_department='{0}' and exter_no='{1}' and vehicle='{2}'
order by submittime desc",
codeCompany, no, strVehicle);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql);
if (dt.Rows.Count <= 0 || Convert.ToString(dt.Rows[0]["audit_mark"]) != "1")
{
info = GetAllInfo(strNameArray, strId, strVehicle, strVessel, strClient, strCargo, strStorage, strBooth, strFullOrEmpty, strWorkStyle, strTaskno, no, strSubmittime, strWeight);
Json = JsonConvert.SerializeObject(new DicPackage(false, info, "此车未放行！").DicInfo());
return;
}
strStorage = Convert.ToString(dt.Rows[0]["storage"]);
strBooth = Convert.ToString(dt.Rows[0]["booth"]);
strId = Convert.ToString(dt.Rows[0]["id"]);
strCgno = Convert.ToString(dt.Rows[0]["cgno"]);
strSubmittime = Convert.ToString(dt.Rows[0]["SUBMITTIME"]);
//对于东联的申报，还要检查是否通过车辆检查
if (codeCompany == "77")
{
strSql =
string.Format(@"select check_mark
from CGATE.v_cgate_record_cache t
where pass_time>sysdate-1 and code_company='{0}' and exter_no='{1}' and vehicle='{2}' and inout_mark='0'
order by pass_time desc",
codeCompany, no, strVehicle);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql);
if (dt.Rows.Count <= 0 || string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["check_mark"])))
{
info = GetAllInfo(strNameArray, strId, strVehicle, strVessel, strClient, strCargo, strStorage, strBooth, strFullOrEmpty, strWorkStyle, strTaskno, no, strSubmittime, strWeight);
Json = JsonConvert.SerializeObject(new DicPackage(false, info, "此车未进门！").DicInfo());
return;
}
if (Convert.ToString(dt.Rows[0]["check_mark"]) != "1")
{
info = GetAllInfo(strNameArray, strId, strVehicle, strVessel, strClient, strCargo, strStorage, strBooth, strFullOrEmpty, strWorkStyle, strTaskno, no, strSubmittime, strWeight);
Json = JsonConvert.SerializeObject(new DicPackage(false, info, "此车未通过检查！").DicInfo());
return;
}
}
//校验：过磅记录
strSql =
string.Format(@"select weight1,weight2,weightcargo
from BALANCECENTER..V_MetageForComm
where RecordTime>getdate()-1 and CardNo='{0}' and Truck='{1}' order by RecordTime desc ",
cardNo, strVehicle);
dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
info = GetAllInfo(strNameArray, strId, strVehicle, strVessel, strClient, strCargo, strStorage, strBooth, strFullOrEmpty, strWorkStyle, strTaskno, no, strSubmittime, strWeight);
Json = JsonConvert.SerializeObject(new DicPackage(false, info, "此车无过磅记录！").DicInfo());
return;
}
if (!string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["weightcargo"])))
{
info = GetAllInfo(strNameArray, strId, strVehicle, strVessel, strClient, strCargo, strStorage, strBooth, strFullOrEmpty, strWorkStyle, strTaskno, no, strSubmittime, strWeight);
Json = JsonConvert.SerializeObject(new DicPackage(false, info, "此车已过完磅！").DicInfo());
return;
}
if (string.IsNullOrWhiteSpace(Convert.ToString(dt.Rows[0]["weight1"])))
{
strWeight = string.Format("{0:N2}", Convert.ToInt32(dt.Rows[0]["weight2"]) / 1000);
}
else
{
strWeight = string.Format("{0:N2}", Convert.ToInt32(dt.Rows[0]["weight1"]) / 1000);
}
//获取申报信息
strSql =
string.Format("select taskno,cargo,vessel,client,fullorempty from HARBOR.V_CONSIGN_QUICK where cgno='{0}'", strCgno);
dt = new Leo.Oracle.DataAccess(RegistryKey.KeyPathHarbor).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strTaskno = Convert.ToString(dt.Rows[0]["taskno"]);
strCargo = Convert.ToString(dt.Rows[0]["cargo"]);
strVessel = Convert.ToString(dt.Rows[0]["vessel"]);
strClient = Convert.ToString(dt.Rows[0]["client"]);
strFullOrEmpty = Convert.ToString(dt.Rows[0]["fullorempty"]);
strWorkStyle = strFullOrEmpty == "集港" ? "卸车" : "装车";
}
info = GetAllInfo(strNameArray, strId, strVehicle, strVessel, strClient, strCargo, strStorage, strBooth, strFullOrEmpty, strWorkStyle, strTaskno, no, strSubmittime, strWeight);
if (strBlackList == "1")
{
Json = JsonConvert.SerializeObject(new DicPackage(true, info, "此车黑名单！").DicInfo());
}
else
{
Json = JsonConvert.SerializeObject(new DicPackage(true, info, 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)
{
//委托编码
var cgno = Request.Params["Cgno"];
//公司编码
var codeDepartment = Request.Params["CodeDepartment"];
//白夜班
var dayNight = Request.Params["DayNight"];
//班组日期
var teamDate = Request.Params["TeamDate"];
//cgno = "1511099525";
//codeDepartment = "11";
//dayNight = "白班";
//teamDate = "2016-01-08";
try
{
if (cgno == null || codeDepartment == null || dayNight == null || teamDate == null)
{
string warning = string.Format("参数Cgno，CodeDepartment，TeamDate不能为null！举例：http://218.92.115.55/M_DL_Gwtxc/Service/Weighing/GetWeighting.aspx?Cgno=0114111611&CodeDepartment=11&DayNight=白班&TeamDate=2015-08-19");
Json = JsonConvert.SerializeObject(new DicPackage(false, null, warning).DicInfo());
return;
}
// 每日过磅统计。
string VwDailyCount = "select consign,department,departmentname,client,ship,billnumber1,cargo,weight,sum(weight2-weight1) netweight,count(truck) trucknumber from BALANCECENTER..vw_metages ";
// 每日过磅统计(累计)。
string VwDailyCount2 = " select consign,sum(weight2-weight1) netweight,count(truck) trucknumber from BALANCECENTER..vw_metages ";
//获取班次统计时间
string strSql = string.Format("select DayTime,NightTime from BALANCECENTER..RunConfig where Department = {0}", codeDepartment);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql);
string day = " 06:00";
string night = " 17:00";
if (dt.Rows.Count > 0)
{
day = StringTool.ToDayNightForSql(dt.Rows[0]["DayTime"].ToString());
night = StringTool.ToDayNightForSql(dt.Rows[0]["NightTime"].ToString());
}
//拼接查询条件
string strFilter;
if (dayNight == "白班")//
{
strFilter =
string.Format(
"department='{0}' and FinishTime is not null and finishtime<'{1}' and finishtime>='{2}' and consign='{3}'",
codeDepartment,
string.Concat(Convert.ToDateTime(teamDate).ToShortDateString(), night),
string.Concat(Convert.ToDateTime(teamDate).ToShortDateString(), day),
cgno);
}
else
{
strFilter =
string.Format(
"department='{0}' and FinishTime is not null and ((finishtime>='{1}' and finishtime<='{2}') or (finishtime>='{3}' and finishtime<'{4}')) and consign='{5}'",
codeDepartment,
string.Concat(Convert.ToDateTime(teamDate).ToShortDateString(), night),
string.Concat(Convert.ToDateTime(teamDate).AddDays(1).ToShortDateString(), " 00:00"),
string.Concat(Convert.ToDateTime(teamDate).AddDays(1).ToShortDateString(), " 00:00"),
string.Concat(Convert.ToDateTime(teamDate).AddDays(1).ToShortDateString(), day),
cgno);
}
strSql =
string.Format(
"{0} where {1} group by consign,department,departmentname,client,ship,billnumber1,cargo,weight",
VwDailyCount, strFilter);
var dt0 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql);
strSql = string.Format(" {0} where consign='{1}' group by consign ", VwDailyCount2, cgno);
var dt1 = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathBc).ExecuteTable(strSql);
if (dt1.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "委托号不存在！").DicInfo());
return;
}
string[] strNameArray = { "委托号", "船名", "委托人", "货种", "计划重量",
"当班量", "累计量", "当班车次", "累计车次",
"提单号", "公司", "班组日期", "白夜班" };
//数组排序连接
string strOrderLink = StringTool.ArrayToString(strNameArray);
Dictionary <string, object> info = new Dictionary <string, object>();
info.Add(strNameArray[0], Convert.ToString(dt0.Rows[0]["consign"]));
info.Add(strNameArray[1], Convert.ToString(dt0.Rows[0]["ship"]));
info.Add(strNameArray[2], Convert.ToString(dt0.Rows[0]["client"]));
info.Add(strNameArray[3], Convert.ToString(dt0.Rows[0]["cargo"]));
info.Add(strNameArray[4], Convert.ToString(dt0.Rows[0]["weight"]));
info.Add(strNameArray[5], Convert.ToString(dt0.Rows[0]["netweight"]));
info.Add(strNameArray[6], Convert.ToString(dt1.Rows[0]["NETWEIGHT"]));
info.Add(strNameArray[7], Convert.ToString(dt0.Rows[0]["trucknumber"]));
info.Add(strNameArray[8], Convert.ToString(dt1.Rows[0]["TRUCKNUMBER"]));
info.Add(strNameArray[9], Convert.ToString(dt0.Rows[0]["billnumber1"]));
info.Add(strNameArray[10], Convert.ToString(dt0.Rows[0]["departmentname"]));
info.Add(strNameArray[11], teamDate);
info.Add(strNameArray[12], dayNight);
info.Add("Order", strOrderLink);
Json = JsonConvert.SerializeObject(new DicPackage(true, info, 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)
{
//号码
var no = Request.Params["No"];
//识别方式
var recognizeMethod = Request.Params["RecognizeMethod"];
Dictionary <string, string> info = new Dictionary <string, string>();
try
{
if (no == null || recognizeMethod == null)
{
info.Add("IsGet", "No");
info.Add("参数ExterNo，ScanType不能为null！举例", "http://218.92.115.55/M_Hmw/GetService/Scan/GetWeighRecord.aspx?No=904250&RecognizeMethod=QR");
Json = JsonConvert.SerializeObject(info);
return;
}
//号码字段名称
string noFieldName = string.Empty;
//SQL
string sql = string.Empty;
//车号
string vehicle = string.Empty;
//卡号
string cardNo = string.Empty;
switch (recognizeMethod)
{
case "QR":
noFieldName = "EXTER_NO";
break;
case "NFC":
noFieldName = "PARK_CARD_NO";
break;
default:
throw new Exception("错误的对象索引");
}
//验证NO
sql =
string.Format("select exter_no,vehicle,card_no from TRANSIT.CARD where {0}='{1}'", noFieldName, no);
var dt = new Leo.Oracle.DataAccess(Leo.RegistryKey.KeyPathHarbors).ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
info.Add("IsGet", "No");
info.Add("Message", "此卡不存在，读取失败！");
Json = JsonConvert.SerializeObject(info);
return;
}
vehicle = Convert.ToString(dt.Rows[0]["vehicle"]);
cardNo = Convert.ToString(dt.Rows[0]["card_no"]);
string recordTime = string.Empty;
string weightCargo = string.Empty;
string record1 = string.Empty;
string weight1 = string.Empty;
string record2 = string.Empty;
string weight2 = string.Empty;
sql =
string.Format(@"select convert(varchar(100), RECORDTIME, 120) as RECORDTIME,WEIGHTCARGO,RECORD1,WEIGHT1,RECORD2,WEIGHT2
from BalanceCenter..V_MetageForComm
where CARDNO='{0}' and TRUCK='{1}' order by RECORDTIME desc", cardNo, vehicle);
dt = new Leo.SqlServer.DataAccess(Leo.RegistryKey.KeyPathBc).ExecuteTable(sql);
if (dt.Rows.Count != 0)
{
recordTime = Convert.ToString(dt.Rows[0]["RECORDTIME"]);
weightCargo = Convert.ToString(dt.Rows[0]["WEIGHTCARGO"]) == "" ? "" : string.Format("{0:N2}", Convert.ToDouble(dt.Rows[0]["WEIGHTCARGO"]) / 1000);
record1 = Convert.ToString(dt.Rows[0]["RECORD1"]);
weight1 = Convert.ToString(dt.Rows[0]["WEIGHT1"]) == "" ? "" : string.Format("{0:N2}", Convert.ToDouble(dt.Rows[0]["WEIGHT1"]) / 1000);
record2 = Convert.ToString(dt.Rows[0]["RECORD2"]);
weight2 = Convert.ToString(dt.Rows[0]["WEIGHT2"]) == "" ? "" : string.Format("{0:N2}", Convert.ToDouble(dt.Rows[0]["WEIGHT2"]) / 1000);
}
string[] nameArry = { "过磅时间", "货重", "过空时间", "空重", "过重时间", "毛重" };
//排序字符串
string order = string.Empty;
order = nameArry[0] + "+" + nameArry[1] + "+" + nameArry[2] + "+" + nameArry[3] + "+" + nameArry[4] + "+" + nameArry[5];
info.Add(nameArry[0], recordTime);
info.Add(nameArry[1], weightCargo);
info.Add(nameArry[2], record1);
info.Add(nameArry[3], weight1);
info.Add(nameArry[4], record2);
info.Add(nameArry[5], weight2);
info.Add("Order", order);
Json = JsonConvert.SerializeObject(info);
}
catch (Exception ex)
{
info.Add("IsGet", "No");
info.Add("Message", ex.Message);
Json = JsonConvert.SerializeObject(info);
}
}
