/// <summary>
/// 선배차 종료시 Button_change 발. 쿼리로 현재 단계 재조회
/// </summary>
public void Button_change()
{
bizService = getBizService();
oraDt = bizService.GetAutoallocate();
DataRow statusDr = oraDt.Rows[0];
//textEdit_plan_date.Text = statusDr["plan_date"].ToString();
//textEdit_planst.Text = statusDr["planst"].ToString();
//textEdit_policy_list.Text = statusDr["policy_list"].ToString();
//textEdit_plan_status.Text = statusDr["plan_status"].ToString();
//plan_status_button = statusDr["plan_status_button"].ToString();
textEdit_plan_date.Text = statusDr["PLANDT"].ToString();
textEdit_planst.Text = statusDr["PLANST"].ToString();
textEdit_policy_list.Text = statusDr["POLYID"].ToString();
plan_status_button = statusDr["PLAN_STATUS_BUTTON"].ToString();
SetStatus(plan_status_button);
}
public static News GetNews(Guid newsId)
{
BizService bs = new BizService();
News news = new News();
using (System.Data.DataTable dt = bs.GetNews(newsId))
{
System.Data.DataRow row = dt.Rows[0];
news.NewsId = new Guid(row["newsId"].ToString());
news.Title = row["title"].ToString();
news.Content = row["ncontent"].ToString();
news.IsTop = char.Parse(row["istop"].ToString());
news.IsVal = char.Parse(row["isvalidate"].ToString());
news.CreateDate = DateTime.Parse(row["createDate"].ToString());
news.NType = char.Parse(row["ntype"].ToString());
news.UserName = row["userName"].ToString();
}
return(news);
}
private void SetSummary()
{
try
{
GridView view_gridSummary = (GridView)gridDispatchingSummary.Views[0];
dtGridSummary.Rows.Clear();
bizService = getBizService();
OracleDataTable summaryOradt = bizService.GetMakeDispatchSummary();
#region Print dt
//PrintDebug(summaryOradt);
#endregion
foreach (DataRow _row in summaryOradt.Rows)
{
DataRow dr = dtGridSummary.NewRow();
gridView1.Columns["gridColumn1"].ColumnEdit = GetRepositoryItemCheckEdit();
dr["gridColumn2"] = _row["POLYID"];
dr["gridColumn3"] = _row["PLANPH"];
dr["gridColumn4"] = _row["VHCCNT"];
dr["gridColumn5"] = _row["NALRTO"];
dr["gridColumn6"] = _row["ALDRTO"];
dr["gridColumn7"] = _row["PERCST"];
dtGridSummary.Rows.Add(dr);
}
gridDispatchingSummary.DataSource = dtGridSummary;
gridDispatchingSummary.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//조회버튼 클릭
private void buttonView_Click(object sender, EventArgs e)
{
try
{
screenManager.ShowWaitForm();
dtGridCarDispatching.Rows.Clear();
bizService = (BizService)_applicationContext.GetObject("BizService");
//OracleDataTable dt = bizService.GetCarList();
OracleDataTable dt = bizService.GetPreOrderCarList();
foreach (DataRow _row in dt.Rows)
{
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_startTime_hour", 23);
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_startTime_minute", 59);
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_startTime_second", 59);
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_endTime_hour", 23);
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_endTime_minute", 59);
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_endTime_second", 59);
SetRepositoryItemComboBoxBindData(gridCarDispatching, "FINTWA", "working_apply", dt);
DataRow dr = dtGridCarDispatching.NewRow();
dr["carNum"] = _row["VEHCID"];
dr["carType"] = _row["VHCTON"];
string work_startTime = _row["TIMWFR"].ToString();
if (!(work_startTime == null || work_startTime.Equals("")))
{
dr["working_startTime_hour"] = work_startTime.Substring(0, 2);;
dr["working_startTime_minute"] = work_startTime.Substring(3, 2);
dr["working_startTime_second"] = work_startTime.Substring(6, 2);
}
string work_endTime = _row["TIMWTO"].ToString();
if (!(work_endTime == null || work_endTime.Equals("")))
{
dr["working_endTime_hour"] = work_endTime.Substring(0, 2);
dr["working_endTime_minute"] = work_endTime.Substring(3, 2);
dr["working_endTime_second"] = work_endTime.Substring(6, 2);
}
dr["working_apply"] = "Y";;
dtGridCarDispatching.Rows.Add(dr);
gridCarDispatching.DataSource = dtGridCarDispatching;
}
//gridCarDispatching.DataSource = dt;
gridCarDispatching.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
screenManager.CloseWaitForm();
}
}
//저장버튼
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
screenManager.ShowWaitForm();
int lengthArr = 1000;
lengthArr = bandedGridView1.DataRowCount;
bizService = (BizService)_applicationContext.GetObject("BizService");
string[] str_arr = new string[lengthArr];
string str = "";
int car_row = 0;
string start_hour = "";
string start_minute = "";
string start_second = "";
string end_hour = "";
string end_minute = "";
string end_second = "";
foreach (DataRow _row1 in dtGridCarDispatching.Rows)
{
for (int i = 0; i < _row1.ItemArray.Length; i++)
{
if (i == 3)
{
if (_row1.ItemArray[i].ToString().Length == 1)
{
start_hour = "0" + _row1.ItemArray[i].ToString();
}
else
{
start_hour = _row1.ItemArray[i].ToString();
}
}
if (i == 4)
{
if (_row1.ItemArray[i].ToString().Length == 1)
{
start_minute = "0" + _row1.ItemArray[i].ToString();
}
else
{
start_minute = _row1.ItemArray[i].ToString();
}
}
if (i == 5)
{
if (_row1.ItemArray[i].ToString().Length == 1)
{
start_second = "0" + _row1.ItemArray[i].ToString();
}
else
{
start_second = _row1.ItemArray[i].ToString();
}
}
if (i == 7)
{
if (_row1.ItemArray[i].ToString().Length == 1)
{
end_hour = "0" + _row1.ItemArray[i].ToString();
}
else
{
end_hour = _row1.ItemArray[i].ToString();
}
}
if (i == 8)
{
if (_row1.ItemArray[i].ToString().Length == 1)
{
end_minute = "0" + _row1.ItemArray[i].ToString();
}
else
{
end_minute = _row1.ItemArray[i].ToString();
}
}
if (i == 9)
{
if (_row1.ItemArray[i].ToString().Length == 1)
{
end_second = "0" + _row1.ItemArray[i].ToString();
}
else
{
end_second = _row1.ItemArray[i].ToString();
}
}
//str = _row1.ItemArray[0] + "↑" + start_hour + ":" + start_minute + ":" + start_second + "↑" + end_hour + ":" + end_minute + ":" + end_second;
if (!_row1.ItemArray[0].ToString().Equals(""))
{
str = _row1.ItemArray[0] + "↑";
}
else
{
str = "↑";
}
if (!start_hour.Equals("") || !start_minute.Equals("") || !start_second.Equals(""))
{
str += start_hour + ":" + start_minute + ":" + start_second + "↑";
}
else
{
str += "↑";//공백을 안넣으면 업데이트가 안됨.
}
if (!end_hour.Equals("") || !end_minute.Equals("") || !end_second.Equals(""))
{
str += end_hour + ":" + end_minute + ":" + end_second;
}
else
{
str += "";
}
}
str_arr[car_row] = str;
car_row++;
str = "";
}
string result = bizService.SaveCarList(str_arr);
messagebox(result);
//// 저장할 선배차 정보관리 테이블포맷
//DataTable cursorDt = new DataTable();
//cursorDt.Columns.Add("VEHCID", typeof(string));
////cursorDt.Columns.Add("VHCTON", typeof(string));
//cursorDt.Columns.Add("TIMWFR", typeof(string));
//cursorDt.Columns.Add("TIMWTO", typeof(string));
////cursorDt.Columns.Add("FVHCTW", typeof(string));
//for( int j =0; j<bandedGridView1.RowCount;j++)
//{
// DataRow dt1 = bandedGridView1.GetDataRow(j);
// DataRow cursorDr = cursorDt.NewRow();
// cursorDr["VEHCID"] = dt1["carNum"];
// //cursorDr["VHCTON"] = dt1["carType"];
// cursorDr["TIMWFR"] = dt1["working_startTime_hour"].ToString() + ":" + dt1["working_startTime_minute"].ToString() + ":" + dt1["working_startTime_second"].ToString();
// cursorDr["TIMWTO"] = dt1["working_endTime_hour"].ToString() + ":" + dt1["working_endTime_minute"].ToString() + ":" + dt1["working_endTime_second"].ToString();
// //cursorDr["FVHCTW"] = dt1["working_apply"];
// cursorDt.Rows.Add(cursorDr);
//}
//string result = bizService.SaveCarList(cursorDt);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
screenManager.CloseWaitForm();
}
}
public static bool DeleteNews(Guid newsId)
{
BizService bs = new BizService();
return(bs.DeleteNews(newsId));
}
public static System.Data.DataTable GetNewsList(string title, char ntype)
{
BizService bs = new BizService();
return(bs.GetNewsList(title, ntype));
}
public static bool UpdateNews(Guid newsId, string title, string content, char isVal, char isTop, char ntype)
{
BizService bs = new BizService();
return(bs.UpdateNews(newsId, title, content, isVal, isTop, ntype));
}
public JsonResult Get_PCM_Result()
{
AppUtility.Engine.LogWriter.Write("中科软回调开始");
var xml_result = "";
try
{
//1.直接拿到Body中的内容
var sr = new StreamReader(Request.InputStream);
xml_result = HttpUtility.HtmlDecode(sr.ReadToEnd());
//2.截取出PBOCDATA内的内容
int first_index = xml_result.IndexOf("<PBOCDATA>");
int last_index = xml_result.IndexOf("</PBOCDATA>");
var result = "<?xml version=\"1.0\" encoding=\"UTF - 8\" ?>" + xml_result.Substring(first_index, last_index - first_index + 11);
AppUtility.Engine.LogWriter.Write("Get_PCM_Result:" + result);
//3.采用xml反序列化进行，但是Applicant在有多个人的情况下是并列的，这不符合规范，所以增加了一个Applicants节点，把所有的Applicant包括在内；
int f_index = result.IndexOf("<Applicant>");
int l_index = result.LastIndexOf("</Applicant>");
result = result.Substring(0, f_index) + "<Applicants>" + result.Substring(f_index, l_index - f_index + 12) +
"</Applicants>" + result.Substring(l_index + 12);
TextReader tr = new StringReader(result);
XmlSerializer reader = new XmlSerializer(typeof(PBOCDATA));
PBOCDATA pboc_data = reader.Deserialize(tr) as PBOCDATA;
AppUtility.Engine.LogWriter.Write("中科软回调申请号：" + pboc_data.Data.application_no);
//4.保存pboc_data的值；
Save_PBOC_Data(pboc_data);
//5.发送给融数；
string application_no = pboc_data.Data.application_no;
if (!string.IsNullOrEmpty(application_no))
{
string SchemaCode = "RetailApp";
string[] arryV = application_no.Split('_');
string manual = application_no.Split('_')[1].Substring(0, 1);
string schemaid = application_no.Split('_')[1].Substring(1, 1);
if (schemaid == "2")
{
SchemaCode = "CompanyApp";
}
else if (schemaid == "3")
{
SchemaCode = "APPLICATION";
}
string sql = "select objectid from OT_InstanceContext where bizobjectschemacode='" + SchemaCode + "'and sequenceno='" + arryV[2] + "'";
string instanceid = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteScalar(sql).ToString();
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("SchemaCode", SchemaCode + string.Empty);
dic.Add("manual", manual + string.Empty);
dic.Add("instanceid", instanceid + string.Empty);
BizService.ExecuteBizNonQuery("DZWebService", "postHttp", dic);
}
else
{
AppUtility.Engine.LogWriter.Write("调用风控失败：申请号，" + pboc_data.Data.application_no);
}
}
catch (Exception ex)
{
AppUtility.Engine.LogWriter.Write("中科软回调开始失败--> xml_result:" + xml_result + "，错误信息：" + ex.Message);
}
return(Json("Received!", JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 取得最新的流水号
/// </summary>
/// <param name="Prefix">IMG V</param>
/// <returns></returns>
public string GetSN(string Prefix)
{
BizService bs = new BizService();
return(bs.GetSN(Prefix));
}
/// <summary>
/// 263
/// </summary>
/// <param name="isAll">是否完全同步</param>
/// <param name="ExecutionTime">执行时间</param>
/// <returns></returns>
public static string SetYXTUser(bool isAll, DateTime ExecutionTime)
{
var msg = "";
string domain = "dongzhengafc.com";
string account = "dongzhengafc.com";
string sign1 = "cf6436ec710286f08292d48e36034012";
string sign2 = "d7e7089f86df015c74fdadcc244ce4fb";
xmapi.XmapiImplProxyService api = new xmapi.XmapiImplProxyService();
var ou = api.getDepartment("chenghuashan", domain, account, sign2); //全部ou
var user = api.getDomainUserlist_New(domain, account, sign1); //全部用户
var userDismissed = api.getDomainUserlistByStatus(domain, 1, 0, account, sign1); //禁止用户
if (ou == null || user == null || userDismissed == null)
{
return("263接口取数出错！");
}
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write("ou开始");
DataTable dt = XmlToTablebyOU(ou);
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write("ou结束");
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write("user开始");
DataTable dtUser = XmlToTablebyUser(user);
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write("user结束");
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write("dis开始");
DataTable dtUserDismissed = XmlToTablebyUser(userDismissed);
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write("dis结束");
SyncResult syn = new SyncResult();
if (dt.Rows.Count > 0)
{
if (!YXTOU(dt, "0", isAll, syn))
{
msg = "OU更新失败!请联系管理员查看日志";
}
else
{
var dateuser = DateTime.Now;
TimeSpan ts = dateuser.Subtract(DateTime.Now);
string timespan = "相差:" + ts.Days.ToString() + "天" + ts.Hours.ToString() + "小时"
+ ts.Minutes.ToString() + "分钟" + ts.Seconds.ToString() + "秒";
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write("ou结束修改" + timespan);
if (!YXTUser(dtUser, isAll, false, syn, ExecutionTime))
{
msg = "263USER更新失败!请联系管理员查看日志";
}
else
{
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write("user结束修改");
if (!YXTUser(dtUserDismissed, isAll, true, syn, ExecutionTime))
{
msg = "263禁止用户更新失败!请联系管理员查看日志";
}
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write("dis结束修改");
}
}
}
//H3组织架构推送CRM
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("dep", "市场销售部");
try
{
BizService.ExecuteBizNonQuery("CRMService", "postUser", dic);
}
catch (Exception ex)
{
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write("CRM市场部组织架构推送异常：message：" + ex.Message);
}
return(msg + syn.ToString());
}
public static rtn_data GenerateProposalTask(string UserCode, string CustomerName, string IdCardNumber, string Mobile, string AppOrderId)
{
rtn_data rtn = new rtn_data();
var para_get_bp_id = new Dictionary <string, object>();
para_get_bp_id.Add("login_nme", UserCode);
var bp_id_result = BizService.ExecuteBizNonQuery("DropdownListDataSource", "get_bp_id", para_get_bp_id);
if (bp_id_result == null || bp_id_result.Count == 0)
{
AppUtility.Engine.LogWriter.Write("后台获取bp_id失败，login_nme-->" + UserCode);
rtn.code = -1;
rtn.message = "获取bp_id失败，login_nme-->" + UserCode;
}
else
{
#region 自动发起流程的参数
#region 人员关系表参数
var app_type = new List <object>();
app_type.Add(new
{
IDENTIFICATION_CODE1 = 1,
APPLICANT_TYPE = "I",
MAIN_APPLICANT = "Y",
NAME1 = CustomerName
});
#endregion
#region 申请人信息表参数
var app_detail = new List <object>();
app_detail.Add(new
{
IDENTIFICATION_CODE2 = 1,
FIRST_THI_NME = CustomerName,
ID_CARD_NBR = IdCardNumber
});
#endregion
#region 地址信息表参数
var app_ads = new List <object>();
app_ads.Add(new
{
ADDRESS_CODE = 1,
IDENTIFICATION_CODE4 = 1
});
#endregion
#region 电话信息表参数
var app_tel = new List <object>();
app_tel.Add(new
{
PHONE_SEQ_ID = 1,
IDENTIFICATION_CODE5 = 1,
ADDRESS_CODE5 = 1,
PHONE_NUMBER = Mobile
});
#endregion
#region 工作信息表参数
var app_work = new List <object>();
app_work.Add(new
{
EMPLOYEE_LINE_ID = 1,
IDENTIFICATION_CODE6 = 1
});
#endregion
var para = Newtonsoft.Json.JsonConvert.SerializeObject(new
{
USER_NAME = UserCode, //FI账号
APPLICATION_NAME = CustomerName, //主贷人的名称
APPLICANT_TYPE = app_type,
APPLICATION_TYPE_NAME = "个人Individual",
BP_ID = bp_id_result["BP_PRIMARY_ID"] + string.Empty,
AppUnionId = AppOrderId,
APPLICANT_DETAIL = app_detail,
ADDRESS = app_ads,
APPLICANT_PHONE_FAX = app_tel,
EMPLOYER = app_work
});
#endregion
var r = new BPM().StartWorkflow_Base(UserCode, "APPLICATION", false, "", para);
AppUtility.Engine.LogWriter.Write(Newtonsoft.Json.JsonConvert.SerializeObject(r));
if (r.STATUS == "2")
{
rtn.code = 1;
rtn.message = r.MESSAGE;
rtn.data = r.INSTANCE_ID;
}
else
{
rtn.code = -1;
rtn.message = r.MESSAGE;
}
}
return(rtn);
}
/// <summary>
/// // 根据Code判断服务是否存在
/// 如果不存在，则调用 AddBizService 方法
/// 如果存在
/// 判断非覆盖模式，则提示已经存在，不可导入
/// 如果覆盖模式
/// 并且ObjectID不同，把当前导入对象的ObjectID改为服务器的ObjectID，执行更新；
/// 如果ObjectID相同，那么直接执行更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult ImportService(BizServiceHandlerViewModel model)
{
return(ExecuteFunctionRun(() => {
ActionResult result = new ActionResult();
BizService bizService = null;
var newCode = model.ServiceCode;
try
{
ReadXmlFile(ref model, out bizService);
//
model.ServiceCode = newCode;
}
catch
{
result.Success = false;
result.Message = "BizServiceHandler.ServiceImport_Mssg2";
return Json(result);
}
if (string.IsNullOrEmpty(model.ServiceCode))
{
result.Success = false;
result.Message = "BizServiceHandler.ServiceImport_Mssg3";
return Json(result);
}
bool isSuccess = false;
string errorMsg = "msgGlobalString.ImportFail";
BizService record = this.Engine.BizBus.GetBizService(model.ServiceCode);
bizService.FolderCode = model.ParentCode;
if (record == null)
{
bizService.ObjectID = Guid.NewGuid().ToString();
bizService.Serialized = false;
bizService.Code = model.ServiceCode;
bizService.Serialized = false;
bizService.UsedCount = 0; // 将被引用次数重置为0
if (bizService.Settings != null)
{
foreach (BizServiceSetting setting in bizService.Settings)
{
setting.ObjectID = Guid.NewGuid().ToString();
setting.Serialized = false;
}
}
if (bizService.Methods != null)
{
foreach (BizServiceMethod method in bizService.Methods)
{
method.ObjectID = Guid.NewGuid().ToString();
method.Serialized = false;
}
}
isSuccess = this.Engine.BizBus.AddBizService(bizService, true).Valid;
}
else
{
bool isCover = false;
bool.TryParse(model.Cover, out isCover);
if (isCover)
{
bizService.ObjectID = record.ObjectID;
isSuccess = this.Engine.BizBus.UpdateBizService(bizService, true).Valid;
}
else
{
errorMsg = "BizServiceHandler.ServiceImport_Mssg4";
}
}
if (isSuccess)
{
result.Success = true;
result.Message = "msgGlobalString.ImportSucceed";
Session[model.XMLString] = null;//清空Session
}
else
{
result.Success = false;
result.Message = errorMsg;
}
return Json(result);
}));
}
/// <summary>
/// 上传业务服务文件
/// </summary>
/// <returns></returns>
public JsonResult Upload()
{
return(ExecuteFunctionRun(() =>
{
System.Web.HttpFileCollectionBase files = HttpContext.Request.Files;//传输的文件
ActionResult result = new ActionResult();
BizServiceHandlerViewModel model = new BizServiceHandlerViewModel();
if (files == null || files.Count == 0 || string.IsNullOrEmpty(files[0].FileName))
{
result.Success = false;
result.Message = "msgGlobalString.SelectFile";
return Json(result, "text/html", JsonRequestBehavior.AllowGet);
}
string fileType = Path.GetExtension(TrimHtml(Path.GetFileName(files[0].FileName))).ToLowerInvariant();
if (!fileType.Replace(".", "").Equals("xml"))
{
result.Success = false;
result.Message = "msgGlobalString.FileMustIsXML";
return Json(result, "text/html", JsonRequestBehavior.AllowGet);
}
//将文件内容存放在缓存中
string xmlStr = string.Empty;
using (StreamReader sr = new StreamReader(files[0].InputStream))
{
xmlStr = sr.ReadToEnd();
}
string newName = Guid.NewGuid().ToString() + fileType;
model.FileName = newName;
model.XMLString = Guid.NewGuid().ToString(); //SessionName
Session[model.XMLString] = xmlStr; //存储XML字符串
//验证是否为伪造的xml文件
try
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(xmlStr);
}
catch (Exception ex)
{
result.Success = false;
result.Message = "msgGlobalString.InvilidateFile";
return Json(result, "text/html", JsonRequestBehavior.AllowGet);
}
BizService bizService = null;
try
{
ReadXmlFile(ref model, out bizService); //从XML中读取服务名称和编码
}
catch {
result.Success = false;
result.Message = "msgGlobalString.InvilidateFile";
return Json(result, "text/html", JsonRequestBehavior.AllowGet);
}
//界面控制，前台控制
result.Success = true;
result.Message = "";
result.Extend = model;
return Json(result, "text/html", JsonRequestBehavior.AllowGet);
}));
}
