public string saveCgmgcListXmlDataToDb(string uuid, string xmlData)
{
string message = string.Empty;
DataTable dt = xmlHelper.ConvertXMLToDataTableWithBase64Decoding(xmlData, out message);
if (dt == null || dt.Rows.Count < 1)
{
return(message);
}
else
{
//插入数据前删除列表记录
dataService.Delete_ApTable(AP_AJSBB_CGMGCQD, uuid);
DataTable existDt = dataService.Get_ApTable(AP_AJSBB_CGMGCQD);
foreach (DataRow item in dt.Rows)
{
DataRow toSaveRow = existDt.NewRow();
DataTableHelp.DataRow2DataRow(item, toSaveRow);
existDt.Rows.Add(toSaveRow);
}
if (existDt.Rows.Count > 0)
{
//TODO, 循环保存单条数据，有待重构
if (!dataService.Save_Ap_ajsbb_cgmgcqd(existDt))
{
//保存失败的错误处理
Public.WriteLog("Save_Ap_ajsbb:fail");
}
}
return("success");
}
}
public ProcessResultData saveProjectDocInfoAdd(DataTable dt)
{
ProcessResultData result = new ProcessResultData();
DataTable dt_InfoAdd = DAL.GetProjectDocAdd();
DataRow row;
List <string> notCopyFields = new List <string>()
{
"PKID", "CreateDate", "UpdateDate"
};
foreach (DataRow item in dt.Rows)
{
row = dt_InfoAdd.NewRow();
DataTableHelp.DataRow2DataRow(item, row, notCopyFields);
row["PKID"] = Guid.NewGuid();
row["CreateDate"] = DateTime.Now;
row["UpdateDate"] = DateTime.Now;
dt_InfoAdd.Rows.Add(row);
}
bool flag = DAL.SaveProjectDocAdd(dt_InfoAdd);
if (flag)
{
result.code = ProcessResult.数据保存成功;
}
else
{
result.code = ProcessResult.保存失败和失败原因;
}
return(result);
}
public string saveZJDwgcListXmlDataToDb(string uuid, string xmlData)
{
string message = string.Empty;
DataTable dt = xmlHelper.ConvertXMLToDataTableWithBase64Decoding(xmlData, out message);
if (dt == null || dt.Rows.Count < 1)
{
return(message);
}
else
{
dataService.Delete_ApTable(AP_ZJSBB_DWGC, uuid);
DataTable existDt = dataService.Get_ApTable(AP_ZJSBB_DWGC);
foreach (DataRow item in dt.Rows)
{
DataRow toSaveRow = existDt.NewRow();
DataTableHelp.DataRow2DataRow(item, toSaveRow);
existDt.Rows.Add(toSaveRow);
}
if (existDt.Rows.Count > 0)
{
if (!dataService.Save_Ap_sbb(existDt, AP_ZJSBB_DWGC))
{
//保存失败的错误处理
Public.WriteLog("Save_Ap_ajsbb:fail");
}
}
return("success");
}
}
/// <summary>
/// 接收单体项目档案相关信息
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public ProcessResultData saveSubProjectDocInfo(DataRow item)
{
ProcessResultData result = new ProcessResultData();
DataTable dt_SubPrjDoc = DAL.GetSubProjectDocInfo(item["PrjNum"].ToString2(), item["Fxbm"].ToString2(), item["Xmmc"].ToString2());
DataRow rowInDb;
if (dt_SubPrjDoc != null && dt_SubPrjDoc.Rows.Count > 0)
{
rowInDb = dt_SubPrjDoc.Rows[0];
DataTableHelp.DataRow2DataRow(item, rowInDb, new List <string>()
{
"PKID", "PrjNum", "Fxbm", "Xmmc"
});
rowInDb["UpdateDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
rowInDb = dt_SubPrjDoc.NewRow();
DataTableHelp.DataRow2DataRow(item, rowInDb);
rowInDb["PKID"] = Guid.NewGuid();
rowInDb["CreateDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
rowInDb["UpdateDate"] = rowInDb["CreateDate"];
dt_SubPrjDoc.Rows.Add(rowInDb);
}
if (dt_SubPrjDoc.Rows.Count > 0)
{
bool successFlag = DAL.SaveSubProjectDocInfo(dt_SubPrjDoc);
if (successFlag)
{
result.code = ProcessResult.数据保存成功;
}
else
{
result.code = ProcessResult.保存失败和失败原因;
}
}
/**
* int effects = DAL.SaveSubProjectDoc(row);
*
* if (effects > 0)
* {
* result.code = ProcessResult.数据保存成功;
* }
* else
* {
* result.code = ProcessResult.保存失败和失败原因;
* }*/
return(result);
}
public string saveHtListXmlDataToDb(string uuid, string xmlData)
{
try
{
string message = string.Empty;
DataTable dt = xmlHelper.ConvertXMLToDataTableWithBase64Decoding(xmlData, out message);
if (dt == null || dt.Rows.Count < 1)
{
return(message);
}
else
{
dataService.Delete_ApTable(AP_AJSBB_HT, uuid);
DataTable existDt = dataService.Get_ApTable(AP_AJSBB_HT);
foreach (DataRow item in dt.Rows)
{
DataRow toSaveRow = existDt.NewRow();
DataTableHelp.DataRow2DataRow(item, toSaveRow);
if (!string.IsNullOrEmpty(toSaveRow["contractMoney"].ToString()) &&
!string.IsNullOrEmpty(toSaveRow["recordNum"].ToString()))
{
existDt.Rows.Add(toSaveRow);
}
//由于文档跟实际获取的xml不一致，特殊处理字段
//toSaveRow["CorpCode"] = item["contractorCorpCode"];
//toSaveRow["CorpName"] = item["contractorCorpName"];
//toSaveRow["RecordNum"] = item["recordNum"];
//toSaveRow["xmfzrsfzh"] = item["iDCard"];
//toSaveRow["xmfzr"] = item["prjHead"];
}
if (existDt.Rows.Count > 0)
{
if (!dataService.Save_Ap_ajsbb_ht(existDt))
{
//保存失败的错误处理
Public.WriteLog("Save_Ap_ajsbb:fail");
}
}
return("success");
}
}
catch (Exception ex)
{
Public.WriteLog("执行saveHtListXmlDataToDb方法出现异常:" + ex.Message);
return("fail");
}
}
public string saveZJHtListXmlDataToDb(string uuid, string xmlData)
{
string message = string.Empty;
DataTable dt = xmlHelper.ConvertXMLToDataTableWithBase64Decoding(xmlData, out message);
if (dt == null || dt.Rows.Count < 1)
{
return(message);
}
else
{
dataService.Delete_ApTable(AP_ZJSBB_HT, uuid);
DataTable existDt = dataService.Get_ApTable(AP_ZJSBB_HT);
foreach (DataRow item in dt.Rows)
{
DataRow toSaveRow = existDt.NewRow();
DataTableHelp.DataRow2DataRow(item, toSaveRow);
existDt.Rows.Add(toSaveRow);
//由于文档跟实际获取的xml不一致，特殊处理字段
//toSaveRow["CorpCode"] = item["contractorCorpCode"];
//toSaveRow["CorpName"] = item["contractorCorpName"];
//toSaveRow["RecordNum"] = item["sgzcbhtbam"];
//toSaveRow["xmfzrsfzh"] = item["iDCard"];
//toSaveRow["xmfzr"] = item["prjHead"];
//Public.WriteLog("====" + toSaveRow["uuid"] + toSaveRow["RecordNum"]);
}
if (existDt.Rows.Count > 0)
{
if (!dataService.Save_Ap_sbb(existDt, AP_ZJSBB_HT))
{
//保存失败的错误处理
Public.WriteLog("Save_Ap_ajsbb:fail");
}
}
return("success");
}
}
protected override void DoSetParam(string tag, params object[] param)
{
base.DoSetParam(tag, param);
if (tag == "dalassembly")
{
BLL.BllDataBase bll = new BLL.BllDataBase();
List <FuncAssemblyInfo> result = bll.GetAssemblyinfos();
if (result != null)
{
DataTable dt = this.dataGridView1.DataSource as DataTable;
DataTable data = LibSysUtils.ToDataTable(result);
DataTableHelp dthelp = new DataTableHelp(data, dt);
dthelp.CopyStable();
//DataRow row = null;
//foreach (var item in result)
//{
// row = dt.NewRow();
// row["FuncID"] = item.FuncID;
// row [""]
//}
}
}
}
public string saveZJMainListXmlDataToDb(string user, string xmlData, DateTime pullDate)
{
string message = string.Empty;
DataTable mainDt = xmlHelper.ConvertXMLToDataTableWithBase64Decoding(xmlData, out message);
if (mainDt == null || mainDt.Rows.Count < 1)
{
return(message);
}
else
{
//一个质监申报表编号，对应一条质监申报表
DataRow item = mainDt.Rows[0];
DataTable dt_Ap_zjsbb = dataService.Get_Ap_zjsbb(item["uuid"].ToString2());
DataRow toSaveRow;
if (dt_Ap_zjsbb != null && dt_Ap_zjsbb.Rows.Count > 0)
{
toSaveRow = dt_Ap_zjsbb.Rows[0];
//Public.WriteLog("====" + toSaveRow["uuid"] + "|" + toSaveRow["Status"]);
int cmpFlag = DateTime.Compare(item["updateDate"].ToDateTime(), toSaveRow["updateDate"].ToDateTime());
//Public.WriteLog("====" + toSaveRow["Status"] + "|cmpFlag:" + cmpFlag);
if ((!string.IsNullOrEmpty(toSaveRow["Status"].ToString()) && toSaveRow["Status"].ToInt32() != 0) && cmpFlag > 0)
{
//重新提交,审批状态清零
toSaveRow["Status"] = 0;
}
DataTableHelp.DataRow2DataRow(item, toSaveRow, new List <string>()
{
"uuid"
});
}
else
{
toSaveRow = dt_Ap_zjsbb.NewRow();
DataTableHelp.DataRow2DataRow(item, toSaveRow);
toSaveRow["Status"] = 0;
dt_Ap_zjsbb.Rows.Add(toSaveRow);
}
//只有申报表有UpdateTime跟UpdateUser
toSaveRow["UpdateTime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
toSaveRow["UpdateUser"] = user;
toSaveRow["FetchDate"] = pullDate;
//Public.WriteLog("====" + toSaveRow["uuid"] + toSaveRow["PrjNum"]);
if (dt_Ap_zjsbb.Rows.Count > 0)
{
if (!dataService.Save_Ap_sbb(dt_Ap_zjsbb, AP_ZJSBB))
{
//保存失败的错误处理
Public.WriteLog("Save_Ap_ajsbb:fail");
}
}
return("success");
}
}
/// <summary>
/// 推送质监通知书
/// </summary>
/// <param name="user"></param>
/// <param name="deptcode"></param>
/// <param name="sbPassword"></param>
/// <param name="dt_Data"></param>
/// <returns></returns>
public ProcessResultData pushZJTZS(string user, string deptcode, string sbPassword, DataTable dt_Data, DataTable jdryDtData)
{
ProcessResultData result = new ProcessResultData();
StringBuilder prjInnerNumSb = new StringBuilder();
string msg = String.Empty;
string[] fields = new string[] { "uuid", "tzrq", "tzdw" };
DataRow item = dt_Data.Rows[0];
List <string> novalidates = new List <string>();
novalidates.Add(String.Empty);
novalidates.Add(" ");
novalidates.Add("无");
novalidates.Add("无数据");
novalidates.Add("/");
if (BLLCommon.DataFieldIsNullOrEmpty(novalidates, fields, item, out msg))
{
result.code = ProcessResult.保存失败和失败原因;
result.message = msg + "不能为空！";
return(result);
}
DataTable dt_ajtzs = DAL.GetApTable("Ap_zjtzs");
DataRow row = dt_ajtzs.NewRow();
DataTableHelp.DataRow2DataRow(item, row);
row["id"] = Guid.NewGuid();
row["UpdateTime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
dt_ajtzs.Rows.Add(row);
row["deptcode"] = deptcode;
row["sbPassword"] = sbPassword;
row["UpdateUser"] = user;
//保存监督人员列表
DataTable dt_tzs_jdry = null;
if (jdryDtData != null && jdryDtData.Rows.Count > 0)
{
dt_tzs_jdry = DAL.GetApTable("Ap_zjtzs_jdry");
foreach (DataRow jdryItem in jdryDtData.Rows)
{
DataRow jdryRow = dt_tzs_jdry.NewRow();
DataTableHelp.DataRow2DataRow(jdryItem, jdryRow);
jdryRow["id"] = Guid.NewGuid();
jdryRow["uuid"] = row["uuid"];
dt_tzs_jdry.Rows.Add(jdryRow);
}
}
if (dt_ajtzs.Rows.Count > 0)
{
if (DAL.SaveApTable("Ap_zjtzs", dt_ajtzs) && DAL.SaveApTable("Ap_zjtzs_jdry", dt_tzs_jdry))
{
try
{
StringBuilder str = new StringBuilder();
string xmlData = string.Empty;
string jdryXmlData = string.Empty;
DataRow dataRow = dt_ajtzs.Rows[0];
//向省一站式申报平台推送质监通知书
List <string> excludeColumns = new List <string>();
excludeColumns.Add("id");
excludeColumns.Add("deptcode");
excludeColumns.Add("sbPassword");
excludeColumns.Add("UpdateTime");
excludeColumns.Add("UpdateUser");
xmlData = xmlHelper.ConvertDataRowToXML(dataRow, excludeColumns);
str.Append("<?xml version=\"1.0\" encoding=\"gb2312\"?>");
str.AppendFormat("<{0}>", "data");
str.AppendFormat("<{0}>", "result");
str.Append(xmlData);
foreach (DataRow jdryItem in jdryDtData.Rows)
{
str.AppendFormat("<{0}>", "jdryList");
DataRow jdryRow = dt_tzs_jdry.NewRow();
jdryXmlData = xmlHelper.ConvertDataRowToXML(jdryItem);
str.Append(jdryXmlData);
str.AppendFormat("</{0}>", "jdryList");
}
str.AppendFormat("</{0}>", "result");
str.AppendFormat("</{0}>", "data");
string addResultSt = client.pushZJTZS(deptcode, sbPassword, str.ToString());
BLLCommon.WriteLog("deptcode:" + deptcode);
BLLCommon.WriteLog("向省一站式申报平台推送质监监督通知书:" + str.ToString() + "\n结果：" + addResultSt);
DataTable dt = DAL.GetTBData_SaveToStLog("Ap_zjtzs", dataRow["id"].ToString());
if (dt.Rows.Count > 0)
{
row = dt.Rows[0];
row["UpdateDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
row["TableName"] = "Ap_zjtzs";
}
else
{
row = dt.NewRow();
row["CreateDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
row["UpdateDate"] = row["CreateDate"];
row["TableName"] = "Ap_zjtzs";
row["PKID"] = dataRow["id"];
dt.Rows.Add(row);
}
if (addResultSt != "OK")
{
row["OperateState"] = 1;
row["Msg"] = addResultSt;
result.code = ProcessResult.保存失败和失败原因;
result.message = "数据上传省厅失败：" + addResultSt;
}
else
{
//已办结
updateZJSBStatus(dataRow["uuid"].ToString2(), (int)ApproveStatus.已办结);
row["OperateState"] = 0;
row["Msg"] = "上传成功";
result.code = ProcessResult.数据保存成功;
result.message = "数据保存成功！";
}
if (dt.Rows.Count > 0)
{
DAL.SaveTBData_SaveToStLog(dt);
}
}
catch (Exception ex)
{
try
{
BLLCommon.WriteLog(ex.Message);
}
catch
{
}
result.code = ProcessResult.保存失败和失败原因;
result.message = ex.Message;
return(result);
}
}
else
{
result.code = ProcessResult.保存失败和失败原因;
result.message = "网络故障，数据保存失败！";
}
}
else
{
result.code = ProcessResult.保存失败和失败原因;
result.message = "非法格式的数据！";
}
return(result);
}
/// <summary>
/// 向省一站式申报平台推送质监申报结果
/// </summary>
/// <param name="user"></param>
/// <param name="dt_Data"></param>
/// <returns></returns>
public ProcessResultData pushZJSBJG(string user, string deptcode, string sbPassword, DataTable dt_Data, DataTable dwgcDt)
{
ProcessResultData result = new ProcessResultData();
StringBuilder prjInnerNumSb = new StringBuilder();
string msg = String.Empty;
string[] fields = new string[] { "uuid", "success", "slry", "slrq" };
DataRow item = dt_Data.Rows[0];
List <string> novalidates = new List <string>();
novalidates.Add(String.Empty);
novalidates.Add(" ");
novalidates.Add("无");
novalidates.Add("无数据");
novalidates.Add("/");
if (BLLCommon.DataFieldIsNullOrEmpty(novalidates, fields, item, out msg))
{
result.code = ProcessResult.保存失败和失败原因;
result.message = msg + "不能为空！";
return(result);
}
DataTable dt_zjsbjg = DAL.GetAp_zjsbjg();
DataRow row = dt_zjsbjg.NewRow();
DataTableHelp.DataRow2DataRow(item, row);
row["id"] = Guid.NewGuid();
row["UpdateTime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
dt_zjsbjg.Rows.Add(row);
row["deptcode"] = deptcode;
row["sbPassword"] = sbPassword;
row["UpdateUser"] = user;
//保存单位工程列表
DataTable dt_zjsbjg_dwgc = null;
if (dwgcDt != null && dwgcDt.Rows.Count > 0)
{
dt_zjsbjg_dwgc = DAL.GetAp_zjsbjg_dwgc();
foreach (DataRow dwgcItem in dwgcDt.Rows)
{
DataRow dwgcRow = dt_zjsbjg_dwgc.NewRow();
DataTableHelp.DataRow2DataRow(dwgcItem, dwgcRow);
dwgcRow["uuid"] = row["uuid"];
dt_zjsbjg_dwgc.Rows.Add(dwgcRow);
}
}
if (row["success"].ToString().Equals("Yes") && dt_zjsbjg_dwgc != null)
{
DAL.SaveAp_zjsbjg_dwgc(dt_zjsbjg_dwgc);
}
if (dt_zjsbjg.Rows.Count > 0)
{
if (DAL.SaveAp_zjsbjg(dt_zjsbjg))
{
try
{
StringBuilder str = new StringBuilder();
string xmlData = "";
string dwgcXmlData = string.Empty;
//向省一站式申报平台推送质监申报结果
DataRow dataRow = dt_zjsbjg.Rows[0];
//string[] excludeColumns = new string[] { "id", "deptcode", "sbPassword", "UpdateTime", "UpdateUser" };
xmlData = xmlHelper.ConvertDataRowToXML(dataRow);
//string[] dwgcExcludeCols = new string[] { "id", "uuid" };
List <string> dwgcExcludeCols = new List <string>();
dwgcExcludeCols.Add("id");
dwgcExcludeCols.Add("uuid");
//dwgcXmlData = xmlHelper.ConvertDataTableToXML(dwgcDt, "dwgcList", "dwgccontent");
str.Append("<?xml version=\"1.0\" encoding=\"gb2312\"?>");
str.AppendFormat("<{0}>", "data");
str.AppendFormat("<{0}>", "result");
str.Append(xmlData);
//单位工程列表
if (row["success"].ToString().Equals("Yes"))
{
if (dwgcDt != null && dwgcDt.Rows.Count > 0)
{
foreach (DataRow dwgcItem in dwgcDt.Rows)
{
str.AppendFormat("<{0}>", "dwgcList");
dwgcXmlData = xmlHelper.ConvertDataRowToXML(dwgcItem, dwgcExcludeCols);
str.Append(dwgcXmlData);
str.AppendFormat("</{0}>", "dwgcList");
}
str.Append(dwgcXmlData);
}
}
str.AppendFormat("</{0}>", "result");
str.AppendFormat("</{0}>", "data");
string addResultSt = client.pushZJSBJG(deptcode, sbPassword, str.ToString());
//string addResultSt = string.Empty;
BLLCommon.WriteLog("deptcode:" + deptcode);
BLLCommon.WriteLog("向省一站式申报平台推送质监申报结果:" + str.ToString() + "\n结果：" + addResultSt);
BLLCommon.WriteLog("id" + dataRow["id"].ToString());
DataTable dt = DAL.GetTBData_SaveToStLog("Ap_zjsbjg", dataRow["id"].ToString());
DataRow logRow = null;
if (dt.Rows.Count > 0)
{
logRow = dt.Rows[0];
logRow["UpdateDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
logRow["TableName"] = "Ap_zjsbjg";
}
else
{
logRow = dt.NewRow();
logRow["CreateDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
logRow["UpdateDate"] = logRow["CreateDate"];
logRow["TableName"] = "Ap_zjsbjg";
logRow["PKID"] = dataRow["id"];
dt.Rows.Add(logRow);
}
if (addResultSt != "OK")
{
logRow["OperateState"] = 1;
logRow["Msg"] = addResultSt;
result.code = ProcessResult.保存失败和失败原因;
result.message = "数据上传省厅失败：" + addResultSt;
}
else
{
//更新质监申报结果审批状态
if (row["success"].ToString().Equals("Yes"))
{
updateZJSBStatus(row["uuid"].ToString2(), (int)ApproveStatus.已推送申报结果);
}
else
{
updateZJSBStatus(row["uuid"].ToString2(), (int)ApproveStatus.已退回);
}
logRow["OperateState"] = 0;
logRow["Msg"] = "上传成功";
result.code = ProcessResult.数据保存成功;
result.message = "数据保存成功！";
}
if (dt.Rows.Count > 0)
{
DAL.SaveTBData_SaveToStLog(dt);
}
}
catch (Exception ex)
{
try
{
BLLCommon.WriteLog(ex.Message);
}
catch
{
}
result.code = ProcessResult.保存失败和失败原因;
result.message = ex.Message;
return(result);
}
}
else
{
result.code = ProcessResult.保存失败和失败原因;
result.message = "网络故障，数据保存失败！";
}
}
else
{
result.code = ProcessResult.保存失败和失败原因;
result.message = "非法格式的数据！";
}
return(result);
}
/// <summary>
/// 向省一站式申报平台推送终止施工安全监督告知书
/// </summary>
/// <param name="user"></param>
/// <param name="deptcode"></param>
/// <param name="sbPassword"></param>
/// <param name="dt_Data"></param>
/// <returns></returns>
public ProcessResultData pushAJZZGZ(string user, string deptcode, string sbPassword, DataTable dt_Data)
{
ProcessResultData result = new ProcessResultData();
StringBuilder prjInnerNumSb = new StringBuilder();
string msg = String.Empty;
string[] fields = new string[] { "uuid", "zzyy", "zzrq" };
DataRow item = dt_Data.Rows[0];
List <string> novalidates = new List <string>();
novalidates.Add(String.Empty);
novalidates.Add(" ");
novalidates.Add("无");
novalidates.Add("无数据");
novalidates.Add("/");
if (BLLCommon.DataFieldIsNullOrEmpty(novalidates, fields, item, out msg))
{
result.code = ProcessResult.保存失败和失败原因;
result.message = msg + "不能为空！";
return(result);
}
DataTable dt_ajzzgz = DAL.GetApTable(AP_AJZZGZ);
DataRow row = dt_ajzzgz.NewRow();
DataTableHelp.DataRow2DataRow(item, row);
row["id"] = Guid.NewGuid();
row["UpdateTime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
dt_ajzzgz.Rows.Add(row);
row["deptcode"] = deptcode;
row["sbPassword"] = sbPassword;
row["UpdateUser"] = user;
if (dt_ajzzgz.Rows.Count > 0)
{
if (DAL.SaveApTable(AP_AJZZGZ, dt_ajzzgz))
{
try
{
StringBuilder str = new StringBuilder();
string xmlData = "";
DataRow dataRow = dt_ajzzgz.Rows[0];
//向省一站式申报平台推送安监申报结果
List <string> excludeColumns = new List <string>();
excludeColumns.Add("id");
excludeColumns.Add("deptcode");
excludeColumns.Add("sbPassword");
excludeColumns.Add("UpdateTime");
excludeColumns.Add("UpdateUser");
xmlData = xmlHelper.ConvertDataRowToXML(dataRow, excludeColumns);
str.Append("<?xml version=\"1.0\" encoding=\"gb2312\"?>");
str.AppendFormat("<{0}>", "data");
str.AppendFormat("<{0}>", "result");
str.Append(xmlData);
str.AppendFormat("</{0}>", "result");
str.AppendFormat("</{0}>", "data");
string addResultSt = client.pushAJZZGZ(deptcode, sbPassword, str.ToString());
BLLCommon.WriteLog("deptcode:" + deptcode);
BLLCommon.WriteLog("向省一站式申报平台推送终止施工安全监督告知书:" + str.ToString() + "\n结果：" + addResultSt);
DataTable dt = DAL.GetTBData_SaveToStLog(AP_AJZZGZ, dataRow["id"].ToString());
if (dt.Rows.Count > 0)
{
row = dt.Rows[0];
row["UpdateDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
row["TableName"] = AP_AJZZGZ;
}
else
{
row = dt.NewRow();
row["CreateDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
row["UpdateDate"] = row["CreateDate"];
row["TableName"] = AP_AJZZGZ;
row["PKID"] = dataRow["id"];
dt.Rows.Add(row);
}
if (addResultSt != "OK")
{
row["OperateState"] = 1;
row["Msg"] = addResultSt;
result.code = ProcessResult.保存失败和失败原因;
result.message = "数据上传省厅失败：" + addResultSt;
}
else
{
row["OperateState"] = 0;
row["Msg"] = "上传成功";
result.code = ProcessResult.数据保存成功;
result.message = "数据保存成功！";
}
if (dt.Rows.Count > 0)
{
DAL.SaveTBData_SaveToStLog(dt);
}
}
catch (Exception ex)
{
try
{
BLLCommon.WriteLog(ex.Message);
}
catch
{
}
result.code = ProcessResult.保存失败和失败原因;
result.message = ex.Message;
return(result);
}
}
else
{
result.code = ProcessResult.保存失败和失败原因;
result.message = "网络故障，数据保存失败！";
}
}
else
{
result.code = ProcessResult.保存失败和失败原因;
result.message = "非法格式的数据！";
}
return(result);
}
/// <summary>
/// 向省一站式申报平台推送安监申报结果
/// </summary>
/// <param name="user"></param>
/// <param name="dt_Data"></param>
/// <returns></returns>
public ProcessResultData pushAJSBJG(string user, string deptcode, string sbPassword, DataTable dt_Data)
{
ProcessResultData result = new ProcessResultData();
StringBuilder prjInnerNumSb = new StringBuilder();
string msg = String.Empty;
string[] fields = new string[] { "uuid", "success", "slry", "slrq" };
DataRow item = dt_Data.Rows[0];
List <string> novalidates = new List <string>();
novalidates.Add(String.Empty);
novalidates.Add(" ");
novalidates.Add("无");
novalidates.Add("无数据");
novalidates.Add("/");
if (BLLCommon.DataFieldIsNullOrEmpty(novalidates, fields, item, out msg))
{
result.code = ProcessResult.保存失败和失败原因;
result.message = msg + "不能为空！";
return(result);
}
DataTable dt_ajsbjg = DAL.GetAp_ajsbjg();
DataRow row = dt_ajsbjg.NewRow();
DataTableHelp.DataRow2DataRow(item, row);
row["id"] = Guid.NewGuid();
row["UpdateTime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
dt_ajsbjg.Rows.Add(row);
row["deptcode"] = deptcode;
row["sbPassword"] = sbPassword;
row["UpdateUser"] = user;
if (dt_ajsbjg.Rows.Count > 0)
{
if (DAL.SaveAp_ajsbjg(dt_ajsbjg))
{
try
{
StringBuilder str = new StringBuilder();
string xmlData = "";
DataRow dataRow = dt_ajsbjg.Rows[0];
//向省一站式申报平台推送安监申报结果
string[] excludeColumns = new string[] { "id", "deptcode", "", "sbPassword", "UpdateTime", "UpdateUser" };
xmlData = xmlHelper.ConvertDataRowToXML(dataRow);
str.Append("<?xml version=\"1.0\" encoding=\"gb2312\"?>");
str.AppendFormat("<{0}>", "data");
str.AppendFormat("<{0}>", "result");
str.Append(xmlData);
str.AppendFormat("</{0}>", "result");
str.AppendFormat("</{0}>", "data");
string addResultSt = client.pushAJSBJG(deptcode, sbPassword, str.ToString());
BLLCommon.WriteLog("deptcode:" + deptcode);
BLLCommon.WriteLog("向省一站式申报平台推送安监申报结果:" + xmlData + "\n结果：" + addResultSt);
DataTable dt = DAL.GetTBData_SaveToStLog("Ap_ajsbjg", dataRow["id"].ToString());
if (dt.Rows.Count > 0)
{
row = dt.Rows[0];
row["UpdateDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
row["TableName"] = "Ap_ajsbjg";
}
else
{
row = dt.NewRow();
row["CreateDate"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
row["UpdateDate"] = row["CreateDate"];
row["TableName"] = "Ap_ajsbjg";
row["PKID"] = dataRow["id"];
dt.Rows.Add(row);
}
if (addResultSt == "未找到申报流水号")
{
//此申报流水号已删除，标记为已删除
deleteAjsbbByUuid(dataRow["uuid"].ToString());
}
if (addResultSt != "OK")
{
row["OperateState"] = 1;
row["Msg"] = addResultSt;
result.code = ProcessResult.保存失败和失败原因;
result.message = "上传到省厅失败：" + addResultSt;
}
else
{
//更新申报结果审批状态
if (dataRow["success"].ToString().Equals("Yes"))
{
updateAJSBStatus(dataRow["uuid"].ToString2(), (int)ApproveStatus.已推送申报结果);
}
else
{
updateAJSBStatus(dataRow["uuid"].ToString2(), (int)ApproveStatus.已退回);
}
row["OperateState"] = 0;
row["Msg"] = "上传成功";
result.code = ProcessResult.数据保存成功;
result.message = "数据保存成功！";
}
if (dt.Rows.Count > 0)
{
DAL.SaveTBData_SaveToStLog(dt);
}
}
catch (Exception ex)
{
try
{
BLLCommon.WriteLog(ex.Message);
}
catch
{
}
result.code = ProcessResult.保存失败和失败原因;
result.message = ex.Message;
return(result);
}
}
else
{
result.code = ProcessResult.保存失败和失败原因;
result.message = "网络故障，数据保存失败！";
}
}
else
{
result.code = ProcessResult.保存失败和失败原因;
result.message = "非法格式的数据！";
}
return(result);
}
