/// <summary>
/// 生成选中项的值和描述
/// </summary>
void GenerateSelectedValueAndText()
{
SelectedGridList = new List <MDLSM_Organization>();
foreach (var loopSourceItem in ListGridDS)
{
if (!loopSourceItem.IsChecked)
{
continue;
}
MDLSM_Organization argsOrg = new MDLSM_Organization
{
Org_ID = loopSourceItem.Org_ID,
Org_Code = loopSourceItem.Org_Code,
Org_FullName = loopSourceItem.Org_FullName,
Org_ShortName = loopSourceItem.Org_ShortName,
Org_Contacter = loopSourceItem.Org_Contacter,
Org_TEL = loopSourceItem.Org_TEL,
Org_PhoneNo = loopSourceItem.Org_PhoneNo,
Org_Addr = loopSourceItem.Org_Addr,
Org_Remark = loopSourceItem.Org_Remark
};
SelectedGridList.Add(argsOrg);
}
}
/// <summary>
/// 加载页面
/// </summary>
/// <param name="paramBillPaperSize"></param>
private void LoadTransferBill(BillPaperSize paramBillPaperSize)
{
reportViewer1.Reset();
string rdlcFileName = string.Empty;
switch (paramBillPaperSize)
{
case BillPaperSize.CustomerSize:
rdlcFileName = "PIS_ViewAndPrintTransferBill2228_" + @".rdlc";
break;
case BillPaperSize.A4Size:
rdlcFileName = "PIS_ViewAndPrintTransferBill_" + @".rdlc";
break;
case BillPaperSize.A5Size:
rdlcFileName = "PIS_ViewAndPrintTransferBillA5_" + @".rdlc";
break;
case BillPaperSize.A4SizeFull:
rdlcFileName = "PIS_ViewAndPrintTransferBillA4Full_" + @".rdlc";
break;
}
string reportFilePath = Application.StartupPath + @"\RdlcFiles\" + rdlcFileName;
if (!File.Exists(reportFilePath))
{
switch (paramBillPaperSize)
{
case BillPaperSize.CustomerSize:
reportFilePath = Application.StartupPath + @"\RdlcFiles\PIS_ViewAndPrintTransferBill2228.rdlc";
break;
case BillPaperSize.A4Size:
reportFilePath = Application.StartupPath + @"\RdlcFiles\PIS_ViewAndPrintTransferBill.rdlc";
break;
case BillPaperSize.A5Size:
reportFilePath = Application.StartupPath + @"\RdlcFiles\PIS_ViewAndPrintTransferBillA5.rdlc";
break;
case BillPaperSize.A4SizeFull:
reportFilePath = Application.StartupPath + @"\RdlcFiles\PIS_ViewAndPrintTransferBillA4Full.rdlc";
break;
}
}
if (File.Exists(reportFilePath))
{
reportViewer1.LocalReport.ReportPath = reportFilePath;
reportViewer1.LocalReport.DataSources.Clear();
List <TransferBillUIModelToPrint> billList = new List <TransferBillUIModelToPrint> {
_transferBill
};
ReportDataSource rpd1 = new ReportDataSource(PISViewParamKey.TransferBill.ToString(), billList as object);
reportViewer1.LocalReport.DataSources.Add(rpd1);
ReportDataSource rpd2 = new ReportDataSource(PISViewParamKey.TransferBillDetail.ToString(), _transferBillDetailList as object);
reportViewer1.LocalReport.DataSources.Add(rpd2);
//查询调入组织信息
MDLSM_Organization transferInOrganization = new MDLSM_Organization();
_bll.QueryForObject <MDLSM_Organization, MDLSM_Organization>(new MDLSM_Organization
{
WHERE_Org_ID = _transferBill.TB_TransferInOrgId,
}, transferInOrganization);
//调入方信息
ReportParameter rp1 = new ReportParameter("TransferInOrgName", string.IsNullOrEmpty(_transferBill.TB_TransferInOrgName) ? SysConst.SPACE : _transferBill.TB_TransferInOrgName);
ReportParameter rp2 = new ReportParameter("TransferInOrgPhone", string.IsNullOrEmpty(transferInOrganization.Org_TEL) ? SysConst.SPACE : transferInOrganization.Org_TEL);
ReportParameter rp3 = new ReportParameter("TransferBillNo", _transferBill.TB_No);
//调出方信息
//查询调出组织信息
MDLSM_Organization transferOutOrganization = new MDLSM_Organization();
if (_transferBill.TB_TransferInOrgId == _transferBill.TB_TransferOutOrgId)
{
transferOutOrganization = transferInOrganization;
}
else
{
_bll.QueryForObject <MDLSM_Organization, MDLSM_Organization>(new MDLSM_Organization
{
WHERE_Org_ID = _transferBill.TB_TransferOutOrgId,
}, transferOutOrganization);
}
ReportParameter rp4 = new ReportParameter("TransferOutOrgName", string.IsNullOrEmpty(_transferBill.TB_TransferOutOrgName) ? SysConst.SPACE : _transferBill.TB_TransferOutOrgName);
ReportParameter rp5 = new ReportParameter("TransferOutOrgAddress", string.IsNullOrEmpty(transferOutOrganization.Org_Addr) ? SysConst.SPACE : transferOutOrganization.Org_Addr);
ReportParameter rp6 = new ReportParameter("TransferOutOrgTel", string.IsNullOrEmpty(transferOutOrganization.Org_TEL) ? SysConst.SPACE : transferOutOrganization.Org_TEL);
ReportParameter rp7 = new ReportParameter("TransferOutOrgMainProducts", string.IsNullOrEmpty(transferOutOrganization.Org_MainProducts) ? SysConst.SPACE : transferOutOrganization.Org_MainProducts);
ReportParameter rp8 = new ReportParameter("CreatedBy", string.IsNullOrEmpty(_transferBill.TB_CreatedBy) ? SysConst.SPACE : _transferBill.TB_CreatedBy);
ReportParameter rp9 = new ReportParameter("TotalAmount", _transferBill.TotalAmount.ToString());
ReportParameter rp10 = new ReportParameter("TotalAmountString", ConvertMoneyNum(_transferBill.TotalAmount));
ReportParameter rp11 = new ReportParameter("TotalQty", _transferBill.TotalQty.ToString());
this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4, rp5, rp6, rp7, rp8, rp9, rp10, rp11 });
//设置打印布局模式,显示物理页面大小
reportViewer1.SetDisplayMode(DisplayMode.PrintLayout);
//缩放模式为百分比,以100%方式显示
reportViewer1.ZoomMode = ZoomMode.Percent;
reportViewer1.ZoomPercent = 100;
reportViewer1.RefreshReport();
reportViewer1.Refresh();
}
else
{
MessageBoxs.Show(Trans.PIS, this.ToString(), MsgHelp.GetMsg(MsgCode.E_0010, new object[]
{ SystemActionEnum.Name.PRINT }), MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
/// <summary>
/// 加载页面
/// </summary>
/// <param name="paramBillPaperSize"></param>
private void LoadSalesOrder(BillPaperSize paramBillPaperSize)
{
reportViewer1.Reset();
string rdlcFileName = string.Empty;
switch (paramBillPaperSize)
{
case BillPaperSize.CustomerSize:
rdlcFileName = "SD_ViewAndPrintSalesOrder2228_" + @".rdlc";
break;
case BillPaperSize.A4Size:
rdlcFileName = "SD_ViewAndPrintSalesOrder_" + @".rdlc";
break;
case BillPaperSize.A5Size:
rdlcFileName = "SD_ViewAndPrintSalesOrderA5_" + @".rdlc";
break;
case BillPaperSize.A4SizeFull:
rdlcFileName = "SD_ViewAndPrintSalesOrderA4Full_" + @".rdlc";
break;
}
string reportFilePath = Application.StartupPath + @"\RdlcFiles\" + rdlcFileName;
if (!File.Exists(reportFilePath))
{
switch (paramBillPaperSize)
{
case BillPaperSize.CustomerSize:
reportFilePath = Application.StartupPath + @"\RdlcFiles\SD_ViewAndPrintSalesOrder2228.rdlc";
break;
case BillPaperSize.A4Size:
reportFilePath = Application.StartupPath + @"\RdlcFiles\SD_ViewAndPrintSalesOrder.rdlc";
break;
case BillPaperSize.A5Size:
reportFilePath = Application.StartupPath + @"\RdlcFiles\SD_ViewAndPrintSalesOrderA5.rdlc";
break;
case BillPaperSize.A4SizeFull:
reportFilePath = Application.StartupPath + @"\RdlcFiles\SD_ViewAndPrintSalesOrderA4Full.rdlc";
break;
}
}
if (File.Exists(reportFilePath))
{
reportViewer1.LocalReport.ReportPath = reportFilePath;
reportViewer1.LocalReport.DataSources.Clear();
ReportDataSource rpd2 = new ReportDataSource(SDViewParamKey.SalesOrderDetail.ToString(), _salesOrderDetailList as object);
reportViewer1.LocalReport.DataSources.Add(rpd2);
//购买方信息
ReportParameter rp1 = new ReportParameter("CustomerName", _salesOrder.SO_CustomerTypeName == CustomerTypeEnum.Name.PTNQXSH ? _salesOrder.AROrgName : _salesOrder.SO_CustomerName);
ReportParameter rp2 = new ReportParameter("CustomerPhone", _salesOrder.SO_CustomerTypeName == CustomerTypeEnum.Name.PTNQXSH ? _salesOrder.AROrgPhone : _salesOrder.CustomerPhoneNo);
ReportParameter rp3 = new ReportParameter("SalesOrderNo", _salesOrder.SO_No);
//销售方信息
ReportParameter rp4 = new ReportParameter("OrgName", string.IsNullOrEmpty(LoginInfoDAX.OrgShortName) ? SysConst.SPACE : LoginInfoDAX.OrgShortName);
//查询当前组织信息
MDLSM_Organization resultOrganization = new MDLSM_Organization();
_bll.QueryForObject <MDLSM_Organization, MDLSM_Organization>(new MDLSM_Organization
{
WHERE_Org_ID = LoginInfoDAX.OrgID,
}, resultOrganization);
ReportParameter rp5 = new ReportParameter("OrgAddress", string.IsNullOrEmpty(resultOrganization.Org_Addr) ? SysConst.SPACE : resultOrganization.Org_Addr);
ReportParameter rp6 = new ReportParameter("OrgTEL", string.IsNullOrEmpty(LoginInfoDAX.OrgTEL) ? SysConst.SPACE : LoginInfoDAX.OrgTEL);
ReportParameter rp7 = new ReportParameter("OrgMainProducts", string.IsNullOrEmpty(resultOrganization.Org_MainProducts) ? SysConst.SPACE : resultOrganization.Org_MainProducts);
ReportParameter rp8 = new ReportParameter("CreatedBy", string.IsNullOrEmpty(_salesOrder.SO_CreatedBy) ? SysConst.SPACE : _salesOrder.SO_CreatedBy);
_salesOrder.SO_TotalAmount = Math.Round(_salesOrder.SO_TotalAmount ?? 0, 2);
ReportParameter rp9 = new ReportParameter("TotalAmount", _salesOrder.SO_TotalAmount.ToString());
ReportParameter rp10 = new ReportParameter("TotalAmountString", ConvertMoneyNum((decimal)(_salesOrder.SO_TotalAmount ?? 0)));
ReportParameter rp11 = new ReportParameter("TotalQty", _salesOrder.TotalSalesQty.ToString());
ReportParameter rp12 = new ReportParameter("CreatedTime", _salesOrder.SO_CreatedTime == null ? SysConst.SPACE : _salesOrder.SO_CreatedTime.ToString("yyyy-MM-dd"));
this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4, rp5, rp6, rp7, rp8, rp9, rp10, rp11, rp12 });
//设置打印布局模式,显示物理页面大小
reportViewer1.SetDisplayMode(DisplayMode.PrintLayout);
//缩放模式为百分比,以100%方式显示
reportViewer1.ZoomMode = ZoomMode.Percent;
reportViewer1.ZoomPercent = 100;
reportViewer1.RefreshReport();
reportViewer1.Refresh();
}
else
{
MessageBoxs.Show(Trans.SD, this.ToString(), MsgHelp.GetMsg(MsgCode.E_0010, new object[]
{ SystemActionEnum.Name.PRINT }), MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
/// <summary>
/// 验证激活码
/// </summary>
/// <param name="activateCode"></param>
/// <returns></returns>
private void ValActivateSoftCode(string activateCode)
{
#region 激活
string argsPostData = string.Format(ApiParameter.BF0001,
HttpUtility.UrlEncode(activateCode), SysConst.ProductCode);
string strApiData = APIDataHelper.GetAPIData(ApiUrl.BF0001Url, argsPostData);
var jsonResult = (JObject)JsonConvert.DeserializeObject(strApiData);
if (jsonResult["ResultCode"].ToString().Equals("I0001"))
{
#region 更新appSettings
//更新appSettings
ChangeAppConfiguration(jsonResult, activateCode);
//刷新appSettings
ConfigurationManager.RefreshSection("appSettings");
#endregion
try
{
var boolTemp = false;
DBManager.DBInit(DBCONFIG.Coeus);
DBManager.BeginTransaction(DBCONFIG.Coeus);
#region 步组织
var argsListOrganization = jsonResult["ListOrganization"];
if (argsListOrganization != null)
{
var plateformOrgList = JsonConvert.DeserializeObject <List <MDLSM_Organization> >(argsListOrganization.ToString());
var localOrgList = new List <MDLSM_Organization>();
bll.QuerryForList <MDLSM_Organization>(new MDLSM_Organization(), localOrgList);
#region
if (localOrgList.Count > 0)
{
foreach (var model in localOrgList)
{
model.Org_IsValid = false;
model.WHERE_Org_ID = model.Org_ID;
boolTemp = bll.Save <MDLSM_Organization>(model);
if (!boolTemp)
{
MessageBoxs.Show(Trans.COM, this.ToString(), "商户激活失败！\r\n更新组织状态失败！", "消息", MessageBoxButtons.OK, MessageBoxIcon.Error);
DBManager.RollBackTransaction(DBCONFIG.Coeus);
return;
}
}
}
foreach (var org in plateformOrgList)
{
var templocalOrgList = localOrgList.Where(p => p.Org_Code == org.Org_Code).ToList();
if (templocalOrgList.Count > 0)
{
var argsOrganizationorg = templocalOrgList[0];
argsOrganizationorg.WHERE_Org_ID = templocalOrgList[0].Org_ID;
argsOrganizationorg.Org_Code = org.Org_Code;
argsOrganizationorg.Org_FullName = org.Org_FullName;
argsOrganizationorg.Org_ShortName = org.Org_ShortName;
argsOrganizationorg.Org_Contacter = org.Org_Contacter;
argsOrganizationorg.Org_TEL = org.Org_TEL;
argsOrganizationorg.Org_PhoneNo = org.Org_PhoneNo;
argsOrganizationorg.Org_Prov_Code = org.Org_Prov_Code;
argsOrganizationorg.Org_City_Code = org.Org_City_Code;
argsOrganizationorg.Org_Dist_Code = org.Org_Dist_Code;
argsOrganizationorg.Org_Addr = org.Org_Addr;
argsOrganizationorg.Org_Remark = org.Org_Remark;
argsOrganizationorg.Org_PlatformCode = jsonResult["MCT_Code"].ToString();
argsOrganizationorg.Org_IsValid = true;
boolTemp = bll.Save <MDLSM_Organization>(argsOrganizationorg);
if (!boolTemp)
{
MessageBoxs.Show(Trans.COM, this.ToString(), "商户激活失败！\r\n更新组织内容失败！", "消息", MessageBoxButtons.OK, MessageBoxIcon.Error);
DBManager.RollBackTransaction(DBCONFIG.Coeus);
return;
}
}
else
{
var argsorg = new MDLSM_Organization
{
Org_Code = org.Org_Code,
Org_FullName = org.Org_FullName,
Org_ShortName = org.Org_ShortName,
Org_Contacter = org.Org_Contacter,
Org_TEL = org.Org_TEL,
Org_PhoneNo = org.Org_PhoneNo,
Org_Prov_Code = org.Org_Prov_Code,
Org_City_Code = org.Org_City_Code,
Org_Dist_Code = org.Org_Dist_Code,
Org_Addr = org.Org_Addr,
Org_Remark = org.Org_Remark,
Org_PlatformCode = jsonResult["MCT_Code"].ToString(),
Org_IsValid = true
};
boolTemp = bll.Save <MDLSM_Organization>(argsorg);
if (!boolTemp)
{
MessageBoxs.Show(Trans.COM, this.ToString(), "商户激活失败！\r\n新增组织失败！", "消息", MessageBoxButtons.OK, MessageBoxIcon.Error);
DBManager.RollBackTransaction(DBCONFIG.Coeus);
return;
}
}
}
#endregion
}
#endregion
#region 更新参数表
var argsParameterQuery = new MDLSM_Parameter
{
Para_Code1 = "1001",
Para_IsValid = true
};
var parameterResult = new MDLSM_Parameter();
bll.QuerryForObject <MDLSM_Parameter, MDLSM_Parameter>(argsParameterQuery, parameterResult);
parameterResult.Para_Code1 = "1001";
parameterResult.Para_Name1 = "商户编码";
parameterResult.Para_Value1 = jsonResult["MCT_Code"] == null
? ""
: jsonResult["MCT_Code"].ToString();
;
boolTemp = bll.Save <MDLSM_Parameter>(parameterResult);
if (!boolTemp)
{
MessageBoxs.Show(Trans.COM, this.ToString(), "商户激活失败！\r\n更新系统参数（商户编码）失败！", "消息", MessageBoxButtons.OK, MessageBoxIcon.Error);
DBManager.RollBackTransaction(DBCONFIG.Coeus);
return;
}
#endregion
DBManager.CommitTransaction(DBCONFIG.Coeus);
}
catch (Exception ex)
{
MessageBoxs.Show(Trans.COM, this.ToString(), "商户激活失败！\r\n" + ex.Message, "消息", MessageBoxButtons.OK, MessageBoxIcon.Error);
DBManager.RollBackTransaction(DBCONFIG.Coeus);
return;
}
}
else
{
var strErrorMessage = jsonResult["ResultMsg"] == null ? "" : jsonResult["ResultMsg"].ToString();
MessageBoxs.Show(Trans.COM, this.ToString(), "商户激活失败！\r\n" + strErrorMessage, "消息", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
#endregion
MessageBoxs.Show(Trans.COM, this.ToString(), "恭喜！您已成功激活本系统！\r\n", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
var loginWindow = new FrmLogin();
loginWindow.Show();
this.Hide();
}
/// <summary>
/// 从平台同步组织信息到本地数据库
/// </summary>
/// <returns></returns>
public static bool SynchronizeOrgInfo()
{
var funcName = "SynchronizeOrgInfo";
LogHelper.WriteBussLogStart(Trans.COM, LoginInfoDAX.UserName, funcName, "", "", null);
//根据商户编码和产品编码来查询组织信息
string argsPostData = string.Format(ApiParameter.BF0002,
ConfigurationManager.AppSettings[AppSettingKey.MCT_CODE], SysConst.ProductCode);
string strApiData = APIDataHelper.GetAPIData(ApiUrl.BF0002Url, argsPostData);
var jsonResult = (JObject)JsonConvert.DeserializeObject(strApiData);
if (jsonResult != null && jsonResult["ResultCode"].ToString().Equals("I0001"))
{
var argsSettingKeyMctCode1 = jsonResult["ListOrganization"];
var platformOrgJson = (JArray)JsonConvert.DeserializeObject(argsSettingKeyMctCode1.ToString());
var localOrgList = new List <MDLSM_Organization>();
_bllBase.QuerryForList(new MDLSM_Organization {
WHERE_Org_IsValid = true
}, localOrgList);
var invalidOrgList = new List <MDLSM_Organization>();
_bllBase.CopyModelList(localOrgList, invalidOrgList);
//从无效列表中移除在平台上有效的组织
foreach (var json in platformOrgJson)
{
var validOrgList = invalidOrgList.Where(p => p.Org_Code == json["Org_Code"].ToString()).ToList();
if (validOrgList.Count > 0)
{
invalidOrgList.Remove(validOrgList[0]);
}
}
try
{
DBManager.BeginTransaction(DBCONFIG.Coeus);
if (invalidOrgList.Count > 0)
{
foreach (var model in invalidOrgList)
{
model.WHERE_Org_ID = model.Org_ID;
model.Org_IsValid = false;
bool save = _bllBase.Save <MDLSM_Organization>(model);
if (!save)
{
DBManager.RollBackTransaction(DBCONFIG.Coeus);
LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, "同步组织失败！", "", null);
return(false);
}
}
}
var orgList = new List <MDLSM_Organization>();
foreach (var json in platformOrgJson)
{
var argsorg = new MDLSM_Organization();
var sameOrgList = localOrgList.Where(p => p.Org_Code == json["Org_Code"].ToString()).ToList();
if (sameOrgList.Count > 0)
{
argsorg = sameOrgList[0];
}
argsorg.WHERE_Org_ID = argsorg.Org_ID;
argsorg.Org_Code = json["Org_Code"].ToString();
argsorg.Org_FullName = json["Org_FullName"].ToString();
argsorg.Org_ShortName = json["Org_ShortName"].ToString();
argsorg.Org_Contacter = json["Org_Contacter"].ToString();
argsorg.Org_TEL = json["Org_TEL"].ToString();
argsorg.Org_PhoneNo = json["Org_PhoneNo"].ToString();
argsorg.Org_Prov_Code = json["Org_Prov_Code"].ToString();
argsorg.Org_City_Code = json["Org_City_Code"].ToString();
argsorg.Org_Dist_Code = json["Org_Dist_Code"].ToString();
argsorg.Org_Addr = json["Org_Addr"].ToString();
argsorg.Org_Longitude = json["Org_Longitude"].ToString();
argsorg.Org_Latitude = json["Org_Latitude"].ToString();
argsorg.Org_MarkerTitle = json["Org_MarkerTitle"].ToString();
argsorg.Org_MarkerContent = json["Org_MarkerContent"].ToString();
argsorg.Org_Remark = json["Org_Remark"].ToString();
//Org_MCT_ID 作为MCT_Code来存放
argsorg.Org_MCT_ID = ConfigurationManager.AppSettings[AppSettingKey.MCT_CODE] ?? string.Empty;
argsorg.Org_CreatedBy = argsorg.Org_UpdatedBy = "系统同步";
argsorg.Org_IsValid = true;
bool save = _bllBase.Save <MDLSM_Organization>(argsorg);
if (!save)
{
DBManager.RollBackTransaction(DBCONFIG.Coeus);
LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, "同步组织失败！", "", null);
return(false);
}
orgList.Add(argsorg);
}
DBManager.CommitTransaction(DBCONFIG.Coeus);
LoginInfoDAX.OrgList = new List <MDLSM_Organization>(orgList);
}
catch (Exception ex)
{
DBManager.RollBackTransaction(DBCONFIG.Coeus);
LogHelper.WriteErrorLog(Trans.COM, "ExecuteSyncCommand", ex.Message, null, ex);
LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, ex.Message, "", null);
return(false);
}
}
else
{
var strErrorMessage = jsonResult == null ? "" : jsonResult["ResultMsg"].ToString();
LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, strErrorMessage, "", null);
}
LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, "", "", null);
return(true);
}
