/// <summary>
/// 修改节假日
/// </summary>
/// <param name="Hliday">节假日信息</param>
/// <param name="LoginId">管理员登陆标识</param>
/// <returns>修改结果</returns>
public ResultDesc ModifyHoliday(DateHoliday Hliday, string LoginId)
{
ResultDesc rsdc = new ResultDesc();
string operUser = string.Empty;//操作人
try
{
TradeUser TdUser = new TradeUser();
#region 判断登陆标识是否过期
if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser))
{
rsdc.Result = false;
rsdc.Desc = ResCode.UL003Desc;
return rsdc;
}
if (UserType.NormalType == TdUser.UType)
{
rsdc.Result = false;
rsdc.Desc = ComFunction.NotRightUser;
return rsdc;
}
operUser = TdUser.Account;
#endregion
List<string> sqlList = new List<string>();
StringBuilder strbld = new StringBuilder();
strbld.AppendFormat("update Trade_HolidayEx set ");
strbld.AppendFormat("Starttime='{0}',", Hliday.Starttime);
strbld.AppendFormat("Endtime='{0}',", Hliday.Endtime);
strbld.AppendFormat("[Desc]='{0}',", Hliday.Desc);
strbld.AppendFormat("HoliName='{0}',", Hliday.HoliName);
strbld.AppendFormat("pricecode='{0}' ", Hliday.PriceCode);
strbld.AppendFormat(" where ID='{0}'", Hliday.ID);
sqlList.Add(strbld.ToString());
string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac);
sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')",
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType,
string.Format("{3}修改节假日:{0},{1}-{2}", Hliday.ID, Hliday.Starttime, Hliday.Endtime, ipmac)));
if (!ComFunction.SqlTransaction(sqlList))
{
rsdc.Result = false;
rsdc.Desc = "修改节假日出错";
return rsdc;
}
if ("1" == ComFunction.InterType)
{
ComFunction.ModifyHoliday(Hliday);
}
rsdc.Result = true;
//rsdc.Desc = "修该节假日成功";
rsdc.Desc = strbld.ToString();
}
catch (Exception ex)
{
ComFunction.WriteErr(ex);
rsdc.Result = false;
rsdc.Desc = "修改节假日失败";
}
return rsdc;
}
/// <summary>
/// 获取交易日信息列表
/// </summary>
/// <param name="sql">查询SQL</param>
/// <returns>交易日信息列表</returns>
public static List<WcfInterface.model.DateHoliday> GetDateHolidayList(string sql)
{
System.Data.Common.DbDataReader dbreader = null;
List<WcfInterface.model.DateHoliday> list = new List<WcfInterface.model.DateHoliday>();
try
{
dbreader = DbHelper.ExecuteReader(sql);
while (dbreader.Read())
{
WcfInterface.model.DateHoliday dateHoliday = new WcfInterface.model.DateHoliday();
dateHoliday.HoliName = dbreader["HoliName"].ToString();
dateHoliday.Starttime = Convert.ToDateTime(dbreader["Starttime"]);
dateHoliday.Endtime = Convert.ToDateTime(dbreader["Endtime"]);
dateHoliday.PriceCode = dbreader["pricecode"].ToString();
dateHoliday.Desc = dbreader["Desc"].ToString();
dateHoliday.ID = dbreader["ID"].ToString();
list.Add(dateHoliday);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
if (null != dbreader)
{
dbreader.Close();
dbreader.Dispose();
}
}
return list;
}
/// <summary>
/// 添加节假日
/// </summary>
/// <param name="Hliday">节假日信息</param>
/// <param name="LoginId">管理员登陆标识</param>
/// <param name="ID">返回ID</param>
/// <returns>添加结果</returns>
public ResultDesc AddHoliday(DateHoliday Hliday, string LoginId, ref string ID)
{
ResultDesc rsdc = new ResultDesc();
string operUser = string.Empty;//操作人
try
{
TradeUser TdUser = new TradeUser();
#region 判断登陆标识是否过期
if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser))
{
rsdc.Result = false;
rsdc.Desc = ResCode.UL003Desc;
return rsdc;
}
if (UserType.NormalType == TdUser.UType)
{
rsdc.Result = false;
rsdc.Desc = ComFunction.NotRightUser;
return rsdc;
}
operUser = TdUser.Account;
#endregion
List<string> sqlList = new List<string>();
ID = System.Guid.NewGuid().ToString().Replace("-", "");
sqlList.Add(string.Format("insert into Trade_HolidayEx([pricecode],[HoliName],[starttime],[endtime],[desc],[ID]) values('{0}','{1}','{2}','{3}','{4}','{5}')",
Hliday.PriceCode, Hliday.HoliName, Hliday.Starttime.ToString("yyyy-MM-dd HH:mm:ss"), Hliday.Endtime.ToString("yyyy-MM-dd HH:mm:ss"), Hliday.Desc, ID));
string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac);
sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')",
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType,
string.Format("{3}添加节假日:{0},{1}-{2}", Hliday.ID, Hliday.Starttime, Hliday.Endtime, ipmac)));
if (!ComFunction.SqlTransaction(sqlList))
{
rsdc.Result = false;
rsdc.Desc = "添加节假日出错";
return rsdc;
}
if ("1" == ComFunction.InterType)
{
Hliday.ID = ID;
ComFunction.AddHoliday(Hliday);
}
rsdc.Result = true;
rsdc.Desc = "添加节假日成功";
}
catch (Exception ex)
{
ComFunction.WriteErr(ex);
rsdc.Result = false;
rsdc.Desc = "添加节假日失败";
}
return rsdc;
}