public string CreateZDWZWHInfo(Dictionary <string, string> d)
{
string sql = "INSERT INTO WZ_ZDWZWH (ID,WL_CODE,MAXHAVING,MINHAVING,KC_CODE,WL_NAME,YEAR)VALUES('" +
d["ID"] + "','" + d["WL_CODE"] + "','" + d["MAXHAVING"] + "','" + d["MINHAVING"] + "','" + d["KC_CODE"] + "','" + d["WL_NAME"] + "','" + d["YEAR"].ToString().Substring(0, 4) + "')";
return(db.ExecutByStringResult(sql));
}
public string CreateInfo(Dictionary <string, object> d)
{
List <string> sqllist = new List <string>();
string sql = "INSERT INTO jy_fybx (S_ID,BXDH,DWBM,S_OrgCode,FYXM,XMBH,SQSJ,BXSY,BXJEDX,BXJE,YJKJE,XFKJE,FKFS,FJZS,SKDW,KHH,YHZH,SPZT,CJR,CJSJ,IS_DELETE,PROCESS_STATE)values(";
sql += GetSQLStr(Guid.NewGuid().ToString());
sql += GetSQLStr(d["BXDH"]);
sql += GetSQLStr(d["DWBM"]);
sql += GetSQLStr(d["S_OrgCode"]);
sql += GetSQLStr(d["FYXM"]);
sql += GetSQLStr(d["XMBH"]);
sql += GetSQLStr(d["SQSJ"]);
sql += GetSQLStr(d["BXSY"]);
sql += GetSQLStr(d["BXJEDX"]);
sql += GetSQLStr(d["BXJE"], 1);
sql += GetSQLStr(d["YJKJE"], 1);
sql += GetSQLStr(d["XFKJE"], 1);
sql += GetSQLStr(d["FKFS"]);
sql += GetSQLStr(d["FJZS"], 1);
sql += GetSQLStr(d["SKDW"]);
sql += GetSQLStr(d["KHH"]);
sql += GetSQLStr(d["YHZH"]);
sql += GetSQLStr(0, 1);
sql += GetSQLStr(d["CJR"]);
sql += GetSQLStr(DateTime.Now);
sql += GetSQLStr(0, 1);
sql += GetSQLStr(0, 1);
sql = sql.TrimEnd(',');
sql += ")";
return(db.ExecutByStringResult(sql));
}
public string createNoticeDetailArticle(Dictionary <string, object> d)
{
string col = "";
string val = "";
foreach (var v in d)
{
if (v.Value != null)
{
col += "," + v.Key;
val += ",'" + v.Value + "'";
}
else
{
col += "," + v.Key;
val += ",''";
}
}
if (col != "")
{
col = col.Substring(1);
}
if (val != "")
{
val = val.Substring(1);
}
string sql = "INSERT INTO ts_store_notice_detail(" + col + ",CREATE_DATE,IS_DELETE) VALUES(" + val + "," + "TO_DATE('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-mm-dd hh24:mi:ss')" + ",0)";
return(db.ExecutByStringResult(sql));
}
public string createScoreConfigArticle(Dictionary <string, object> d)
{
string col = "";
string val = "";
foreach (var v in d)
{
if (v.Value != null)
{
col += "," + v.Key;
val += ",'" + v.Value + "'";
}
else
{
col += "," + v.Key;
val += ",''";
}
}
if (col != "")
{
col = col.Substring(1);
}
if (val != "")
{
val = val.Substring(1);
}
string sql = "INSERT INTO ts_community_score_conf(" + col + ",CREATE_DATE,IS_DELETE) VALUES(" + val + ",'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',0)";
return(db.ExecutByStringResult(sql));
}
public string createServiceArticle(Dictionary <string, object> d)
{
string col = "";
string val = "";
if (d.Keys.Contains("ORG_CODE"))
{
d.Remove("ORG_CODE");
}
foreach (var v in d)
{
if (v.Value != null)
{
col += "," + v.Key;
val += ",'" + v.Value + "'";
}
else
{
col += "," + v.Key;
val += ",null";
}
}
if (col != "")
{
col = col.Substring(1);
}
if (val != "")
{
val = val.Substring(1);
}
string sql = "INSERT INTO ts_store_service(" + col + ",CREATE_DATE,IS_DELETE,INVOKE_TIMES) VALUES(" + val + ",'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',0,0)";
return(db.ExecutByStringResult(sql));
}
public string createApplyRecordArticle(Dictionary <string, object> d)
{
string col = "";
string val = "";
foreach (var v in d)
{
if (v.Value != null)
{
col += "," + v.Key;
val += ",'" + v.Value + "'";
}
else
{
col += "," + v.Key;
val += ",''";
}
}
if (col != "")
{
col = col.Substring(1);
}
if (val != "")
{
val = val.Substring(1);
}
string sql = "INSERT INTO ts_store_application_record(" + col + ",CREATE_DATE,IS_DELETE,RECORD_ISREAD) VALUES(" + val + ",'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',0,0)";
return(db.ExecutByStringResult(sql));
}
public string createMenu(Dictionary <string, object> d)
{
string col = "";
string val = "";
foreach (var v in d)
{
if (v.Value != null)
{
col += "," + v.Key;
val += ",'" + v.Value + "'";
}
else
{
col += "," + v.Key;
val += ",''";
}
}
if (col != "")
{
col = col.Substring(1);
}
if (val != "")
{
val = val.Substring(1);
}
string sql = "INSERT INTO ts_uidp_menuinfo(" + col + ") VALUES(" + val + ")";
return(db.ExecutByStringResult(sql));
}
public string DeleteInfo(Dictionary <string, object> d)
{
string sql = "UPDATE jy_cbjh set IS_DELETE=1 WHERE XMBH=" + GetSQLStr(d["XMBH"]);
sql = sql.TrimEnd(',');
return(db.ExecutByStringResult(sql));
}
public string CreateHouseInfo(Dictionary <string, object> d)
{
string sql = "INSERT INTO wy_houseinfo (FWID,FWSX,FWBH,FWMC,JZMJ,LSFGS,ZLWZ,JGLX,ZCYZ,SSQY,PMT,WATER_NUMBER,ELE_NUMBER,CJR,CJSJ,ZFK,CID,IS_DELETE,ORG_CODE)" +
" VALUES(";
sql += GetSqlStr(Guid.NewGuid());
sql += GetSqlStr(0, 1);
sql += GetSqlStr(d["FWBH"]);
sql += GetSqlStr(d["FWMC"]);
sql += GetSqlStr(d["JZMJ"], 1);
sql += GetSqlStr(d["LSFGS"]);
sql += GetSqlStr(d["ZLWZ"]);
sql += GetSqlStr(d["JGLX"]);
sql += GetSqlStr(d["ZCYZ"], 1);
sql += GetSqlStr(d["SSQY"]);
sql += GetSqlStr(d["newFilePath"]);
sql += GetSqlStr(d["WATER_NUMBER"]);
sql += GetSqlStr(d["ELE_NUMBER"]);
sql += GetSqlStr(d["userId"]);
sql += GetSqlStr(DateTime.Now);
sql += GetSqlStr(d["ZFK"], 1);
sql += GetSqlStr(d["CID"], 1);
sql += GetSqlStr(d["ORG_CODE"], 1);
sql += GetSqlStr(0, 1);
return(db.ExecutByStringResult(sql.TrimEnd(',') + ")"));
}
/// <summary>
/// 新增配置
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public string createTaxOrg(Dictionary <string, object> d)
{
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO tax_org(S_Id,S_CreateDate,S_CreateBy,S_OrgCode,S_OrgName,ImportModel,TaxOffice,ResponsibilityCenter,IsComputeTax,OrgRegion,TaxCode)VALUES(");
sql.Append(GetIsNullStr(d["S_Id"].ToString()));
sql.Append(",");
sql.Append(GetIsNullStr(d["S_CreateDate"].ToString()));
sql.Append(",");
sql.Append(GetIsNullStr(d["S_CreateBy"].ToString()));
sql.Append(",");
sql.Append(GetIsNullStr(d["S_OrgCode"].ToString()));
sql.Append(",");
sql.Append(GetIsNullStr(d["S_OrgName"].ToString()));
sql.Append(",");
sql.Append(GetIsNullStr(d["ImportModel"].ToString()));
sql.Append(",");
sql.Append(GetIsNullStr(d["TaxOffice"].ToString()));
sql.Append(",");
sql.Append(GetIsNullStr(d["ResponsibilityCenter"].ToString()));
// sql.Append(",1,");
sql.Append(",");
sql.Append(GetIsNull(d["IsComputeTax"].ToString()));
sql.Append(",");
sql.Append(GetIsNullStr(d["OrgRegion"].ToString()));
sql.Append(",");
sql.Append(GetIsNullStr(d["TaxCode"].ToString()));
sql.Append(")");
return(db.ExecutByStringResult(sql.ToString().Trim()));
}
/// <summary>
/// 上报
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public string Report(Dictionary <string, object> d)
{
string sql = "UPDATE tax_reportstatus SET ReportStatus=2,";
sql += "S_UpdateBy='" + d["S_UpdateBy"].ToString() + "',";
sql += "S_UpdateDate='" + d["S_UpdateDate"].ToString() + "'";
sql += " WHERE S_OrgCode='" + d["S_OrgCode"].ToString() + "'";
sql += " AND DATEDIFF(m, S_WorkDate, '" + d["S_WorkDate"] + "') = 0";
return(db.ExecutByStringResult(sql));
}
public string CreateTaskDetailConfig(Dictionary <string, object> d)
{
string sql = "INSERT INTO wy_task_detail_config(ID,ParentID,Code,Name)VALUES(";
sql += GetSqlStr(Guid.NewGuid());
sql += GetSqlStr(d["ParentID"]);
sql += GetSqlStr(d["Code"]);
sql += GetSqlStr(d["Name"]);
sql = sql.TrimEnd(',') + ")";
return(db.ExecutByStringResult(sql));
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public string createRoleArticle(Dictionary <string, object> d)
{
string sql = "INSERT INTO ts_uidp_groupinfo(SYS_CODE,GROUP_ID,GROUP_CODE,GROUP_NAME,GROUP_CODE_UPPER,REMARK) VALUES(";
sql += "'" + GetIsNullStr(d["sysCode"]) + "',";
sql += "'" + GetIsNullStr(d["id"]) + "',";
sql += "'" + GetIsNullStr(d["groupCode"]) + "',";
sql += "'" + GetIsNullStr(d["groupName"]) + "',";
sql += "'" + GetIsNullStr(d["parentId"]) + "',";
sql += "'" + GetIsNullStr(d["remark"]) + "')";
return(db.ExecutByStringResult(sql));
}
public string CreateRegionDirector(Dictionary <string, object> d)
{
string sql = "INSERT INTO wy_region_director(RD_ID,SSQY,FZR,MOBILE,CJR,CJSJ,IS_DELETE)VALUES(";
sql += GetSqlStr(Guid.NewGuid());
sql += GetSqlStr(d["SSQY"]);
sql += GetSqlStr(d["FZR"]);
sql += GetSqlStr(d["MOBILE"]);
sql += GetSqlStr(d["userId"]);
sql += GetSqlStr(DateTime.Now);
sql += GetSqlStr(0, 1);
sql = sql.TrimEnd(',') + ")";
return(db.ExecutByStringResult(sql));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public string createUserLoginArticle(Dictionary <string, object> d)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ts_uidp_login (LOGIN_ID,LOGIN_CODE,LOGIN_PASS,LOGIN_REMARK) values(");
sql.Append(" '");
sql.Append(d["LOGIN_ID"] == null ? "" : d["LOGIN_ID"].ToString() + "',");
sql.Append(" '");
sql.Append(d["LOGIN_CODE"] == null ? "" : d["LOGIN_CODE"].ToString() + "',");
sql.Append(" '");
sql.Append(d["LOGIN_PASS"] == null ? "" : d["LOGIN_PASS"].ToString() + "',");
sql.Append(" '");
sql.Append(d["LOGIN_REMARK"] == null ? "" : d["LOGIN_REMARK"].ToString() + "')");
return(db.ExecutByStringResult(sql.ToString()));
}
public string CreateRegionDirector(Dictionary <string, object> d)
{
string sql = "INSERT INTO wy_region_director(RD_ID,SSQY,FZR,MOBILE,CJR,CJSJ,IS_DELETE,WX_OPEN_ID)VALUES(";
sql += GetSqlStr(Guid.NewGuid());
sql += GetSqlStr(d["SSQY"]);
sql += GetSqlStr(d["FZR"]);
sql += GetSqlStr(d["MOBILE"]);
sql += GetSqlStr(d["userId"]);
sql += GetSqlStr(DateTime.Now.ToString("yyyyMMdd"));
sql += GetSqlStr(0, 1);
sql += "(select * from(SELECT OPENID FROM v_allusers WHERE PHONE='" + d["MOBILE"] + "')t LIMIT 1),";
sql = sql.TrimEnd(',') + ")";
return(db.ExecutByStringResult(sql));
}
public string InsertLog(string mes, string remark)
{
string sql = "INSERT INTO ts_uidp_loginfo (ACCESS_TIME,LOG_CONTENT,REMARK)values('" + DateTime.Now.ToString("yyyyMMdd") + "','" + mes +
" ','" + remark + "')";
return(db.ExecutByStringResult(sql));
}
public string CreateCRKInfo(Dictionary <string, object> d)
{
string sql = " INSERT INTO WZ_CRKL (ID,DK_CODE,ERDATE,RKL,CKL,CREATE_BY,CREATE_DATE) VALUES(";
sql += GetSqlStr(Guid.NewGuid());
sql += GetSqlStr(d["DK_CODE"]);
//sql += "TO_DATE('" + d["ERDATE"] + "','yyyy/MM'),";
sql += GetSqlStr(d["ERDATE"]);
sql += GetSqlStr(d["RKL"], 1);
sql += GetSqlStr(d["CKL"], 1);
sql += GetSqlStr(d["userid"]);
sql += "TO_DATE('" + DateTime.Now + "','yyyy/MM/dd HH24:Mi:ss')";
sql = sql.TrimEnd(',');
sql += ")";
return(db.ExecutByStringResult(sql));
}
public string editNode(Dictionary <string, object> d)
{
string sql = "UPDATE WZ_WLZ SET DLCODE='" + d["DLCODE"] + "',";
sql += " DLNAME='" + d["DLNAME"] + "',";
sql += " ZLCODE='" + d["ZLCODE"] + "',";
sql += " ZLNAME='" + d["ZLNAME"] + "',";
sql += " XLCODE='" + d["XLCODE"] + "',";
sql += " XLNAME='" + d["XLNAME"] + "',";
sql += " PMCODE='" + d["PMCODE"] + "',";
sql += " PMNAME='" + d["PMNAME"] + "',";
sql += " XHGGGF='" + d["XHGGGF"] + "',";
sql += " JBJLDW='" + d["JBJLDW"] + "'";
sql += " WHERE ID='" + d["ID"] + "'";
return(db.ExecutByStringResult(sql));
}
public string UpdateInfo(Dictionary <string, object> d)
{
string sql = " UPDATE jy_cbjh_adjust SET XMBH=" + GetSQLStr(d["XMBH"]);
sql += "XMMC=" + GetSQLStr(d["XMMC"]);
sql += "TZQJE=" + GetSQLStr(d["TZQJE"]);
sql += "TZJE=" + GetSQLStr(d["TZJE"]);
sql += "TZSM=" + GetSQLStr(d["TZSM"]);
sql += "TZSJ=" + GetSQLStr(d["TZSJ"]);
//sql += "BXSY=" + GetSQLStr(d["BXSY"]);
//sql += "BXJEDX=" + GetSQLStr(d["BXJEDX"]);
//sql += "BXJE=" + GetSQLStr(d["BXJE"], 1);
//sql += "YJKJE=" + GetSQLStr(d["YJKJE"],1);
//sql += "XFKJE=" + GetSQLStr(d["XFKJE"], 1);
//sql += "FKFS=" + GetSQLStr(d["FKFS"]);
//sql += "FJZS=" + GetSQLStr(d["FJZS"], 1);
//sql += "SKDW=" + GetSQLStr(d["SKDW"]);
//sql += "KHH=" + GetSQLStr(d["KHH"]);
//sql += "YHZH=" + GetSQLStr(d["YHZH"]);
//sql += "BJR=" + GetSQLStr(d["BJR"]);
//sql += "BJSJ=" + GetSQLStr(DateTime.Now);
sql = sql.TrimEnd(',');
sql += " WHERE S_ID=" + GetSQLStr(d["S_ID"]);
sql = sql.TrimEnd(',');
return(db.ExecutByStringResult(sql));
}
public string createSyncConf(Dictionary <string, object> d)
{
string sql = "INSERT INTO ts_uidp_synchro_config(SYNC_ID,SERVER_IP,SERVER_PORT,SERVER_URL,AUTHENTICATION_URL,USER_CODE,USER_PASS,SYNC_TYPE,SYNC_FLAG,IS_DELETE,REMARK) VALUES(";
sql += "'" + GetIsNullStr(d["SYNC_ID"]) + "',";
sql += "'" + GetIsNullStr(d["SERVER_IP"]) + "',";
sql += "'" + GetIsNullStr(d["SERVER_PORT"]) + "',";
sql += "'" + GetIsNullStr(d["SERVER_URL"]) + "',";
sql += "'" + GetIsNullStr(d["AUTHENTICATION_URL"]) + "',";
sql += "'" + GetIsNullStr(d["USER_CODE"]) + "',";
sql += "'" + GetIsNullStr(d["USER_PASS"]) + "',";
sql += "'" + GetIsNullStr(d["SYNC_TYPE"]) + "',";
sql += GetIsNullStr(d["SYNC_FLAG"]) + ",0,";
sql += "'" + GetIsNullStr(d["REMARK"]) + "')";
return(db.ExecutByStringResult(sql));
}
public string createNoticeArticle(Dictionary <string, object> d)
{
string sql = "INSERT INTO ts_store_notice(NOTICE_ID,NOTICE_CODE,NOTICE_TITLE,NOTICE_CONTENT,NOTICE_DATETIME,NOTICE_ORGID,NOTICE_ORGNAME,CREATER,CREATE_DATE,IS_DELETE) VALUES(";
sql += "'" + GetIsNullStr(d["NOTICE_ID"]) + "',";
sql += "'" + GetIsNullStr(d["NOTICE_CODE"]) + "',";
sql += "'" + GetIsNullStr(d["NOTICE_TITLE"]) + "',";
sql += "'" + GetIsNullStr(d["NOTICE_CONTENT"]) + "',";
sql += "'" + GetIsNullStr(d["NOTICE_DATETIME"]) + "',";
sql += "'" + GetIsNullStr(d["NOTICE_ORGID"]) + "',";
sql += "'" + GetIsNullStr(d["NOTICE_ORGNAME"]) + "',";
sql += "'" + GetIsNullStr(d["CREATER"]) + "',";
sql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',0 )";
//sql += "'" + GetIsNullStr(d["REMARK"]) + "')";
return(db.ExecutByStringResult(sql));
}
public string createImportData(List <importService> list, string orgCode, string orgName, DateTime dateMonth, string userId)
{
int num = 10; //分页条数
int i = 0; //循环判断数
StringBuilder sb = new StringBuilder();
string sqlHeader = " INSERT INTO tax_serviceremuneration (ID,Create_Date,Create_By,WorkDate,WorkerCode,WorkerName,IDtype,IDNumber,IncomeItem,Tax,Income," +
"CommercialHealthinsurance,EndowmentInsurance,Donation,other,TaxSavings,Remark,ImportOrgCode) VALUES";
foreach (importService item in list)
{
if (i % num == 0)
{
sb.Append(sqlHeader);
}
sb.Append("('" + Guid.NewGuid() + "',");
sb.Append("'" + DateTime.Now.ToString("yyyyMMdd") + "',");
sb.Append("'" + userId + "',");
sb.Append("'" + dateMonth.ToString("yyyyMMdd") + "',");
sb.Append(isstr(item.WorkerCode));
sb.Append(isstr(item.WorkerName));
sb.Append(isstr(item.IDtype));
sb.Append(isstr(item.IDNumber));
sb.Append(isstr(item.IncomeItem));
sb.Append(isnum(item.Tax));
sb.Append(isnum(Convert.ToDecimal(item.Income)));
sb.Append(isnum(item.CommercialHealthinsurance));
sb.Append(isnum(item.EndowmentInsurance));
sb.Append(isnum(item.Donation));
sb.Append(isnum(item.other));
sb.Append(isnum(item.TaxSavings));
sb.Append(isstr(item.Remark));
sb.Append("'" + orgCode + "')");
i++;
if (i % num == 0 || item.Equals(list[list.Count - 1]))
{
sb.Append("");
}
else
{
sb.Append(",");
}
}
string sql = sb.ToString();
return(dB.ExecutByStringResult(sql));
}
/// <summary>
/// 修改配置信息
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public string editConfig(Dictionary <string, object> d)
{
string sql = "UPDATE tax_subtractconfig SET S_UpdateBy='" + d["username"] + "',";
sql += "S_UpdateDate='" + d["S_UpdateDate"] + "',";
sql += "TaxLevel=" + d["TaxLevel"] + ",";
if (d["TaxStart"] == null || d["TaxStart"].ToString() == "")
{
sql += "TaxStart = NULL,";
}
else
{
sql += "TaxStart=" + d["TaxStart"] + ",";
}
if (d["TaxEnd"] == null || d["TaxEnd"].ToString() == "")
{
sql += "TaxEnd = NULL,";
}
else
{
sql += "TaxEnd=" + d["TaxEnd"] + ",";
}
sql += "TaxRate='" + d["TaxRate"] + "',";
sql += "TaxDeduction='" + d["TaxDeduction"] + "'";
sql += " WHERE S_Id='" + d["S_Id"] + "'";
return(db.ExecutByStringResult(sql));
}
public string editNode(Dictionary <string, object> d)
{
string sql = @"UPDATE TS_DICTIONARY SET ""PARENTCODE""='" + d["ParentCode"] + "',";
sql += @"""CODE""='" + d["Code"] + "',";
sql += @"""NAME""='" + d["Name"] + "',";
sql += @"""S_UPDATEBY""='" + d["S_UpdateBy"] + "',";
sql += @"""S_UPDATEDATE""= to_date('" + d["S_UpdateDate"] + "','yyyy-MM-dd HH24:mi:ss')";
if (d["EnglishCode"] != null && d["EnglishCode"].ToString() != "")
{
sql += @",""ENGLISHCODE""='" + d["EnglishCode"] + "'";
}
if (d["SortNo"] != null && d["SortNo"].ToString() != "")
{
sql += @",""SORTNO""=" + d["SortNo"] + "";
}
sql += @" WHERE ""S_ID""='" + d["S_Id"] + "'";
return(db.ExecutByStringResult(sql));
}
public string editNode(Dictionary <string, object> d)
{
string sql = "UPDATE tax_dictionary SET ParentCode='" + d["ParentCode"] + "',";
sql += "Code='" + d["Code"] + "',";
sql += "Name='" + d["Name"] + "',";
sql += "S_UpdateBy='" + d["S_UpdateBy"] + "',";
sql += "S_UpdateDate='" + d["S_UpdateDate"] + "'";
if (d["EnglishCode"] != null && d["EnglishCode"].ToString() != "")
{
sql += ",EnglishCode='" + d["EnglishCode"] + "'";
}
if (d["SortNo"] != null && d["SortNo"].ToString() != "")
{
sql += ",SortNo=" + d["SortNo"] + "";
}
sql += " WHERE S_Id='" + d["S_Id"] + "'";
return(db.ExecutByStringResult(sql));
}
/// <summary>
/// 结转功能
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public string MonthKonts(Dictionary <string, object> d)
{
string sql = "UPDATE tax_date SET UpdateDate='" + d["UpdateDate"].ToString() + "',";
sql += "UpdateBy='" + d["UpdateBy"].ToString() + "',";
sql += "SysOperateDate=DATEADD(mm,1,'" + d["SysOperateDate"].ToString() + "')";
//sql += " insert into View_GouXuanHistry SELECT '" + d["SysOperateDate"].ToString() + "',* from [dbo].[View_GouXuan]";
//sql += "insert into View_GouXuanBLHistry SELECT '" + d["SysOperateDate"].ToString() + "',* from [dbo].[View_GouXuanBL]";
//sql += "insert into View_KouJianXiangHistry SELECT'" + d["SysOperateDate"].ToString() + "',* from [dbo].[View_KouJianXiang]";
return(DB.ExecutByStringResult(sql));
}
public string createStoreLogArticle(Dictionary <string, object> d)
{
string sql = "INSERT INTO ts_store_log(STORE_LOG_ID,ACCESS_TIME,IP_ADDR,INVOKE_TYPE,RESOURCE_ID,LOG_CONTENT,RESOURCE_NAME,REMARK) VALUES(";
sql += "'" + GetIsNullStr(d["STORE_LOG_ID"]) + "',";
sql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sql += "'" + GetIsNullStr(d["IP_ADDR"]) + "',";
sql += GetIsNullStr(d["INVOKE_TYPE"]) + ",";
sql += "'" + GetIsNullStr(d["RESOURCE_ID"]) + "',";
sql += "'" + GetIsNullStr(d["LOG_CONTENT"]) + "',";
sql += "'" + GetIsNullStr(d["RESOURCE_NAME"]) + "',";
sql += "'" + GetIsNullStr(d["REMARK"]) + "')";
return(db.ExecutByStringResult(sql));
}
public string CreateCKInfo(Dictionary <string, object> d)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO WZ_OutOfStock(CK_ID, CK_ClassCode, CK_Code, CK_Describe, CK_Measurement,CK_Time, CK_Company, CK_Custodian, CK_Location, CK_LocationNumber, CK_Remark)VALUES(");
sb.Append(strSQL(d["CK_ID"]));
sb.Append(strSQL(d["CK_CLASSCODE"]));
sb.Append(strSQL(d["CK_CODE"]));
sb.Append(strSQL(d["CK_DESCRIBE"]));
sb.Append(strSQL(d["CK_MEASUREMENT"]));
//sb.Append(d["CK_Quantity"] + ",");
sb.Append("TO_DATE('" + d["CK_TIME"] + "','yyyy-mm-dd hh24:mi:ss'),");
sb.Append(strSQL(d["CK_COMPANY"]));
sb.Append(strSQL(d["CK_CUSTODIAN"]));
sb.Append(strSQL(d["CK_LOCATION"]));
sb.Append(strSQL(d["CK_LOCATIONNUMBER"]));
sb.Append(strSQL(d["CK_REMARK"]));
string sql = sb.ToString();
sql = sql.TrimEnd(',');
sql += ")";
return(db.ExecutByStringResult(sql));
}
public string createConfigArticle(Dictionary <string, object> d)
{
string col = "";
string val = "";
foreach (var v in d)
{
col += "," + v.Key;
val += ",'" + v.Value + "'";
}
if (col != "")
{
col = col.Substring(1);
}
if (val != "")
{
val = val.Substring(1);
}
string sql = "INSERT INTO ts_uidp_config(" + col + ") VALUES(" + val + ")";
return(db.ExecutByStringResult(sql));
}
