//导入
public int import_base_ciqcode(JObject json, string ciq, string ciqname, string ENABLED, string remark, string yearid)
{
//停用人
string stopman = "";
FormsIdentity identity = HttpContext.Current.User.Identity as FormsIdentity;
string userName = identity.Name;
JObject json_user = Extension.Get_UserInfo(userName);
if (ENABLED == "1")
{
stopman = "";
}
else
{
stopman = json_user.GetValue("ID").ToString();
}
string sql = @"insert into base_ciqcode(
id,
ciq,ciqname,enabled,createman,
stopman,createdate,
startdate,enddate,
yearid,remark) values(
base_ciq_id.nextval,
'{0}','{1}','{2}','{3}',
'{4}',sysdate,
to_date('{5}','yyyy/mm/dd hh24:mi:ss'),to_date('{6}','yyyy/mm/dd hh24:mi:ss'),
'{7}','{8}')";
sql = String.Format(sql,
ciq, ciqname, ENABLED, json_user.GetValue("ID"),
stopman,
json.Value <string>("STARTDATE"), json.Value <string>("ENDDATE"),
yearid, remark
);
int i = DBMgrBase.ExecuteNonQuery(sql);
return(i);
}
public void insert_rela_container(string CONTAINERSIZE, string CONTAINERTYPE, string FORMATCODE, string FORMATNAME, string CONTAINERHS, string ENABLED, string REMARK, string stopman, string STARTDATE, string ENDDATE)
{
FormsIdentity identity = HttpContext.Current.User.Identity as FormsIdentity;
string userName = identity.Name;
JObject json_user = Extension.Get_UserInfo(userName);
string sqlStr = @"insert into rela_container (id,containersize,containertype,formatcode,formatname,containerhs,enabled,remark,createman,stopman,startdate,enddate,createdate)
values (rela_container_id.nextval,'{0}','{1}','{2}','{3}','{4}','{5}','{6}',
'{7}','{8}',to_date('{9}','yyyy-mm-dd hh24:mi:ss'),to_date('{10}','yyyy-mm-dd hh24:mi:ss'),sysdate)";
sqlStr = string.Format(sqlStr, CONTAINERSIZE,
CONTAINERTYPE,
FORMATCODE,
FORMATNAME,
CONTAINERHS,
ENABLED,
REMARK,
json_user.GetValue("ID"),
stopman,
STARTDATE,
ENDDATE);
int i = DBMgrBase.ExecuteNonQuery(sqlStr);
}
//增添修改记录
public int insert_base_alterrecord(JObject json, string content)
{
//Tabid
string Tabid = json.Value <string>("ID");
//TabKind
int TabKind = (int)Base_YearKindEnum.Base_Year;
//AlterMan(id)
FormsIdentity identity = HttpContext.Current.User.Identity as FormsIdentity;
string userName = identity.Name;
JObject json_user = Extension.Get_UserInfo(userName);
string AlterMan = json_user.GetValue("ID").ToString();
//AlterDate数据库中的时间
//Reason
string Reason = json.Value <string>("REASON");
//content
string sql =
@"insert into base_alterrecord(id,tabid,tabkind,alterman,reason,contentes,alterdate) values(base_alterrecord_id.nextval,'{0}','{1}','{2}','{3}','{4}',
sysdate)";
sql = string.Format(sql, Tabid, TabKind, AlterMan, Reason, content);
return(DBMgrBase.ExecuteNonQuery(sql));
}
//新增HS编码
public int insert_base_insphs(JObject json, string yearid)
{
bcm.getCommonInformation(out stopman, out createman, out startdate, out enddate, json);
string sql = @"insert into base_insphs(id,
hscode,hsname,weight,customregulatory,
yearid,num,createdate,startdate,
enddate,createman,stopman,enabled,
remark,inspectionregulatory,legalunit) values(base_insphs_id.nextval,
'{0}','{1}','{2}','{3}',
'{4}','{5}',sysdate,to_date('{6}','yyyy/mm/dd hh24:mi:ss'),
to_date('{7}','yyyy/mm/dd hh24:mi:ss'),'{8}','{9}','{10}',
'{11}','{12}','{13}')";
sql = String.Format(sql,
json.Value <string>("HSCODE"), json.Value <string>("HSNAME"), json.Value <string>("WEIGHT"), json.Value <string>("CUSTOMREGULATORY"),
yearid, json.Value <string>("NUMNAME"), startdate,
enddate, createman, stopman, json.Value <string>("ENABLED"),
json.Value <string>("REMARK"), json.Value <string>("INSPECTIONREGULATORY"), json.Value <string>("LEGALUNITNAME"));
int i = DBMgrBase.ExecuteNonQuery(sql);
return(i);
}
//更新HS编码
public int update_base_insphs(JObject json, string yearid)
{
bcm.getCommonInformation(out stopman, out createman, out startdate, out enddate, json);
string sql = @"update base_commodityhs set name='{0}',hscode='{1}',extracode='{2}',legalunit='{3}',secondunit='{4}',customregulatory='{5}',inspectionregulatory='{6}',
classcode='{7}',agreetaxfile='{8}',topprice='{9}',lowprice='{10}',generalrate='{11}',favorablerate='{12}',vatrate='{13}',startdate=to_date('{14}','yyyy/mm/dd hh24:mi:ss'),
enddate=to_date('{15}','yyyy/mm/dd hh24:mi:ss'),exportrebatrate='{16}',temprate='{17}',consumerate='{18}',exportrate='{19}',specialmark='{20}',elements='{21}',enabled = '{22}' where id='{23}'";
sql = String.Format(sql,
json.Value <string>("NAME"), json.Value <string>("HSCODE"), json.Value <string>("EXTRACODE"), json.Value <string>("LEGALUNIT"), json.Value <string>("SECONDUNIT"),
json.Value <string>("CUSTOMREGULATORY"), json.Value <string>("INSPECTIONREGULATORY"), "", "", json.Value <string>("TOPPRICE"), json.Value <string>("LOWPRICE"), json.Value <string>("GENERALRATE"), json.Value <string>("FAVORABLERATE"), json.Value <string>("VATRATE"),
startdate, enddate, json.Value <string>("EXPORTREBATRATE"), json.Value <string>("TEMPRATE"), json.Value <string>("CONSUMERATE"), json.Value <string>("EXPORTRATE"), json.Value <string>("SPECIALMARK"), json.Value <string>("ELEMENTS"), json.Value <string>("ENABLED"), json.Value <string>("ID")
);
string unit1 = "", unit2 = "";
if (judgeNumOrWeight(json.Value <string>("LEGALUNIT")))//是重量
{
unit1 = json.Value <string>("LEGALUNIT");
unit2 = json.Value <string>("SECONDUNIT");
}
else//是数量
{
unit1 = json.Value <string>("LEGALUNIT");
unit2 = json.Value <string>("SECONDUNIT");
}
string sql_sub = @"update base_insphs set hsname='{0}',weight='{1}',num='{2}',customregulatory='{3}',inspectionregulatory='{4}',legalunit='{5}' ,remark='{6}'
where hscode='{7}' and extracode='{8}' and enabled=1 and yearid = '{9}'";
sql_sub = String.Format(sql_sub, json.Value <string>("NAME"), unit1, unit2, json.Value <string>("CUSTOMREGULATORY"), json.Value <string>("INSPECTIONREGULATORY"), json.Value <string>("LEGALUNIT"), json.Value <string>("REMARK"),
json.Value <string>("HSCODE"), json.Value <string>("EXTRACODE"), yearid);
List <string> sqls = new List <string>();
sqls.Add(sql);
sqls.Add(sql_sub);
int i = DBMgrBase.ExecuteNonQuery(sqls);
return(i);
}
//导入sql语句
public int export_insert_base_company(string incode, string CODE, string INSPCODE, string NAME, string ENGLSHNAME, string GOODSLOCAL, string RECEIVERTYPE, string ENABLED, string REMARK, string STARTDATE, string ENDDATE, string DeclNature, string InspNature, string stopman, string SOCIALCREDITNO)
{
FormsIdentity identity = HttpContext.Current.User.Identity as FormsIdentity;
string userName = identity.Name;
JObject json_user = Extension.Get_UserInfo(userName);
string sql = @"insert into base_company(id,
code,name,remark,enabled,createman,stopman,createdate,
startdate,enddate,englishname,declnature,incode,
inspcode,inspnature,goodslocal,receivertype,SOCIALCREDITNO
) values(base_company_id.nextval,
'{0}','{1}','{2}','{3}','{4}','{5}',sysdate,
to_date('{6}','yyyy/mm/dd hh24:mi:ss'),to_date('{7}','yyyy/mm/dd hh24:mi:ss'),'{8}','{9}','{10}'
,'{11}','{12}','{13}','{14}','{15}'
)";
sql = String.Format(sql,
CODE, NAME, REMARK, ENABLED, json_user.GetValue("ID"), stopman,
STARTDATE, ENDDATE, ENGLSHNAME, DeclNature, incode
, INSPCODE, InspNature, GOODSLOCAL, RECEIVERTYPE, SOCIALCREDITNO);
int i = DBMgrBase.ExecuteNonQuery(sql);
return(i);
}