public static string check_audit_save(string ordercode, string checktime, string checkname, string checkid, string checkremark
, string auditflagtime, string auditflagname, string auditflagid, string auditcontent)
{
MethodSvc.MethodServiceClient msc = new MethodSvc.MethodServiceClient();
System.Uri Uri = new Uri("ftp://" + ConfigurationManager.AppSettings["FTPServer"] + ":" + ConfigurationManager.AppSettings["FTPPortNO"]);
string UserName = ConfigurationManager.AppSettings["FTPUserName"];
string Password = ConfigurationManager.AppSettings["FTPPassword"];
FtpHelper ftp = new FtpHelper(Uri, UserName, Password);
string username = "******"; string userid = "763"; string realname = "昆山吉时报关有限公司";
string sql = ""; string resultmsg = "[]";
string feoremark = "";//记录是否需要调用费用接口
List <string> delfile = new List <string>();
DBSession db = new DBSession();
sql = @"select code,entrusttype,declstatus,inspstatus,ischeck,auditflag,checkpic
from list_order lo where lo.code='" + ordercode + "'";
DataTable dt_order = db.QuerySignle(sql);
string db_ischeck = dt_order.Rows[0]["ISCHECK"].ToString();
string db_auditflag = dt_order.Rows[0]["AUDITFLAG"].ToString();
string db_checkpic = dt_order.Rows[0]["CHECKPIC"].ToString();
int ischeck = 0; int auditflag = 0; int checkpic = db_checkpic == "1" ? 1 : 0;
DataTable dt = db.QuerySignle("select * from list_attachment where ordercode='" + ordercode + "' and filetype='67'");
foreach (DataRow dr in dt.Rows)
{
delfile.Add(dr["FILENAME"] + "");
}
db.Dispose();
try
{
db = new DBSession();
db.BeginTransaction();
if (checktime != "")
{
ischeck = 1;
if (db_ischeck != "1")
{
feoremark += "list_order.ischeck查验标志为1";
sql = @"insert into list_updatehistory(id,UPDATETIME,TYPE
,ORDERCODE,USERID,NEWFIELD,NAME,CODE,FIELD,FIELDNAME)
values(LIST_UPDATEHISTORY_ID.nextval,sysdate,'1'
,'" + ordercode + "','" + userid + "','1','" + realname + "','" + ordercode + "','ISCHECK','报关查验'"
+ ")";
db.QuerySignle(sql);
}
sql = @"update list_order
set ischeck=1,declcheckid='{1}',declcheckname='{2}',declchecktime=to_date('{3}','yyyy-MM-dd HH24:mi:ss'),checkremark='{4}'
where code='{0}'";
sql = string.Format(sql, ordercode, checkid, checkname, checktime, checkremark);
db.QuerySignle(sql);
}
else
{
checkpic = 0;
if (db_ischeck == "1")
{
feoremark += "list_order.ischeck查验标志为0";
sql = @"update list_order
set ischeck=0,declcheckid=null,declcheckname=null,declchecktime=null,checkpic=0,checkremark=''
where code='" + ordercode + "'";
db.QuerySignle(sql);
sql = @"insert into list_updatehistory(id,UPDATETIME,TYPE
,ORDERCODE,USERID,NEWFIELD,NAME,CODE,FIELD,FIELDNAME)
values(LIST_UPDATEHISTORY_ID.nextval,sysdate,'1'
,'" + ordercode + "','" + userid + "','0','" + realname + "','" + ordercode + "','ISCHECK','报关查验'"
+ ")";
db.QuerySignle(sql);
}
sql = "delete LIST_ATTACHMENT where ordercode='" + ordercode + "' and filetype='67'";
db.QuerySignle(sql);
}
if (auditflagtime != "")
{
auditflag = 1;
if (db_auditflag != "1")
{
feoremark += "list_order.auditflag稽核标志修改为1";
sql = @"insert into list_updatehistory(id,UPDATETIME,TYPE
,ORDERCODE,USERID,NEWFIELD,NAME,CODE,FIELD,FIELDNAME)
values(LIST_UPDATEHISTORY_ID.nextval,sysdate,'1'
,'" + ordercode + "','" + userid + "','1','" + realname + "','" + ordercode + "','AUDITFLAG','稽核标志'"
+ ")";
db.QuerySignle(sql);
}
sql = @"update list_order
set auditflag=1,auditflagid='{1}',auditflagname='{2}',auditflagtime=to_date('{3}','yyyy-MM-dd HH24:mi:ss'),auditcontent='{4}'
where code='{0}'";
sql = string.Format(sql, ordercode, auditflagid, auditflagname, auditflagtime, auditcontent);
db.QuerySignle(sql);
}
else
{
if (db_auditflag == "1")
{
feoremark += "list_order.auditflag稽核标志修改为0";
sql = @"update list_order
set auditflag=0,auditflagid=null,auditflagname=null,auditflagtime=null,auditcontent=''
where code='" + ordercode + "'";
db.QuerySignle(sql);
sql = @"insert into list_updatehistory(id,UPDATETIME,TYPE
,ORDERCODE,USERID,NEWFIELD,NAME,CODE,FIELD,FIELDNAME)
values(LIST_UPDATEHISTORY_ID.nextval,sysdate,'1'
,'" + ordercode + "','" + userid + "','0','" + realname + "','" + ordercode + "','AUDITFLAG','稽核标志'"
+ ")";
db.QuerySignle(sql);
}
}
db.Commit();
foreach (string item in delfile)//提交之后删除文件
{
ftp.DeleteFile(item);
}
resultmsg = "[{\"ISCHECK\":" + ischeck + ",\"DECLCHECKTIME\":'" + checktime + "',\"CHECKPIC\":" + checkpic
+ ",\"AUDITFLAG\":" + auditflag + ",\"AUDITFLAGTIME\":'" + auditflagtime + "'}]";
}
catch (Exception ex)
{
db.Rollback();
}
finally
{
db.Dispose();
}
//============================================================================================================费用接口
if (feoremark != "")
{
//add 20180115 费用异常接口
if (dt_order.Rows[0]["entrusttype"].ToString() == "03")
{
if (Convert.ToInt32(dt_order.Rows[0]["declstatus"].ToString()) >= 160 && Convert.ToInt32(dt_order.Rows[0]["inspstatus"].ToString()) >= 120)
{
msc.FinanceExceptionOrder(ordercode, username, feoremark);
}
}
else
{
if (Convert.ToInt32(dt_order.Rows[0]["declstatus"].ToString()) >= 160)
{
msc.FinanceExceptionOrder(ordercode, username, feoremark);
}
}
}
//============================================================================================================
return(resultmsg);
}