| public static ToDescription ( Enum value ) : string | ||
| value | Enum | |
| Résultat | string | |
/// <summary>
/// 生成流水信息,并更新付款单的最新流水信息号
/// </summary>
public void GenerateFlowOrders()
{
try
{
#region 生成流水信息
T_Pay_Info_DetailsEntity payDetailsEntity = new T_Pay_Info_DetailsEntity()
{
Amount = this.operationAmount,
Createtime = DateTime.Now,
PayInfoDetailsCode = CodeNumber,
Details_Name = EnumHelper.ToDescription(PayDetailsTypeEnum.Consumption),
Details_Type = (int)PayDetailsTypeEnum.Consumption,
EcommerceGroupID = inputPayEntity.EcommerceGroupID,
EcommerceGroupName = this.EcommerceProjectMoneyCapacity.EcommerceGroupName,
Electricity_Supplier_Code = inputPayEntity.Electricity_Supplier_Code,
Electricity_Supplier_Id = inputPayEntity.EcommerceID,
Electricity_Supplier_Name = inputPayEntity.Electricity_Supplier_Name,
Pay_Info_Code = inputPayEntity.Pay_Info_Code,
Pay_Info_Details_ID = Guid.NewGuid().ToString(),
Pay_Info_ID = inputPayEntity.Pay_Info_Id,
Project_Code = inputPayEntity.Project_Code,
Project_ID = inputPayEntity.Project_Id,
Project_Name = inputPayEntity.Project_Name,
};
Transdb.Insert(payDetailsEntity);
inputPayEntity.LastPayInfoDetailsCode = CodeNumber;
Transdb.Update(inputPayEntity);
#endregion
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public TestWorkRow()
{
Index = 0;
ItemType = ETestItemType.Both;
ItemCode = ETestItemCode.VF;
ItemName = EnumHelper.ToDescription(ItemCode);
ItemRef = "None";
TestPattern = "None(0)";
BiasCH = "None";
BiasValue = "None";
BiasRange = "None";
ApplyTime = 0;
TransientTime = 0;
HumCounter = 0;
Optical = EOpticalType.None;
IntegVL = 0.0001;
IntegX1 = 0.0001;
IntegX2 = 0.0001;
IntegZ = 0.0001;
Gain = 1;
Offset = 0;
LvGain = 1;
LvOffset = 0;
CxGain = 1;
CxOffset = 0;
CyGain = 1;
CyOffset = 0;
}
public ReportWorkRow()
{
Index = 0;
ItemCode = EReportItemCode.VF;
ItemName = EnumHelper.ToDescription(ItemCode);
ItemRef = "None";
BiasCH = "None";
Rank = "None(0)";
}
public void TestEnumsMethod1()
{
foreach (PizzaTopping.PizzaToppingType toppingType in Enum.GetValues(typeof(PizzaTopping.PizzaToppingType)))
{
Debug.Print(@" topping type ${toppingType.ToString()}");
String description = EnumHelper.ToDescription(toppingType);
Debug.Print(@" topping type description ${description}");
}
}
/// <summary>
/// 接口调用日志
/// </summary>
/// <param name="RequestContent">入参</param>
/// <param name="ResponseContent">出参</param>
/// <param name="InterfaceName">接口名称</param>
/// <param name="type">1:成功 -1失败</param>
/// <param name="ReqisetSystem">调用系统</param>
/// <param name="ReceivingSystem">接收系统</param>
/// <param name="ErrMsg">错误信息</param>
/// <param name="Url">请求地址</param>
public static void WriteLogInterface(string RequestContent,
string ResponseContent,
string InterfaceName,
int type,
string ReqisetSystem,
string ReceivingSystem,
string ErrMsg,
string Method = "",
string Url = ""
)
{
try
{
if (string.IsNullOrEmpty(Url))
{
Url = Net.Url;
}
LogEntity logEntity = new LogEntity();
logEntity.Module = InterfaceName;
logEntity.CategoryId = 6;
logEntity.IPAddress = Url;
logEntity.Host = Method;//作为请求方式
logEntity.OperateTime = DateTime.Now;
logEntity.OperateTypeId = ((int)OperationType.Interface).ToString();
logEntity.OperateType = EnumHelper.ToDescription(OperationType.Interface);
logEntity.ExecuteResult = type; //1:成功 2:失败
logEntity.ExecuteResultJson = RequestContent; //请求内容
logEntity.IPAddressName = ResponseContent; //这里暂时作为 返回内容
logEntity.Description = ErrMsg;
logEntity.DeleteMark = 0;
logEntity.SourceObjectId = ReqisetSystem; //请求系统
logEntity.SourceContentJson = ReceivingSystem; //目标系统
service.WriteLogInterface(logEntity);
LogMessage logMessage = new LogMessage();
logMessage.Url = Url;
logMessage.Browser = ReqisetSystem;
logMessage.Host = ReceivingSystem;
logMessage.RemarkOne = RequestContent;
logMessage.RemarkTwo = ResponseContent;
logMessage.ExceptionRemark = ErrMsg;
//if (type == 2)
//{
// string strMessage = new LogFormat().InterfaceFormat(logMessage);
// SendMail(strMessage);
//}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// An enum with flags
/// </summary>
public static DataSet <T> ForFlagsEnum <T>(Core core, string title)
where T : struct, IComparable, IFormattable, IConvertible // aka. Enum
{
return(new DataSet <T>()
{
Core = core,
ListTitle = title,
ListSource = EnumHelper.GetEnumFlags <T>(),
ItemTitle = z => EnumHelper.ToUiString((Enum)(object)z),
ItemDescription = z => EnumHelper.ToDescription((Enum)(object)z),
StringComparator = _EnumComparator <T>,
});
}
/// <summary>
/// Outputs this instance as a GEDCOM record.
/// </summary>
/// <param name="tw">The writer to output to.</param>
public override void Output(TextWriter tw)
{
tw.WriteLine();
tw.Write(Util.IntToString(Level));
tw.Write(" SLGS ");
if (!string.IsNullOrEmpty(Description))
{
tw.Write(Description);
}
if (date != null)
{
date.Output(tw);
}
if (place != null)
{
place.Output(tw);
}
var levelPlusOne = Util.IntToString(Level + 1);
if (!string.IsNullOrWhiteSpace(templeCode))
{
tw.WriteLine();
tw.Write(levelPlusOne);
tw.Write(" TEMP ");
tw.Write(templeCode);
}
if (status != SpouseSealingDateStatus.NotSet)
{
tw.WriteLine();
tw.Write(levelPlusOne);
tw.Write(" STAT ");
tw.Write(EnumHelper.ToDescription(status));
if (StatusChangeDate != null)
{
var levelPlusTwo = Util.IntToString(Level + 2);
tw.Write(Environment.NewLine);
tw.Write(levelPlusTwo);
tw.Write(" CHAN ");
StatusChangeDate.Output(tw);
}
}
OutputStandard(tw);
}
/// <summary>
/// An enum without flags
/// </summary>
public static DataSet <T> ForDiscreteEnum <T>(Core core, string title, T cancelValue)
where T : struct, IComparable, IFormattable, IConvertible // aka. Enum
{
return(new DataSet <T>()
{
Core = core,
ListTitle = title,
ListSource = Enum.GetValues(typeof(T)).Cast <T>().Except(new T[] { cancelValue }),
ItemTitle = z => EnumHelper.ToUiString((Enum)(object)z),
ItemDescription = z => EnumHelper.ToDescription((Enum)(object)z),
StringComparator = _EnumComparator <T>,
CancelValue = cancelValue,
});
}
public void EnumDescriptionAttribute_ResourceKey_multiDistrict()
{
Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("en-US");
string result = TestResource.Orange.ToDescription();
Assert.AreEqual(Resource1.String2, result);
Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("zh-CN");
Resource1.Culture = Thread.CurrentThread.CurrentCulture;
result = TestResource.Orange.ToDescription();
Assert.AreEqual(Resource1.String2, result);
Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("zh-TW");
Resource1.Culture = Thread.CurrentThread.CurrentCulture;
result = EnumHelper.ToDescription(TestResource.Apple, CultureInfo.GetCultureInfo("zh-TW"));
Assert.AreEqual(Resource1.String1, result);
}
private void Control_DrawItem(object sender, DrawItemEventArgs e)
{
var cb = (ComboBox)sender;
e.DrawBackground();
if (e.Index != -1)
{
string text = cb.Items[e.Index].ToString();
using (SolidBrush b = new SolidBrush(e.ForeColor))
{
if (!e.State.Has(DrawItemState.ComboBoxEdit))
{
switch (e.Index)
{
case 0:
text = EnumHelper.ToDescription(EAxisRange.Automatic);
break;
case 1:
text = EnumHelper.ToDescription(EAxisRange.General);
break;
case 2:
text = EnumHelper.ToDescription(EAxisRange.Fixed);
break;
}
}
e.Graphics.DrawString(text, e.Font, b, e.Bounds);
}
}
e.DrawFocusRectangle();
}
public JsonResult ApplyWithDrawList(ApplyWithDrawInfo.ApplyWithDrawStatus capitalType, UserWithdrawType?applyType, string withdrawno, string user, int page, int rows)
{
IMemberCapitalService memberCapitalService = this._iMemberCapitalService;
IMemberService memberService = this._iMemberService;
long?nullable = new long?();
if (!string.IsNullOrWhiteSpace(user))
{
UserMemberInfo userMemberInfo = memberService.GetMemberByName(user);
if (userMemberInfo == null)
{
userMemberInfo = new UserMemberInfo()
{
Id = 0L
}
}
;
nullable = new long?(userMemberInfo.Id);
}
ApplyWithDrawQuery applyWithDrawQuery = new ApplyWithDrawQuery();
applyWithDrawQuery.memberId = nullable;
applyWithDrawQuery.ApplyType = applyType;
applyWithDrawQuery.PageSize = rows;
applyWithDrawQuery.PageNo = page;
applyWithDrawQuery.withDrawStatus = new ApplyWithDrawInfo.ApplyWithDrawStatus?(capitalType);
ApplyWithDrawQuery query = applyWithDrawQuery;
if (!string.IsNullOrWhiteSpace(withdrawno))
{
query.withDrawNo = new long?(long.Parse(withdrawno));
}
ObsoletePageModel <ApplyWithDrawInfo> applyWithDraw = memberCapitalService.GetApplyWithDraw(query);
IEnumerable <ApplyWithDrawModel> enumerable = Enumerable.Select <ApplyWithDrawInfo, ApplyWithDrawModel>((IEnumerable <ApplyWithDrawInfo>)Enumerable.ToList <ApplyWithDrawInfo>((IEnumerable <ApplyWithDrawInfo>)applyWithDraw.Models), (Func <ApplyWithDrawInfo, ApplyWithDrawModel>)(e =>
{
string str = EnumHelper.ToDescription((Enum)e.ApplyStatus);
UserMemberInfo member = memberService.GetMember(e.MemId);
return(new ApplyWithDrawModel()
{
Id = e.Id,
ApplyAmount = e.ApplyAmount,
ApplyStatus = e.ApplyStatus,
ApplyStatusDesc = str,
ApplyTime = e.ApplyTime.ToString(),
NickName = e.NickName,
MemberName = member.UserName,
ConfirmTime = e.ConfirmTime.ToString(),
MemId = e.MemId,
OpUser = e.OpUser,
PayNo = e.PayNo,
PayTime = e.PayTime.ToString(),
Remark = e.Remark
});
}));
return(this.Json((object)new DataGridModel <ApplyWithDrawModel>()
{
rows = enumerable,
total = applyWithDraw.Total
}));
}
public void TestMethod2()
{
String pizaBaseTypeStr = EnumHelper.ToDescription(PizzaBase.PizzaBaseType.REGULAR);
Assert.AreEqual("Regular", pizaBaseTypeStr);
}
private static void ExprotContract()
{
SqlConnection conn = new SqlConnection("Server=.;Initial Catalog=E_Commerce_DB;User ID=sa;Password=dq123456");
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append(@"select * from Test003 ");
conn.Open();
SqlCommand comm = new SqlCommand(sqlstr.ToString(), conn);
SqlDataReader sdr = comm.ExecuteReader();
contractEntity list = new contractEntity();
List <contractEntity> conlists = new List <contractEntity>();
while (sdr.Read())
{
list = new contractEntity
{
projectname = sdr[0].ToString(),
ecommercename = sdr[1].ToString(),
ecommercegroupname = sdr[2].ToString(),
platfromrate = Convert.ToDecimal(sdr[3]),
contractname = sdr[4].ToString(),
ControllerAmount = Convert.ToDecimal(sdr[5]),
FlowAmount = Convert.ToDecimal(sdr[6]),
ActualControllerAmount = Convert.ToDecimal(sdr[7])
};
conlists.Add(list);
if (!sdr.HasRows)
{
list = new contractEntity
{
projectname = "",
};
conlists.Add(list);
}
}
sdr.Close();
conn.Close();
Base_ProjectInfoBLL bpbbll = new Base_ProjectInfoBLL();
EcommerceBLL ecombll = new EcommerceBLL();
EcommerceGroupBLL ecomgroupbll = new EcommerceGroupBLL();
List <EcommerceGroupEntity> ecomgrouplists = new List <EcommerceGroupEntity>();
List <EcommerceEntity> ecomlists = new List <EcommerceEntity>();
List <EcommerceProjectRelationEntity> ecomprorelists = new List <EcommerceProjectRelationEntity>();
int count = 0;
foreach (var item in conlists)
{
count++;
var data = bpbbll.GetList("").ToList().Where(t => t.ProjecName == item.projectname).ToList();
if (data.Count == 0)
{
Console.WriteLine("找不到对应的项目数据'" + item.projectname + "'");
Console.ReadKey();
return;
}
EcommerceProjectRelationEntity ecom = new EcommerceProjectRelationEntity();
ecom.EcommerceProjectRelationID = Guid.NewGuid().ToString();
var ecomgroupdata = ecomgroupbll.GetList("").Where(t => t.EcommerceGroupName == item.ecommercegroupname).ToList();
if (ecomgroupdata.Count == 0)
{
EcommerceGroupEntity ecomgroupentity = new EcommerceGroupEntity();
ecomgroupentity.EcommerceGroupID = Guid.NewGuid().ToString();
ecomgroupentity.EcommerceGroupName = item.ecommercegroupname;
ecomgroupentity.DeleteMark = 0;
var t2 = new SqlDatabase("BaseDb").Connection.Insertable(ecomgroupentity).ExecuteCommand();
//if (!ecomgrouplists.Any(t => t.EcommerceGroupName == ecomgroupentity.EcommerceGroupName))
//{
// ecomgrouplists.Add(ecomgroupentity);
//}
EcommerceEntity ecomentity = new EcommerceEntity();
ecomentity.EcommerceName = item.ecommercename;
ecomentity.EcommerceID = Guid.NewGuid().ToString();
ecomentity.EcommerceGroupID = ecomgroupentity.EcommerceGroupID;
ecomentity.EcommerceCode = count.ToString();
ecomentity.EcommerceGroupName = ecomgroupentity.EcommerceGroupName;
ecomentity.DeleteMark = 0;
ecomentity.EcommerceType = 0;
ecomentity.PlatformRate = item.platfromrate;
ecomentity.CooperateStartTime = Convert.ToDateTime("2018-01-01");
ecomentity.CooperateEndTime = Convert.ToDateTime("2018-06-30");
var t3 = new SqlDatabase("BaseDb").Connection.Insertable(ecomentity).ExecuteCommand();
//if (!ecomlists.Any(t => t.EcommerceName == ecomentity.EcommerceName))
//{
// ecomlists.Add(ecomentity);
//}
ecom.EcommerceGroupID = ecomgroupentity.EcommerceGroupID;
ecom.EcommerceGroupName = ecomgroupentity.EcommerceGroupName;
ecom.EcommerceID = ecomentity.EcommerceID;
ecom.EcommerceName = ecomentity.EcommerceName;
ecom.EcommerceCode = ecomentity.EcommerceCode;
ecom.PartyB = ecomentity.EcommerceName;
}
else
{
ecom.EcommerceGroupID = ecomgroupdata[0].EcommerceGroupID;
ecom.EcommerceGroupName = ecomgroupdata[0].EcommerceGroupName;
var ecomdata = ecombll.GetList("").Where(t => t.EcommerceName == item.ecommercename).ToList();
if (ecomdata.Count == 0)
{
EcommerceEntity ecomentity = new EcommerceEntity();
ecomentity.EcommerceName = item.ecommercename;
ecomentity.EcommerceID = Guid.NewGuid().ToString();
ecomentity.EcommerceCode = count.ToString();
ecomentity.EcommerceGroupID = ecomgroupdata[0].EcommerceGroupID;
ecomentity.EcommerceGroupName = ecomgroupdata[0].EcommerceGroupName;
ecomentity.PlatformRate = item.platfromrate;
ecomentity.DeleteMark = 0;
ecomentity.EcommerceType = 0;
ecomentity.CooperateStartTime = Convert.ToDateTime("2018-01-01");
ecomentity.CooperateEndTime = Convert.ToDateTime("2018-06-30");
var t3 = new SqlDatabase("BaseDb").Connection.Insertable(ecomentity).ExecuteCommand();
//if (!ecomlists.Any(t => t.EcommerceName == ecomentity.EcommerceName))
//{
// ecomlists.Add(ecomentity);
//}
ecom.EcommerceGroupID = ecomentity.EcommerceGroupID;
ecom.EcommerceGroupName = ecomentity.EcommerceGroupName;
ecom.EcommerceID = ecomentity.EcommerceID;
ecom.EcommerceName = ecomentity.EcommerceName;
ecomentity.EcommerceCode = ecomentity.EcommerceCode;
ecom.PartyB = ecomentity.EcommerceName;
}
else
{
ecom.EcommerceID = ecomdata[0].EcommerceID;
ecom.EcommerceName = ecomdata[0].EcommerceName;
ecom.EcommerceCode = ecomdata[0].EcommerceCode;
ecom.PartyB = ecomdata[0].EcommerceName;
}
}
ecom.PlatformRate = item.platfromrate;
ecom.ContractName = item.contractname;
ecom.EcommerceType = 0;
ecom.EcommerceTypeName = EnumHelper.ToDescription((EcommerceTypeEnum)0);
ecom.Agent = "金涛";
ecom.CooperateStartTime = Convert.ToDateTime("2018-01-01");
ecom.CooperateEndTime = Convert.ToDateTime("2018-06-30");
ecom.ForceContractAmount = 100000;
ecom.DeleteMark = 0;
ecom.CityCode = data[0].CityCode;
ecom.CityID = data[0].CityID;
ecom.CityName = data[0].CityName;
ecom.ProjectID = data[0].ProjectID;
ecom.ProjectCode = data[0].ProjectCode;
ecom.ProjecName = item.projectname;
ecom.CompanyId = data[0].CompanyCode;
ecom.CompanyCode = data[0].CompanyCode;
ecom.CompanyName = data[0].CompanyName;
ecom.ProjectType = 0;
ecom.ApprovalState = 4;
ecom.FlowNopayTotalAmount = 0;
ecom.ContractNature = 0;
ecom.IsStandard = 1;
ecom.PartyA = "阳光城集团股份有限公司";
ecom.BiddingMethod = 0;
ecom.IsStamp = 1;
ecom.ContractTypeName = "主合同";
ecom.CreateDate = Convert.ToDateTime("2018-06-30");
ecom.ControlTotalAmount = item.ControllerAmount * 0;
ecom.FlowNopayTotalAmount = item.FlowAmount * 10000;
ecom.ActualControlTotalAmount = item.ActualControllerAmount * 10000;
ecom.IsTrunk = 1;
if (!ecomprorelists.Any(t => t.EcommerceID == ecom.EcommerceID && t.ProjectID == ecom.ProjectID))
{
ecomprorelists.Add(ecom);
}
}
var t1 = new SqlDatabase("BaseDb").Connection.Insertable(ecomprorelists).ExecuteCommand();
//var t2 = new SqlDatabase("BaseDb").Connection.Insertable(ecomgrouplists).ExecuteCommand();
//var t3 = new SqlDatabase("BaseDb").Connection.Insertable(ecomlists).ExecuteCommand();
Console.ReadKey();
}
public PaymentResult()
{
Identifier = Guid.NewGuid();
status = EnumHelper.ToDescription(EnumHelperPaymentStatus.Sucsucceed);
}
/// <summary>
/// Construit le contenu selon la valeur de l'énumération
/// </summary>
/// <param name="value"></param>
public EnumDTO(TEnum value)
{
this.Key = value.ToInt32(CultureInfo.CurrentCulture);
this.Value = Enum.GetName(typeof(TEnum), value);
this.Description = EnumHelper.ToDescription(value);
}
public override object Execute()
{
string EProjectRelationId = this._context.strBOID;//合同ID
EcommerceProjectRelationEntity ecommerceprojectrelationEntity = eprBll.GetEntity(EProjectRelationId);
OP_ParcelEntity op_parcelEntity = op_parcelbll.GetEntityByproid(ecommerceprojectrelationEntity.ProjectID);
IEnumerable <EcommerceDiscountProgramEntity> discount = edpbll.GetEntity(EProjectRelationId);
List <T_AttachmentEntity> attaclist = tabll.GetFormList(EProjectRelationId, "default");
ContractView cv = new ContractView();
List <ITEM> its = new List <ITEM>();
List <ATTACHMENT1> attcs = new List <ATTACHMENT1>();
cv.ProjectName = ecommerceprojectrelationEntity.ProjecName;
cv.ProjCode = op_parcelEntity.ParcelCode.Replace("-", ".");
cv.ProjectType = EnumHelper.ToDescription((ProjectTypeEnum)ecommerceprojectrelationEntity.ProjectType);
cv.OrgName = ecommerceprojectrelationEntity.CompanyName;
cv.OrgCode = ecommerceprojectrelationEntity.CompanyId;
cv.EcommerceGroupName = ecommerceprojectrelationEntity.EcommerceGroupName;
cv.EcommerceTypeName = ecommerceprojectrelationEntity.EcommerceTypeName;
cv.ContractName = ecommerceprojectrelationEntity.ContractName;
cv.ContractNature = EnumHelper.ToDescription((ContractNatureEnum)ecommerceprojectrelationEntity.ContractNature);
cv.ContractTypeName = ecommerceprojectrelationEntity.ContractTypeName;
cv.IsStandard = ecommerceprojectrelationEntity.IsStandard == 0?"否":"是";
cv.PartyA = ecommerceprojectrelationEntity.PartyA;
cv.PartyB = ecommerceprojectrelationEntity.PartyB;
cv.CooperateStartTime = Convert.ToDateTime(ecommerceprojectrelationEntity.CooperateStartTime).ToString("yyyy-MM-dd");
cv.CooperateEndTime = Convert.ToDateTime(ecommerceprojectrelationEntity.CooperateEndTime).ToString("yyyy-MM-dd");
cv.BiddingMethod = EnumHelper.ToDescription((BiddingMethodEnum)ecommerceprojectrelationEntity.BiddingMethod);
cv.IsStamp = ecommerceprojectrelationEntity.IsStamp == 0?"否":"是";
cv.Agent = ecommerceprojectrelationEntity.Agent;
cv.CreateDate = Convert.ToDateTime(ecommerceprojectrelationEntity.CreateDate).ToString("yyyy-MM-dd");
cv.ForceContractAmount = ecommerceprojectrelationEntity.ForceContractAmount;
cv.PlatformRate = ecommerceprojectrelationEntity.PlatformRate;
foreach (var item in discount)
{
ITEM it = new ITEM();
it.Format = item.Format;
it.Amount = item.Amount;
it.Discount = item.Discount;
if (!its.Contains(it))
{
its.Add(it);
}
}
cv.BDITEM = new BDITEM();
cv.BDITEM.item = its.ToArray();
var geturl = dataItemCache.GetDataItemByCodeAndName("SysConfig", "BPMAttacPath");
string urlname = geturl.ItemValue;
foreach (var item in attaclist)
{
ATTACHMENT1 attc = new ATTACHMENT1();
attc.FILENAME = item.AttachmentName;
attc.URL = string.Format("{0}/{1}", urlname, item.Path);
if (!attcs.Contains(attc))
{
attcs.Add(attc);
}
}
cv.ATTACHMENT = new ATTACHMENT();
cv.ATTACHMENT.attachment = attcs.ToArray();
var d = Movit.Util.XmlHelper.Serializer(typeof(ContractView), cv);
return(d);
//XmlDocument doc = new XmlDocument();
//XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", "utf-16", null);
//doc.AppendChild(dec);
////创建一个根节点（一级）
//XmlNode root = doc.CreateElement("DATA");
//doc.AppendChild(root);
////创建节点（二级）
//XmlElement ITEM = null;
//XmlElement element = null;
////合同编号
//element = doc.CreateElement("ProjectName");
//element.SetAttribute("Text", "项目名称");
//element.InnerText = ecommerceprojectrelationEntity.EcommerceProjectRelationID;
////项目名称
//element = doc.CreateElement("CompanyName");
//element.SetAttribute("Text", "所属区域");
//element.InnerText = ecommerceprojectrelationEntity.ProjectName;
//root.AppendChild(element);
//ITEM = doc.CreateElement("优化方案Items");
//ITEM.SetAttribute("ID", "BudgetItem");
//root.AppendChild(ITEM);
//foreach (var item in tcollection)
//{
// XmlNode item = doc.CreateElement("item");
// //创建节点（三级）
// element = null;
// //集团/地区公司GUID
// element = doc.CreateElement("OrgUnitGUID");
// element.SetAttribute("Text", "集团/地区公司");
// element.InnerText = "三级节点数据";
// item.AppendChild(element);
//}
//return XmlHelper.ConvertXmlToString(doc);
}
public ActionResult GetPayListForExport(string queryJson, Pagination pagination)
{
var data = pay_infobll.GetList(queryJson).ToList();
for (int i = 0; i < data.Count; i++)
{
data[i].Pay_Money = Convert.ToDecimal(String.Format("{0:F}", data[i].Pay_Money));
}
DataTable dt = DataHelper.ListToDataTable <Pay_InfoEntity>(data);
DataTable dtnew = dt.DefaultView.ToTable(false, new string[] { "CompanyName", "Project_Name", "EcommerceGroupName", "Electricity_Supplier_Name",
"Pay_Info_Code", "Contract_Name", "Pay_Money", "Pay_Createtime",
"Pay_Completetime", "Login_Name", "Approval_Status" });
for (int i = 0; i < dtnew.Rows.Count; i++)
{
dtnew.Rows[i]["Approval_Status"] = EnumHelper.ToDescription((ApproveStatus)Convert.ToInt32(dtnew.Rows[i]["Approval_Status"]));
}
//设置导出格式
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.Title = "付款台账记录";
excelconfig.TitleFont = "微软雅黑";
excelconfig.TitlePoint = 25;
excelconfig.FileName = "付款台账记录.xls";
excelconfig.IsAllSizeColumn = true;
//每一列的设置,没有设置的列信息，系统将按datatable中的列名导出
List <ColumnEntity> listColumnEntity = new List <ColumnEntity>();
excelconfig.ColumnEntity = listColumnEntity;
ColumnEntity columnentity = new ColumnEntity();
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "CompanyName", ExcelColumn = "区域公司"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Project_Name", ExcelColumn = "项目名称"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "EcommerceGroupName", ExcelColumn = "电商简称"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Electricity_Supplier_Name", ExcelColumn = "电商名称"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Pay_Info_Code", ExcelColumn = "支付流序号"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Contract_Name", ExcelColumn = "合同名称"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Pay_Money", ExcelColumn = "付款金额(元)"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Pay_Createtime", ExcelColumn = "支付流程发起时间"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Pay_Completetime", ExcelColumn = "支付流程审批通过时间"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Login_Name", ExcelColumn = "经办人"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Approval_Status", ExcelColumn = "审批状态"
});
//调用导出方法
ExcelHelper.ExcelDownload(dtnew, excelconfig);
return(Success(""));
}
