protected void BatchInsert()
{
if (batchInsertRealtimeList == null || batchInsertRealtimeList.Count == 0)
{
return;
}
List <CEntityRealTime> realtimeList = new List <CEntityRealTime>();
lock (batchInsertRealtimeList)
{
realtimeList.AddRange(batchInsertRealtimeList);
batchInsertRealtimeList.Clear();
}
Dictionary <string, object> param = new Dictionary <string, object>();
string suffix = "/currentdata/insertCurrentdataCS";
string url = "http://" + urlPrefix + suffix;
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string jsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(realtimeList, Newtonsoft.Json.Formatting.None, timeConverter);
param["currentdata"] = jsonStr;
try
{
string resultJson = HttpHelper.Post(url, param);
CDBLog.Instance.AddInfo(string.Format("添加{0}行到实时数据表", realtimeList.Count));
}
catch (Exception e)
{
Debug.WriteLine("添加雨量信息失败");
}
}
public static string Serialize <T>(T entity)
{
Newtonsoft.Json.Converters.IsoDateTimeConverter iso
= new Newtonsoft.Json.Converters.IsoDateTimeConverter();
iso.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(Newtonsoft.Json.JsonConvert.SerializeObject(entity, iso));
}
public static void ConfigureWebApi(this IAppBuilder app, HttpConfiguration config)
{
config.IncludeErrorDetailPolicy = GetErrorDetailPolicy();
// Web API configuration and services
config.Formatters.Remove(config.Formatters.XmlFormatter);
// Web API routes
config.MapHttpAttributeRoutes();
config.Routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{id}",
defaults: new { id = RouteParameter.Optional }
);
// JSON serialization
config.Formatters.JsonFormatter.SerializerSettings.ContractResolver =
new CamelCasePropertyNamesContractResolver();
// force 8601 date format
var converter = new Newtonsoft.Json.Converters.IsoDateTimeConverter
{
DateTimeStyles = System.Globalization.DateTimeStyles.AdjustToUniversal
};
config.Formatters.JsonFormatter.SerializerSettings.Converters.Add(converter);
// CORS
var enableCorsAttr = new EnableCorsAttribute($"{Constants.Urls.WebUrl}", "*", "*");
enableCorsAttr.ExposedHeaders.Add("file-name");
config.EnableCors(enableCorsAttr);
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.BLL.Workshop bllPlace = new TF.RunSafty.BLL.Workshop();
List <TF.RunSafty.Model.WorkShop> placeList = bllPlace.GetCheJianList("");
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
ArrayName an = new ArrayName();
jsonModel.data = an;
an.ArrayWorkShop = bllPlace.GetPlaceList(placeList);
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter));
}
public void TestConsumerStateChangeNotification()
{
// Consumer JobStateChange
var env = new RPCEnvelope();
var con = new JobStateChange();
env.Message = con;
env.Operation = con.GetType().Name;
con.Id = Guid.NewGuid();
con.Timestamp = DateTime.UtcNow;
con.State = "Setup";
var iso = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
iso.DateTimeFormat = "yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffK";
string json = Newtonsoft.Json.JsonConvert
.SerializeObject(env, iso);
// Orchestrator JobStateChange
JToken token = JObject.Parse(json);
String op = (string)token.SelectToken("Operation");
JToken msg = token.SelectToken("Mesage");
Assert.IsTrue(op == "JobStateChange");
var serializer = new Newtonsoft.Json.JsonSerializer();
Newtonsoft.Json.JsonReader reader = token["Message"].CreateReader();
var job = serializer.Deserialize <JobStateChange>(reader);
Assert.AreEqual(((JobStateChange)env.Message).State, job.State);
}
public JsonResult FilterData([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, string searchprm)
{
SearchFilter searchFilter = ScanTimeApprovalManager.SearchData(requestModel);
ScanTimeApprovalSqlParameters parameters = new ScanTimeApprovalSqlParameters();
var dateTimeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
};
SearchParams param = new SearchParams();
if (!string.IsNullOrEmpty(searchprm))
{
param = JsonConvert.DeserializeObject <SearchParams>(searchprm, dateTimeConverter);
}
parameters.FromDate = param.StartDate ?? SystemConfig.CurrentDate.AddDays(-30);
parameters.ToDate = param.EndDate ?? SystemConfig.CurrentDate;
parameters.UserLoggedIn = CustomerAuthorize.CurrentUser.EmployeeCode;
parameters.ShowWaiting = param.ShowMissing == "on";
parameters.StartRow = (requestModel.Start / requestModel.Length) + 1;
parameters.EndRow = requestModel.Length;
parameters.OrderBy = string.IsNullOrEmpty(searchFilter.OrderBy) ? "EmployeeNo" : searchFilter.OrderBy;
parameters.OrderDirection = searchFilter.OrderDirection == "ASC" ? 1 : 0;
parameters.FilterBy = parameters.FilterBy = requestModel.Search.Value;
parameters.ShowUnNoReg = false;
ScanTimeApprovalCollection collection = ScanTimeApprovalManager.GetAll(parameters);
int totalRecord = 0;
if (collection.Count > 0)
{
totalRecord = collection[0].TotalRecord;
}
return(Json(new DataTablesResponse(requestModel.Draw, collection, totalRecord, totalRecord), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 删除某条水情数据
/// </summary>
/// <param name="stationid"></param>
/// <param name="time"></param>
public static void DeleteHourWater(string stationid, DateTime time)
{
water v = new water {
stationid = stationid, datatime = time
};
List <water> listWater = new List <water>();
listWater.Add(v);
Dictionary <string, object> param = new Dictionary <string, object>();
//string suffix = "user/updateUser";
string url = suffix + "/water/deleteWater";
//string url = "http://127.0.0.1:8088/water/deleteWater";
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string jsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(listWater, Newtonsoft.Json.Formatting.None, timeConverter);
param["water"] = jsonStr;
try
{
string resultJson = HttpHelper.Post(url, param);
}
catch (Exception e)
{
Debug.Print(e.Message + "数据库保存失败");
}
//using (LNRRDB ln = new LNRRDB())
//{
// water w = new water();
// w = ln.water.First(i => (i.stationid) == stationid && i.datatime == time);
// ln.water.Remove(w);
// ln.SaveChanges();
//}
}
private string getJsonQueryCarData(string key, string CID)
{
string r = "";
//string strCid = "";
try
{
ComSqlHelper oSqlUtil = new ComSqlHelper();
SqlParameter[] oaPara;
//参数构建
oaPara = new SqlParameter[2];
oaPara[0] = new SqlParameter("@cid", CID);
//oaPara[1] = new SqlParameter("@cid", CID);
DataTable dt = new DataTable();
dt = oSqlUtil.FillDataSet(key, "JLJGPT_CarInforCarDataSelect", oaPara, "CarData", 30).Tables[0];
if (dt.Rows.Count > 0)
{
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd' 'HH':'mm':'ss";
r = JsonConvert.SerializeObject(dt, timeConverter);
}
}
catch (Exception)
{
r = "";
}
return(r);
}
private string getJsonQueryRourt(string key)
{
string r = "";
//string strCid = "";
try
{
ComSqlHelper oSqlUtil = new ComSqlHelper();
SqlParameter[] oaPara;
//参数构建
oaPara = new SqlParameter[0];
DataTable dt = new DataTable();
dt = oSqlUtil.FillDataSet(key, "QSProc_GetQsLine", oaPara, "RourtData", 30).Tables[0];
if (dt.Rows.Count > 0)
{
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd' 'HH':'mm':'ss";
r = JsonConvert.SerializeObject(dt, timeConverter);
}
}
catch (Exception)
{
r = "";
}
return(r);
}
public ActionResult GetThemeList(int id)
{
string key = HCRequest.GetString("key");
string weixinid = "";//酒店微信id
if (!key.Equals("") && key.Contains("@"))
{
weixinid = key.Split('@')[0];//酒店微信id
}
int curpage = HCRequest.getInt("page"); //
int pagesize = HCRequest.getInt("pagesize");
int sort = HCRequest.getInt("sort"); //距离，价格高低 排序
string themetype = HCRequest.GetString("type"); //多个类型逗号隔开
string endcity = HCRequest.GetString("cityname");
string keyworks = HCRequest.GetString("keyworks");
List <LXS_ThemeView> listTheme = TravelThemeLogic.GetThemeList(weixinid, curpage, pagesize, sort, themetype, endcity, keyworks);
Newtonsoft.Json.Converters.IsoDateTimeConverter timeFormat = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string strJson = Newtonsoft.Json.JsonConvert.SerializeObject(listTheme, timeFormat);
return(Json(
new
{
success = true,
msg = strJson,
nextpage = listTheme.Count == pagesize ? curpage + 1 : curpage
}
));
}
/// <summary>
/// 修改某条电压数据
/// </summary>
/// <param name="stationid"></param>
/// <param name="time"></param>
/// <param name="value"></param>
public static void AlterHourVoltage(string stationid, DateTime time, decimal value)
{
voltage v = new voltage {
stationid = stationid, datatime = time, data = value
};
List <voltage> listVoltage = new List <voltage>();
listVoltage.Add(v);
Dictionary <string, object> param = new Dictionary <string, object>();
//string suffix = "user/updateUser";
string url = suffix + "/voltage/updateVoltage";
//string url = "http://127.0.0.1:8088/voltage/updateVoltage";
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string jsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(listVoltage, Newtonsoft.Json.Formatting.None, timeConverter);
param["voltage"] = jsonStr;
try
{
string resultJson = HttpHelper.Post(url, param);
}
catch (Exception e)
{
Debug.Print(e.Message + "数据库保存失败");
}
//using (LNRRDB ln = new LNRRDB())
//{
// voltage v = new voltage();
// v = ln.voltage.First(i => (i.stationid) == stationid && i.datatime == time);
// v.data = value;
// ln.SaveChanges();
//}
}
public ActionResult GetMyThemeList(int id)
{
string key = HCRequest.GetString("key");
string weixinid = "";//酒店微信id
string uwx = "";
if (!key.Equals("") && key.Contains("@"))
{
weixinid = key.Split('@')[0];//酒店微信id
uwx = key.Split('@')[1];
}
int curpage = HCRequest.getInt("page");//
int pagesize = HCRequest.getInt("pagesize");
List <LXS_ThemeView> listTheme = TravelThemeLogic.GetMyThemeList(uwx, curpage, pagesize);
Newtonsoft.Json.Converters.IsoDateTimeConverter timeFormat = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeFormat.DateTimeFormat = "yyyy-MM-dd";//"yyyy-MM-dd HH:mm:ss";
string strJson = Newtonsoft.Json.JsonConvert.SerializeObject(listTheme, timeFormat);
return(Json(
new
{
success = true,
msg = strJson,
nextpage = listTheme.Count == pagesize ? curpage + 1 : curpage
}
));
}
public override string QueryResult()
{
JsonModel model = new JsonModel();
ParamModel p = new ParamModel();
DataTable table = null;
DataTable tblFile = null;
ParamModel param = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
this.clientid = param.cid;
TF.RunSafty.BLL.TAB_FileGroup bllFileGroup = new TF.RunSafty.BLL.TAB_FileGroup();
TF.RunSafty.BLL.TAB_ReadDoc bllFile = new TF.RunSafty.BLL.TAB_ReadDoc();
try
{
table = bllFileGroup.GetAllList().Tables[0];
tblFile = bllFile.GetAllListWithFileType(clientid).Tables[0];
model.result = "0";
model.returnStr = "返回成功";
model.TypeList = table;
model.FileList = tblFile;
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string result = Newtonsoft.Json.JsonConvert.SerializeObject(model, timeConverter).Replace(":null", ":\"\"");
return(result);
}
/// <summary>
/// 用于实体操作记录日志
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="entity"></param>
/// <param name="logType"></param>
/// <param name="operUser"></param>
public static void AddLogInfo <T>(T entity, Infrastructure.Crosscutting.Function.LoggerType logType,
iPow.Infrastructure.Data.DataSys.Sys_AdminUser operUser)
{
if (entity != null)
{
var log = new DataSys.Sys_AdminUserLog();
log.AddTime = System.DateTime.Now;
log.IpAddress = Infrastructure.Crosscutting.Function.StringHelper.GetRealIP();
log.PageUrl = Infrastructure.Crosscutting.Function.StringHelper.GetCurrentUrl();
log.ReferrerUrl = Infrastructure.Crosscutting.Function.StringHelper.GetReferrerUrl();
log.State = true;
if (operUser != null)
{
log.UserId = operUser.id;
}
log.TypeId = (int)logType;
log.ShortMessage = logType.ToString() + " " + entity.GetType().Name;
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd' 'HH':'mm':'ss";
var json = Newtonsoft.Json.JsonConvert.SerializeObject(entity, Newtonsoft.Json.Formatting.Indented, timeConverter);
log.FullMessage = json;
AddLogInfo(log);
}
}
public JsonModel Getsignplanlist(string input)
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(input);
Bll_Plan_Rest bllPlace = new Bll_Plan_Rest();
List <Modal_Plan_Rest> placeList = bllPlace.GetPlanTrain(paramModel.dtStartTime, paramModel.dtEndTime, paramModel.strJiaoluGUID);
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
planArrays p = new planArrays();
jsonModel.data = p;
p.strTrainJiaoLuGUID = paramModel.strJiaoluGUID;
p.strCurPlanGUID = "";
p.planArray = bllPlace.GetPlaceList(placeList);
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(jsonModel);
}
public static string GetJsonString(object obj)
{
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(Newtonsoft.Json.JsonConvert.SerializeObject(obj, Newtonsoft.Json.Formatting.None, timeConverter));
}
/// <summary>
/// 发送手机验证码
/// </summary>
/// <param name="vercode"></param>
/// <param name="sim"></param>
/// <returns></returns>
public static string SendSmsVerCode(string vercode, string sim)
{
PushRequestModel ds = new PushRequestModel();
ds.projectid = 30001;
ds.sequ = DateTime.Now.Second;
ds.serviceid = 20002;
ds.tosystemid = 20003;
SmsCodeModel sc = new SmsCodeModel();
sc.vercode = vercode;
sc.sim = sim;
ds.para = sc;
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd' 'HH':'mm':'ss";
string strReq = JsonConvert.SerializeObject(ds, timeConverter);
int resss = SendSMSToPhone(strReq);
if (resss == 200)
{
return("");
}
else
{
LogHelper.WriteInfo("SmsSend:Req " + strReq, false, true);
LogHelper.WriteInfo("SmsSend:Resp " + resss, false, true);
return(resss.ToString());
}
}
public string GetOrderGroups(string data)
{
JsonModel jsonModel = new JsonModel();
TF.Api.Utilities.Validation validater = new TF.Api.Utilities.Validation();
try
{
OrderGroupQuery paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <OrderGroupQuery>(data);
//验证数据正确性,非空字段不能为空
if (validater.IsNotNullPropertiesValidated(paramModel.data))
{
string jiaoluID = paramModel.data.trainmanjiaoluID;
List <string> placeIDs = new List <string>();
string trainmanID = paramModel.data.trainmanID;
placeIDs.AddRange(paramModel.data.placeID.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries));
List <OrderGroup> groups = this.GetOrderGroups(jiaoluID, placeIDs, trainmanID);
jsonModel.data = groups;
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter);
return(result);
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
PlanSign paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <PlanSign>(this.Data);
TF.RunSafty.BLL.Tab_Plan_Rest bllPlace = new TF.RunSafty.BLL.Tab_Plan_Rest();
string strJiaoLu = "";
foreach (TF.RunSaftyAPI.App_Api.Public.IGetPlanRestByWorkShopAndTime.JiaoLu JiaoLuId in paramModel.data.JiaoLuAry)
{
strJiaoLu += "'" + JiaoLuId.strTrainJiaoLuGUID + "',";
}
strJiaoLu = strJiaoLu.Substring(0, strJiaoLu.Length - 1);
List <TF.RunSafty.Model.TAB_Plan_Rest> placeList = bllPlace.GetPlanListByTimeAndWorkShop(strJiaoLu, paramModel.data.dtStartTime, paramModel.data.dtEndTime);
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
ArrayName an = new ArrayName();
jsonModel.data = an;
an.signplanary = bllPlace.GetPlaceList(placeList);
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter));
}
public override void ExecuteResult(ControllerContext context)
{
if (context == null)
{
throw new ArgumentNullException("context");
}
var response = context.HttpContext.Response;
if (!string.IsNullOrWhiteSpace(this.ContentType))
{
response.ContentType = this.ContentType;
}
else
{
response.ContentType = "application/json";
}
if (this.ContentEncoding != null)
{
response.ContentEncoding = this.ContentEncoding;
}
if (this.Data != null)
{
var timeFormat = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeFormat.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
var json = Newtonsoft.Json.JsonConvert.SerializeObject(Data, Newtonsoft.Json.Formatting.Indented, timeFormat);
response.Write(json);
}
}
public override void ExecuteResult(ControllerContext context)
{
if (context == null)
{
throw new ArgumentNullException("context");
}
if (this.JsonRequestBehavior == JsonRequestBehavior.DenyGet &&
String.Equals(context.HttpContext.Request.HttpMethod, "GET", StringComparison.OrdinalIgnoreCase))
{
throw new InvalidOperationException("GET not allowed! Change JsonRequestBehavior to AllowGet.");
}
var response = context.HttpContext.Response;
response.ContentType = String.IsNullOrEmpty(this.ContentType) ? "application/json" : this.ContentType;
if (this.ContentEncoding != null)
{
response.ContentEncoding = this.ContentEncoding;
}
if (Data != null)
{
// Using Json.NET serializer
var isoConvert = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
const string _dateFormat = "dd/MM/yyyy HH:mm:ss";
isoConvert.DateTimeFormat = _dateFormat;
response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(Data, isoConvert));
}
}
public string Getsignplanlistbyjiaoluary(string input)
{
OutJsonModel jsonModel = new OutJsonModel();
try
{
TrainmanData paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <TrainmanData>(input);
Bll_Plan_Rest bllPlace = new Bll_Plan_Rest();
string strJiaoLu = "";
foreach (JiaoLu JiaoLuId in paramModel.JiaoLuAry)
{
strJiaoLu += "'" + JiaoLuId.strTrainJiaoLuGUID + "',";
}
strJiaoLu = strJiaoLu.Substring(0, strJiaoLu.Length - 1);
List <Modal_Plan_Rest> placeList = bllPlace.GetPlanListByTimeAndWorkShop(strJiaoLu, paramModel.dtStartTime, paramModel.dtEndTime);
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
ArrayName an = new ArrayName();
jsonModel.data = an;
an.signplanary = bllPlace.GetPlaceList(placeList);
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter));
}
public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
ParamModel param = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.Logic.MonthWorkTimeBLL bllWorkTime = new TF.RunSafty.Logic.MonthWorkTimeBLL();
int nTotalWorkCount = 0;
decimal ntotalMinutes = 0m;
DataTable table = null;
try
{
table = bllWorkTime.GetWorkTimeByTrainman(param.strTrainmanGUID, param.dtBeginTime, param.dtEndTime);
if (table != null)
{
nTotalWorkCount = table.Rows.Count;
ntotalMinutes = Convert.ToDecimal(table.Compute("sum(fTotalTime)", ""));
}
jsonModel.Detail = table;
jsonModel.ntotalMinutes = ntotalMinutes.ToString();
jsonModel.nTotalWorkCount = nTotalWorkCount.ToString();
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
}
jsonModel.result = "0";
jsonModel.resultStr = "返回成功";
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter).Replace(":null", ":\"\"");
return(result);
}
public string GetContact(int con_id)
{
var current = 1;
var rowCount = 10;
try
{
var count = 0;
Dictionary <string, object> contact =
CustomerService.GetContact(Session[teaCRMKeys.SESSION_USER_COMPANY_INFO_NUM].ToString(), con_id);
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter =
new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd";
var contacts = JsonConvert.SerializeObject(contact, timeConverter); //quoOdrs 是对象集合
//利用IsoDateTimeConverter这个类设置日期格式就可以了。
return(contacts);
}
catch (Exception ex)
{
LogHelper.Error("用户id为" + Session[teaCRMKeys.SESSION_USER_COMPANY_INFO_ID].ToString() +
"的用户获取联系人信息失败", ex);
return("{\"Rows\":[],\"Total\":\"0\"}");
}
}
public static bool TryParse(string json, out Contract contract)
{
try
{
var conv = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
var set = new JsonSerializerSettings
{
TypeNameHandling = TypeNameHandling.Auto,
NullValueHandling = NullValueHandling.Ignore,
ReferenceLoopHandling = ReferenceLoopHandling.Serialize,
PreserveReferencesHandling = PreserveReferencesHandling.Objects,
DateFormatHandling = DateFormatHandling.MicrosoftDateFormat,
Formatting = Formatting.Indented
};
set.Converters.Add(conv);
contract = JsonConvert.DeserializeObject <Contract>(json, set);
return(true);
}
catch (Exception e)
{
contract = null;
return(false);
}
}
/// <summary>
/// 作者：王赟
/// 时间：2014-12-18
/// 描述：重载GetJsonResult方法，添加时间格式参数
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="list"></param>
/// <param name="root"></param>
/// <param name="time">
/// </param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static ContentResult GetJsonResult <T>(IEnumerable <T> list, string root, string time, int?totalCount) where T : new()
{
StringBuilder builder = new StringBuilder("{");
//[{"id":1},{"id":2}]
var dateTime = new Newtonsoft.Json.Converters.IsoDateTimeConverter {
DateTimeFormat = time
};
string json = JsonConvert.SerializeObject(list, Formatting.Indented, dateTime);
builder.AppendFormat("\"{0}\":\"{1}\",", STATUS, STATUS_TRUE);
builder.AppendFormat("\"{0}\":\"{1}\",", MSG, MSG_OK);
if (totalCount == null)
{
builder.AppendFormat("\"{0}\":\"\",", TOTAL);
}
else
{
builder.AppendFormat("\"{0}\":{1},", TOTAL, totalCount);
}
builder.AppendFormat("\"{0}\":{1}", root, json);
builder.Append("}");
return(ContentResult(builder));
}
private string getJson(object rg)
{
Newtonsoft.Json.Converters.IsoDateTimeConverter isoDateTimeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//设置日期格式
isoDateTimeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
//序列化
return(JsonConvert.SerializeObject(rg, isoDateTimeConverter));
}
public static string ToJson(this object obj, string datetimeformats)
{
var timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter {
DateTimeFormat = datetimeformats
};
return(Newtonsoft.Json.JsonConvert.SerializeObject(obj, timeConverter));
}
public static string ToJson(this object obj)
{
var timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter {
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
};
return(Newtonsoft.Json.JsonConvert.SerializeObject(obj, timeConverter));
}
/// <summary>序列化</summary>
/// <param name="obj">object </param>
/// <returns></returns>
public static string ToJson(object obj)
{
var idtc = new Newtonsoft.Json.Converters.IsoDateTimeConverter {
DateTimeFormat = "yyyy-MM-dd hh:mm:ss"
};
return(JsonConvert.SerializeObject(obj, idtc));
}
public string GetAllMember()
{
IMemberService tmpService = UnityHelper.UnityResolve<IMemberService>();
var data = tmpService.GetMemberByQueryList(InitQueryEntity());
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = ConstUtils.CONST_SHOW_DATE_FORMAT;
var tmpdata = JsonConvert.SerializeObject(data.Tables[2], timeConverter);
var result = "{\"total\":" + data.Tables[1].Rows[0]["TotalRecordsCount"].ToString() + ",\"rows\":" + tmpdata + " }";
return result;
}
public static string JsonEncode(this object o)
{
string DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
if (o == null)
{
return null;
}
if ((o != null) && ((o.GetType() == typeof(string)) || (o.GetType() == typeof(string))))
{
return o.ToString();
}
Newtonsoft.Json.Converters.IsoDateTimeConverter converter = new Newtonsoft.Json.Converters.IsoDateTimeConverter
{
DateTimeFormat = DateTimeFormat
};
return Newtonsoft.Json.JsonConvert.SerializeObject(o, new Newtonsoft.Json.JsonConverter[] { converter });
}
public string GetContact(int con_id)
{
var current = 1;
var rowCount = 10;
try
{
var count = 0;
Dictionary<string, object> contact =
CustomerService.GetContact(Session[teaCRMKeys.SESSION_USER_COMPANY_INFO_NUM].ToString(), con_id);
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter =
new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd";
var contacts = JsonConvert.SerializeObject(contact, timeConverter); //quoOdrs 是对象集合
//利用IsoDateTimeConverter这个类设置日期格式就可以了。
return contacts;
}
catch (Exception ex)
{
LogHelper.Error("用户id为" + Session[teaCRMKeys.SESSION_USER_COMPANY_INFO_ID].ToString() +
"的用户获取联系人信息失败", ex);
return "{\"Rows\":[],\"Total\":\"0\"}";
}
}
protected string GetData()
{
#region
dynamic stu1 = new ExpandoObject();
stu1.sid = "STU2014082201";
stu1.name = "STU1";
stu1.sex = "0";
stu1.grade = "初一";
stu1.className = "一(1)班";
stu1.brithday = new DateTime(2000, 1, 1);
stu1.remark = "";
dynamic stu2 = new ExpandoObject();
stu2.sid = "STU2014082202";
stu2.name = "STU2";
stu2.sex = "1";
stu2.grade = "初一";
stu2.className = "一(1)班";
stu2.brithday = new DateTime(1999, 6, 7);
stu2.remark = "";
dynamic stu3 = new ExpandoObject();
stu3.sid = "STU2014082203";
stu3.name = "STU3";
stu3.sex = "0";
stu3.grade = "初一";
stu3.className = "一(1)班";
stu3.brithday = new DateTime(2001, 2, 10);
stu3.remark = "";
dynamic stu4 = new ExpandoObject();
stu4.sid = "STU2014082204";
stu4.name = "STU4";
stu4.sex = "1";
stu4.grade = "初一";
stu4.className = "一(2)班";
stu4.brithday = new DateTime(1998, 7, 7);
stu4.remark = "";
dynamic stu5 = new ExpandoObject();
stu5.sid = "STU2014082206";
stu5.name = "STU6";
stu5.sex = "1";
stu5.grade = "初二";
stu5.className = "二(1)班";
stu5.brithday = new DateTime(2000, 5, 1);
stu5.remark = "";
#endregion
dynamic stu6 = new ExpandoObject();
stu6.sid = "STU2014082206";
stu6.name = "STU6";
stu6.sex = "0";
stu6.grade = "初二";
stu6.className = "二(1)班";
stu6.brithday = new DateTime(2000, 6, 12);
stu6.remark = "";
dynamic stu7 = new ExpandoObject();
stu7.sid = "STU2014082207";
stu7.name = "STU7";
stu7.sex = "1";
stu7.grade = "初二";
stu7.className = "二(1)班";
stu7.brithday = new DateTime(1999, 7, 8);
stu7.remark = "";
dynamic stu8 = new ExpandoObject();
stu8.sid = "STU2014082208";
stu8.name = "STU8";
stu8.sex = "0";
stu8.grade = "初二";
stu8.className = "二(2)班";
stu8.brithday = new DateTime(2001, 10, 15);
stu8.remark = "";
dynamic stu9 = new ExpandoObject();
stu9.sid = "STU2014082209";
stu9.name = "STU9";
stu9.sex = "0";
stu9.grade = "初二";
stu9.className = "二(2)班";
stu9.brithday = new DateTime(2002, 8, 8);
stu9.remark = "";
dynamic stu10 = new ExpandoObject();
stu10.sid = "STU2014082210";
stu10.name = "STU10";
stu10.sex = "0";
stu10.grade = "初三";
stu10.className = "三(1)班";
stu10.brithday = new DateTime(2000, 12, 1);
stu10.remark = "";
dynamic stu11 = new ExpandoObject();
stu11.sid = "STU2014082211";
stu11.name = "STU11";
stu11.sex = "0";
stu11.grade = "初三";
stu11.className = "三(1)班";
stu11.brithday = new DateTime(1998, 7, 7);
stu11.remark = "";
dynamic stu12 = new ExpandoObject();
stu12.sid = "STU2014082212";
stu12.name = "STU12";
stu12.sex = "1";
stu12.grade = "初三";
stu12.className = "三(1)班";
stu12.brithday = new DateTime(1999, 7, 8);
stu12.remark = "";
dynamic stu13 = new ExpandoObject();
stu13.sid = "STU2014082213";
stu13.name = "STU13";
stu13.sex = "0";
stu13.grade = "初三";
stu13.className = "三(1)班";
stu13.brithday = new DateTime(1998, 7, 7);
stu13.remark = "";
dynamic stu14 = new ExpandoObject();
stu14.sid = "STU2014082214";
stu14.name = "STU114";
stu14.sex = "1";
stu14.grade = "初三";
stu14.className = "三(2)班";
stu14.brithday = new DateTime(2000, 3, 5);
stu14.remark = "";
dynamic stu15 = new ExpandoObject();
stu15.sid = "STU2014082215";
stu15.name = "STU15";
stu15.sex = "1";
stu1.grade = "初三";
stu15.className = "三(2)班";
stu15.brithday = new DateTime(1999, 12, 1);
stu15.remark = "";
dynamic reslut = new ExpandoObject();
reslut.total = 100;
reslut.rows = new[]
{
stu1,stu2,stu3,stu4,stu5,
stu6,stu7,stu8,stu9,stu10,
stu11,stu12,stu13,stu14,stu15
};
var timeConvert = new Newtonsoft.Json.Converters.IsoDateTimeConverter
{
DateTimeFormat = "yyyy-MM-dd"
};
return Newtonsoft.Json.JsonConvert.SerializeObject(reslut, timeConvert);
}
///Get Customer Data
public ActionResult GetCustomerVisitDetailData(string id)
{
CustomerVisitManager CustomerVisitEntity = null;
string sSql = "SELECT * FROM SGP_CustomerVisit WHERE ID = @ID";
DataTable dt = DbHelperSQL.Query(sSql, new SqlParameter("@ID", id)).Tables[0];
if (dt.Rows.Count > 0)
{
CustomerVisitEntity = ModelHandler<CustomerVisitManager>.FillModel(dt.Rows[0]);
}
var dateConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter { DateTimeFormat = "MM/dd/yyyy" };
ViewData["json"] = Newtonsoft.Json.JsonConvert.SerializeObject(CustomerVisitEntity, dateConverter);
return Content(Convert.ToString(ViewData["json"]), "application/json");
}
