public FBDataService(UrlGenerator urlGenerator, AuthService authService, JsonHelper jsonHelper, HttpClient httpClient)
{
this.urlGenerator = urlGenerator;
this.authService = authService;
this.jsonHelper = jsonHelper;
this.httpClient = httpClient;
}
public override object GetResponse()
{
DoRequest();
JsonHelper jsonHelper = new JsonHelper(mResponse);
Debug.WriteLine(jsonHelper.GetVal("Result"));
if (jsonHelper.GetVal("Result").ToLower() == "true")
return true;
return false;
}
/// <summary>
/// 返回执行成功JSON字符串
/// </summary>
/// <returns></returns>
public static string SuccessString(string info)
{
JsonHelper json = new JsonHelper();
json.totlal = 0;
json.success = true;
json.AddItem("info", info);
json.ItemOk();
return json.ToString();
}
public void ItShouldConvertStringToObject()
{
JsonHelper instance = new JsonHelper();
TestObject model = instance.ToObject<TestObject>(_json);
Assert.IsNotNull(model);
Assert.IsNotNull(model.Property);
Assert.AreEqual(PropValue, model.Property);
}
/// <summary>
/// 返回失败JSON，但是不包含：操作失败等字样；该方法比较干净，参数是什么就返回什么
/// </summary>
/// <param name="FailNotice"></param>
/// <returns></returns>
public static string FailStringNohaveOther(string FailNotice)
{
JsonHelper json = new JsonHelper();
json.totlal = 0;
json.success = false;
FailNotice = Regex.Replace(FailNotice, @"\r\n", " ");
json.AddItem("info", FailNotice.Replace("/", "").Replace("\"", "'"));
json.ItemOk();
return json.ToString();
}
/// <summary>
/// 返回失败JSON字符串
/// </summary>
/// <param name="FailNotice"></param>
/// <returns></returns>
public static string FailString(string FailNotice)
{
JsonHelper json = new JsonHelper();
json.totlal = 0;
json.success = false;
FailNotice = Regex.Replace(FailNotice, @"\r\n", " ");
json.AddItem("info", NoticeEnum.GetEnumDesc(NoticeEnum.NOTICE.FAILSURE) + ",可能原因为:" + FailNotice.Replace("/", "").Replace("\"", "'"));
json.ItemOk();
return json.ToString();
}
public void ItShouldConvertObjectToString()
{
JsonHelper instance = new JsonHelper();
TestObject model = new TestObject { Property = PropValue };
string result = instance.ToJson<TestObject>(model);
Assert.IsNotNull(result);
Assert.AreEqual(_json, result);
}
public void UpdateModel(string json)
{
Items.Clear();
var jsonArray = JsonValue.Parse(json) as JsonArray;
if (jsonArray == null) return;
var template = jsonArray[0] as JsonObject;
if (template == null) return;
var jsonHelper = new JsonHelper<CustomType>(template);
foreach (var item in jsonArray)
{
var customType = new CustomType();
jsonHelper.MapJsonObject(customType.SetPropertyValue, item);
Items.Add(customType);
}
}
static void Main(string[] args)
{
log4net.Config.BasicConfigurator.Configure();
var options = new Options();
var parseSuccess = CommandLine.Parser.Default.ParseArguments(args, options);
if (parseSuccess)
{
var appState = new ApplicationState();
var copier = new DeepCopier();
var resxReader = new ResxReader(appState, null);
var jsonHelper = new JsonHelper();
var converter = new ResxToJsConverter(copier, resxReader, jsonHelper, appState, null);
converter.Convert(options);
DisplayErrorMessages(appState);
}
else
{
Console.WriteLine("An error occurred while parsing the options.");
}
////Console.ReadLine();
}
/// <summary>
/// 查询数据
/// </summary>
public ActionResult QueryBuyData()
{
int page = Request.Form["page"] != "" ? Convert.ToInt32(Request.Form["page"]) : 0;
int size = Request.Form["rows"] != "" ? Convert.ToInt32(Request.Form["rows"]) : 0;
string sort = Request.Form["sort"] != "" ? Request.Form["sort"] : "";
string order = Request.Form["order"] != "" ? Request.Form["order"] : "";
if (page < 1) return Content("");
IList<BuyInfo> lstBuyInfos = BuyInfoDao.Instance.GetPageBuyInfos(page, size, null);
JsonHelper json = new JsonHelper();
string strJson = string.Empty;
foreach (var item in lstBuyInfos)
{
json.AddItem("ID", item.ID.ToString());
json.AddItem("Name", item.Name == null ? "" : item.Name);
json.AddItem("Place", item.Place == null ? "" : item.Place);
json.AddItem("Price", item.Price.ToString());
json.AddItem("Product", item.Product.ToString());
json.AddItem("SubTime", item.SubTime.ToString());
json.AddItem("SitePath", item.SitePath == null ? "" : item.SitePath);
json.AddItem("Tel", item.Tel == null ? "" : item.Tel.ToString());
json.ItemOk();
}
int totalCount = BuyInfoDao.Instance.GetTotalCount(null);
json.totlalCount = totalCount;
if (json.totlalCount > 0)
{
strJson = json.ToEasyuiGridJsonString();
}
else
{
strJson = @"[]";
}
// json = "{ \"rows\":[ { \"ID\":\"48\",\"NewsTitle\":\"mr\",\"NewsContent\":\"mrsoft\",\"CreateTime\":\"2013-12-23\",\"CreateUser\":\"ceshi\",\"ModifyTime\":\"2013-12-23\",\"ModifyUser\":\"ceshi\"} ],\"total\":3}";
return Content(strJson);
}
public object AddOrEdit([FromBody] Newtonsoft.Json.Linq.JArray form)
{
dynamic frequencySetup = form[0].ToObject <ExpandoObject>(JsonHelper.GetJsonSerializer());
List <EntityParser.CustomField> customFields = form[1].ToObject <List <EntityParser.CustomField> >(JsonHelper.GetJsonSerializer());
if (frequencySetup == null)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.MethodNotAllowed));
}
try
{
return(this.FrequencySetupRepository.AddOrEdit(frequencySetup, customFields));
}
catch (UnauthorizedException)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Forbidden));
}
catch (MixERPException ex)
{
throw new HttpResponseException(new HttpResponseMessage
{
Content = new StringContent(ex.Message),
StatusCode = HttpStatusCode.InternalServerError
});
}
catch
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
public object AddOrEdit([FromBody] Newtonsoft.Json.Linq.JArray form)
{
dynamic user = form[0].ToObject <ExpandoObject>(JsonHelper.GetJsonSerializer());
List <Frapid.DataAccess.Models.CustomField> customFields = form[1].ToObject <List <Frapid.DataAccess.Models.CustomField> >(JsonHelper.GetJsonSerializer());
if (user == null)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.MethodNotAllowed));
}
try
{
return(this.UserRepository.AddOrEdit(user, customFields));
}
catch (UnauthorizedException)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Forbidden));
}
catch (DataAccessException ex)
{
throw new HttpResponseException(new HttpResponseMessage
{
Content = new StringContent(ex.Message),
StatusCode = HttpStatusCode.InternalServerError
});
}
#if !DEBUG
catch
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
#endif
}
protected override void BeforeSave(Dictionary <string, string> dic, Base.Logic.Domain.S_UI_Form formInfo, bool isNew)
{
var entity = this.GetEntityByID(dic["ID"]);
if (entity == null)
{
entity = new T_SC_SchemeForm_OEM_Szsow();
}
var sublist = JsonHelper.ToList(dic.GetValue("SubProjectList"));
foreach (var item in sublist)
{
if (String.IsNullOrEmpty(item.GetValue("Code")))
{
item.SetValue("Code", FormulaHelper.CreateGuid());
}
}
var phaseEnums = EnumBaseHelper.GetEnumDef("Project.Phase").EnumItem.ToList();
string phaseExistError = string.Empty, phaseRepeatError = string.Empty, phaseStructError = string.Empty;
string phaseError = string.Empty;
#region 阶段校验
//校验项目阶段必须在子项信息子表中的设计阶段出现
//校验阶段+名称不能重复
//不支持阶段下既有子项、又有专业的情况
var projPhaseArr = dic.GetValue("PhaseValue").Split(',');
foreach (var projPhase in projPhaseArr)
{
//校验项目阶段必须在子项信息子表中的设计阶段出现
if (!sublist.Any(a => a.GetValue("PhaseValue") == projPhase))
{
phaseExistError += projPhase + ",";
}
var list = sublist.Where(a => a.GetValue("PhaseValue") == projPhase).ToList();
//校验阶段+名称不能重复
phaseRepeatError = string.Empty;
var group = list.GroupBy(a => a.GetValue("Name")).ToList();
foreach (var item in group)
{
if (item.Count() > 1)
{
phaseRepeatError += "阶段【" + phaseEnums.FirstOrDefault(a => a.Code == projPhase).Name + "】下子项【" + item.Key + "】不能重复。</br>";
}
}
if (!string.IsNullOrEmpty(phaseRepeatError))
{
phaseError += phaseRepeatError;
}
//不支持阶段下既有子项、又有专业的情况
phaseStructError = string.Empty;
if (group.Any(a => string.IsNullOrEmpty(a.Key)) && group.Any(a => !string.IsNullOrEmpty(a.Key)))
{
phaseStructError += "阶段【" + phaseEnums.FirstOrDefault(a => a.Code == projPhase).Name + "】下不能同时子项为空和子项不为空的数据。</br>";
}
if (!string.IsNullOrEmpty(phaseStructError))
{
phaseError += phaseStructError;
}
}
if (!string.IsNullOrEmpty(phaseExistError))
{
phaseExistError = String.Join(",", phaseEnums.Where(d => phaseExistError.TrimEnd(',').Split(',').Contains(d.Code)).Select(d => d.Name));
phaseError += "必须在子项信息中添加阶段【" + phaseExistError + "】的数据。</br>";
}
if (!string.IsNullOrEmpty(phaseError))
{
throw new Formula.Exceptions.BusinessException(phaseError);
}
#endregion
if (dic.ContainsKey("SubProjectList"))
{
dic.SetValue("SubProjectList", JsonHelper.ToJson(sublist));
}
this.UpdateEntity(entity, dic);
#region 校验整体专业
#region 校验成果
string sql = @"select distinct MajorValue, S_W_WBS.Name MajorName from S_E_Product p
left join S_W_WBS on p.WBSID = S_W_WBS.ID
where p.ProjectInfoID='{0}' and MajorValue not in ('{1}')";
sql = string.Format(sql, entity.ProjectInfoID, entity.Major.Replace(",", "','"));
var dt = this.ProjectSQLDB.ExecuteDataTable(sql);
if (dt.Rows.Count > 0)
{
var msgMajor = "";
foreach (DataRow item in dt.Rows)
{
msgMajor += item["MajorName"].ToString() + ",";
}
throw new Formula.Exceptions.BusinessException("专业【" + msgMajor.TrimEnd(',') + "】已经上传了设计成果，必须选中。");
}
#endregion
#region 校验提资单
var sqlPutInfo = @"select distinct OutMajorValue, S_W_WBS.Name MajorName from T_EXE_MajorPutInfo p
left join S_W_WBS on p.WBSID = S_W_WBS.ParentID and p.OutMajorValue = S_W_WBS.WBSValue
where p.ProjectInfoID='{0}' and OutMajorValue not in ('{1}')";
sqlPutInfo = string.Format(sqlPutInfo, entity.ProjectInfoID, entity.Major.Replace(",", "','"));
var dtPutInfo = this.ProjectSQLDB.ExecuteDataTable(sqlPutInfo);
if (dtPutInfo.Rows.Count > 0)
{
var msgMajor = "";
foreach (DataRow item in dtPutInfo.Rows)
{
msgMajor += item["MajorName"].ToString() + ",";
}
throw new Formula.Exceptions.BusinessException("专业【" + msgMajor.TrimEnd(',') + "】发起过提资，必须选中。");
}
#endregion
#region 校验共享区
var sqlShareInfo = @"select distinct p.WBSValue, S_W_WBS.Name MajorName from S_D_ShareInfo p
left join S_W_WBS on p.SubProjectWBSID = S_W_WBS.ParentID and p.WBSValue = S_W_WBS.WBSValue
where p.ProjectInfoID='{0}' and p.WBSValue not in ('{1}')";
sqlShareInfo = string.Format(sqlShareInfo, entity.ProjectInfoID, entity.Major.Replace(",", "','"));
var dtShareInfo = this.ProjectSQLDB.ExecuteDataTable(sqlShareInfo);
if (dtShareInfo.Rows.Count > 0)
{
var msgMajor = "";
foreach (DataRow item in dtShareInfo.Rows)
{
msgMajor += item["MajorName"].ToString() + ",";
}
throw new Formula.Exceptions.BusinessException("专业【" + msgMajor.TrimEnd(',') + "】拥有共享区文件，必须选中。");
}
#endregion
#region 校验专业里程碑
string finishState = ProjectCommoneState.Finish.ToString();
var finishMileStones = this.BusinessEntities.Set <S_P_MileStone>().Where(a => a.ProjectInfoID == entity.ProjectInfoID && a.State == finishState).ToList();
List <string> msgMileStoneMajor = new List <string>();
foreach (var item in finishMileStones)
{
if (string.IsNullOrEmpty(item.MajorValue) && string.IsNullOrEmpty(item.OutMajorValue))
{
continue;
}
if (!entity.Major.Split(',').Contains(item.MajorValue))
{
if (!msgMileStoneMajor.Contains(item.MajorValue))
{
msgMileStoneMajor.Add(item.MajorValue);
}
}
if (!string.IsNullOrEmpty(item.OutMajorValue))
{
foreach (var _oMajorValue in item.OutMajorValue.Split(','))
{
if (string.IsNullOrEmpty(_oMajorValue))
{
continue;
}
if (!entity.Major.Split(',').Contains(_oMajorValue))
{
if (!msgMileStoneMajor.Contains(_oMajorValue))
{
msgMileStoneMajor.Add(_oMajorValue);
}
}
}
}
}
if (msgMileStoneMajor.Count > 0)
{
var enmDef = EnumBaseHelper.GetEnumDef("Project.Major");
throw new Formula.Exceptions.BusinessException("专业【" + String.Join(",", enmDef.EnumItem.Where(d => msgMileStoneMajor.Contains(d.Code)).Select(d => d.Name)) + "】已经有相关里程碑完成，必须选中。");
}
#endregion
#endregion
#region 校验子项
//sll edit 2018-8-8
//没有Name也视为要删除项
//before var newsubid = sublist.Select(t => t.GetValue("Code"));
var newsubid = sublist.Where(a => !string.IsNullOrEmpty(a.GetValue("Name"))).Select(t => t.GetValue("Code"));
var enumSubProject = WBSNodeType.SubProject.ToString();
var wbsList = this.BusinessEntities.Set <S_W_WBS>().Where(a => a.ProjectInfoID == entity.ProjectInfoID).ToList();
var subWBSList = wbsList.Where(a => a.WBSType == enumSubProject).ToList();
#region 校验成果
subWBSList
.Where(w => !newsubid.Contains(w.WBSValue))
.ToList()
.ForEach(t =>
{
if (t.HasProducts())
{
throw new Formula.Exceptions.BusinessException("子项【" + t.Name + "】已经有成果图纸，不能删除。");
}
});
#endregion
var WBSIDList = wbsList.Where(a => newsubid.Contains(a.WBSValue)).Select(a => a.ID).ToList();
#region 校验提资单
var putInfoList = this.BusinessEntities.Set <T_EXE_MajorPutInfo>().Where(a => a.ProjectInfoID == entity.ProjectInfoID).ToList();
var hasPutInfo = putInfoList.Where(a => !WBSIDList.Contains(a.WBSID)).ToList();
if (hasPutInfo.Count > 0)
{
var name = "";
for (int i = 0; i < hasPutInfo.Count; i++)
{
var pInfo = hasPutInfo[i];
if (!string.IsNullOrEmpty(pInfo.WBSID))
{
var _wbs = wbsList.FirstOrDefault(a => a.ID == pInfo.WBSID);
if (_wbs != null)
{
var subNode = subWBSList.FirstOrDefault(a => _wbs.FullID.Split('.').Contains(a.ID));
if (subNode != null)
{
name += subNode.Name + ",";
}
}
}
}
throw new Formula.Exceptions.BusinessException("子项【" + name.TrimEnd(',') + "】发起过提资，不能删除。");
}
#endregion
#region 校验共享区
var shareInfoList = this.BusinessEntities.Set <S_D_ShareInfo>().Where(a => a.ProjectInfoID == entity.ProjectInfoID).ToList();
var hasShareInfo = shareInfoList.Where(a => !WBSIDList.Contains(a.SubProjectWBSID)).ToList();
if (hasShareInfo.Count > 0)
{
var name = "";
for (int i = 0; i < hasShareInfo.Count; i++)
{
var sInfo = hasShareInfo[i];
if (!string.IsNullOrEmpty(sInfo.SubProjectWBSID))
{
var _wbs = wbsList.FirstOrDefault(a => a.ID == sInfo.SubProjectWBSID);
if (_wbs != null)
{
var subNode = subWBSList.FirstOrDefault(a => _wbs.FullID.Split('.').Contains(a.ID));
if (subNode != null)
{
name += subNode.Name + ",";
}
}
}
}
throw new Formula.Exceptions.BusinessException("子项【" + name.TrimEnd(',') + "】拥有共享区文件，不能删除。");
}
#endregion
#endregion
#region 校验子项下的专业
foreach (var subProject in sublist)
{
if (!String.IsNullOrEmpty(subProject.GetValue("RBSJson")))
{
var rbsList = JsonHelper.ToList(subProject.GetValue("RBSJson"));
//sll add 2018-8-8
var subProjectWBSValue = "";
string errorExceptionPre = "";
//名称不为空，专业挂子项
if (!string.IsNullOrEmpty(subProject.GetValue("Name")))
{
subProjectWBSValue = subProject.GetValue("Code");
errorExceptionPre = "子项";
}
//名称为空, 专业挂阶段
else
{
subProjectWBSValue = subProject.GetValue("PhaseValue");
errorExceptionPre = "专业";
}
foreach (var majorNode in rbsList)
{
if (majorNode.GetValue("Valid") == "0")
{
var subProjectWBSNode = wbsList.FirstOrDefault(a => a.WBSValue == subProjectWBSValue);
//sll 2018-8-9 add
//子项名称为空到有名称后但是wbs中没有该子项节点,此时略过不需要判断
if (subProjectWBSNode == null)
{
continue;
}
var code = majorNode.GetValue("MajorCode");
#region 校验成果
wbsList
.Where(w => w.ParentID == subProjectWBSNode.ID && w.WBSValue == code)
.ToList().ForEach(t =>
{
if (t.HasProducts())
{
throw new Formula.Exceptions.BusinessException(errorExceptionPre + "【" + subProject.GetValue("Name") + "】下的专业【" + t.Name + "】已经有成果图纸，不能删除。");
}
});
#endregion
#region 校验提资单
var hasPutInfo2 = putInfoList.Where(a => a.WBSID == subProjectWBSNode.ID && a.OutMajorValue == code).ToList();
if (hasPutInfo2.Count > 0)
{
throw new Formula.Exceptions.BusinessException(errorExceptionPre + "【" + subProject.GetValue("Name") + "】下的专业【" + majorNode.GetValue("MajorName") + "】发起过提资，不能删除。");
}
#endregion
#region 校验共享区
var hasShareInfo2 = shareInfoList.Where(a => a.SubProjectWBSID == subProjectWBSNode.ID && a.WBSValue == code).ToList();
if (hasShareInfo2.Count > 0)
{
throw new Formula.Exceptions.BusinessException(errorExceptionPre + "【" + subProject.GetValue("Name") + "】下的专业【" + majorNode.GetValue("MajorName") + "】拥有共享区文件，不能删除。");
}
#endregion
#region 校验专业里程碑
if (finishMileStones.Exists(a => a.WBSID == subProjectWBSNode.ID && (
(!string.IsNullOrEmpty(a.MajorValue) && a.MajorValue == code) ||
(!string.IsNullOrEmpty(a.OutMajorValue) && a.OutMajorValue.Split(',').Contains(code))
)))
{
throw new Formula.Exceptions.BusinessException(errorExceptionPre + "【" + subProject.GetValue("Name") + "】下的专业【" + majorNode.GetValue("MajorName") + "】已经有相关里程碑完成，不能删除。");
}
#endregion
}
}
}
}
#endregion
}
protected WhereConditon ListWhereSql(ListCondition condition)
{
WhereConditon wcd = new WhereConditon();
wcd.DBPara = new Dictionary <string, object>();
EntryModel model = JsonHelper.Deserialize <EntryModel>(condition.ListModelString);
if (model == null)
{
return(wcd);
}
if (DataConvert.ToString(model.AssetsScrapNo) != "")
{
wcd.Sql += @" and AssetsScrap.assetsScrapNo like '%'+@assetsScrapNo+'%'";
wcd.DBPara.Add("assetsScrapNo", model.AssetsScrapNo);
}
if (DataConvert.ToString(model.AssetsScrapName) != "")
{
wcd.Sql += @" and AssetsScrap.assetsScrapName like '%'+@assetsScrapName+'%'";
wcd.DBPara.Add("assetsScrapName", model.AssetsScrapName);
}
if (DataConvert.ToString(model.AssetsNo) != "")
{
wcd.Sql += @" and Assets.assetsNo like '%'+@assetsNo+'%'";
wcd.DBPara.Add("assetsNo", model.AssetsNo);
}
if (DataConvert.ToString(model.AssetsName) != "")
{
wcd.Sql += @" and Assets.assetsName like '%'+@assetsName+'%'";
wcd.DBPara.Add("assetsName", model.AssetsName);
}
if (DataConvert.ToString(model.AssetsTypeId) != "")
{
wcd.Sql += @" and Assets.assetsTypeId like '%'+@assetsTypeId+'%'";
wcd.DBPara.Add("assetsTypeId", model.AssetsTypeId);
}
if (DataConvert.ToString(model.ScrapTypeId) != "")
{
wcd.Sql += @" and AssetsScrapDetail.scrapTypeId like '%'+@scrapTypeId+'%'";
wcd.DBPara.Add("scrapTypeId", model.ScrapTypeId);
}
if (DataConvert.ToString(model.AssetsClassId) != "")
{
wcd.Sql += @" and Assets.assetsClassId like '%'+@assetsClassId+'%'";
wcd.DBPara.Add("assetsClassId", model.AssetsClassId);
}
if (DataConvert.ToString(model.DepartmentId) != "")
{
wcd.Sql += @" and Assets.departmentId like '%'+@departmentId+'%'";
wcd.DBPara.Add("departmentId", model.DepartmentId);
}
if (DataConvert.ToString(model.ScrapDate1) != "")
{
wcd.Sql += @" and AssetsScrapDetail.scrapDate>=@scrapDate1";
wcd.DBPara.Add("scrapDate1", DataConvert.ToString(model.ScrapDate1) + " 00:00:00");
}
if (DataConvert.ToString(model.ScrapDate2) != "")
{
wcd.Sql += @" and AssetsScrapDetail.scrapDate<=@scrapDate2";
wcd.DBPara.Add("scrapDate2", DataConvert.ToString(model.ScrapDate2) + " 23:59:59");
}
return(wcd);
}
private void ProcurementRegister_Load(object sender, EventArgs e)
{
string jsoni = JsonHelper.loadProjectInfo(Settings.Default.Username);
List <ProjectModel> projectListModel = JsonConvert.DeserializeObject <List <ProjectModel> >(jsoni);
projectModel = projectModel.getProjectModel(Settings.Default.ProjectID, projectListModel);
txtProcurementRegisterProjectName.Text = projectModel.ProjectName;
txtProjectManagerName.Text = projectModel.ProjectManager;
txtProcurementManager.Text = projectModel.ProcurementManager;
dgvProcurementRegister.Columns.Add("colPO", "PO #");
dgvProcurementRegister.Columns.Add("colItemTitle", "Item Title");
dgvProcurementRegister.Columns.Add("colItemDesc", "Item Description");
dgvProcurementRegister.Columns.Add("colQuantity", "Quantity");
dgvProcurementRegister.Columns.Add("colUnitPrice", "Unit Price");
dgvProcurementRegister.Columns.Add("colTotalPrice", "Total Price");
dgvProcurementRegister.Columns.Add("colReqByDate", "Required By Date");
dgvProcurementRegister.Columns.Add("colCompany", "Company");
dgvProcurementRegister.Columns.Add("colContactName", "Contact Name");
dgvProcurementRegister.Columns.Add("colContactPhNo", "Contact Ph. NO.");
dgvProcurementRegister.Columns.Add("colPOStatus", "PO Status");
dgvProcurementRegister.Columns.Add("colPODate", "PO Date");
dgvProcurementRegister.Columns.Add("colDeliveryStatus", "Delivery Status");
dgvProcurementRegister.Columns.Add("colDeliveryDate", "Delivery Date");
dgvProcurementRegister.Columns.Add("colPaymentMethod", "Payment Method");
dgvProcurementRegister.Columns.Add("colPaymentStatus", "Payment Status");
dgvProcurementRegister.Columns.Add("colPaymentDate", "Payment Date");
string json = JsonHelper.loadDocument(Settings.Default.ProjectID, "ProcurementRegister");
newProcurementRegisterModel = new ProcurementRegisterModel();
currentProcurementRegisterModel = new ProcurementRegisterModel();
if (json != "")
{
versionControl = JsonConvert.DeserializeObject <VersionControl <ProcurementRegisterModel> >(json);
newProcurementRegisterModel = JsonConvert.DeserializeObject <ProcurementRegisterModel>(versionControl.getLatest(versionControl.DocumentModels));
currentProcurementRegisterModel = JsonConvert.DeserializeObject <ProcurementRegisterModel>(versionControl.getLatest(versionControl.DocumentModels));
txtProjectManagerName.Text = currentProcurementRegisterModel.ProjectManagerName;
txtProcurementRegisterProjectName.Text = currentProcurementRegisterModel.ProjectName;
txtProcurementManager.Text = currentProcurementRegisterModel.ProcurementManagerName;
foreach (var row in currentProcurementRegisterModel.procurementEntries)
{
dgvProcurementRegister.Rows.Add(new string[] { row.PO_Number.ToString(),
row.ItemTitle,
row.ItemDescription,
row.Quantity.ToString(),
row.UnitPrice.ToString(),
row.TotalPrice.ToString(),
row.RequiredByDate,
row.Company,
row.ContactName,
row.ContactPhoneNumber,
row.PO_Status,
row.PO_Date,
row.DeliveryStatus,
row.DeliveryDate,
row.PaymentMethod,
row.PaymentStatus,
row.PaymentDate });
}
}
else
{
versionControl = new VersionControl <ProcurementRegisterModel>();
versionControl.DocumentModels = new List <VersionControl <ProcurementRegisterModel> .DocumentModel>();
}
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="columns">要取的列名（逗号分开）</param>
/// <param name="order">排序</param>
/// <param name="pageSize">每页大小</param>
/// <param name="pageIndex">当前页</param>
/// <param name="where">查询条件</param>
/// <param name="totalCount">总记录数</param>
public string GetPager(string tableName, string columns, string order, int pageSize, int pageIndex, string where, out int totalCount)
{
DataTable dt = SqlPagerHelper.GetPager(tableName, columns, order, pageSize, pageIndex, where, out totalCount);
return(JsonHelper.ToJson(dt));
}
public int Compare(MonthlyReportDetail x, MonthlyReportDetail y)
{
if (x == null)
{
return(1);
}
if (y == null)
{
return(-1);
}
if (x.CompanyProperty1 != "筹备门店" && y.CompanyProperty1 != "筹备门店")
{
//完成和未完成对比
if ((x.IsMissTarget && !y.IsMissTarget) || (x.NAccumulativeDifference < 0 && y.NAccumulativeDifference >= 0))
{
return(1);
}
if ((!x.IsMissTarget && y.IsMissTarget) || (x.NAccumulativeDifference >= 0 && y.NAccumulativeDifference < 0))
{
return(-1);
}
}
if (string.IsNullOrEmpty(x.NAccumulativeActualRate))
{
return(1);
}
if (string.IsNullOrEmpty(y.NAccumulativeActualRate))
{
return(-1);
}
//计划实际均为0的显示排序
if (x.NAccumulativePlanAmmount == 0 && x.NAccumulativeActualAmmount == 0)
{
return(-1);
}
if (y.NAccumulativePlanAmmount == 0 && y.NAccumulativeActualAmmount == 0)
{
return(1);
}
ActualRate tx = JsonHelper.Deserialize <ActualRate>(x.NAccumulativeActualRate);
ActualRate ty = JsonHelper.Deserialize <ActualRate>(y.NAccumulativeActualRate);
//这里RateType=1 ：数字， RateType =2 :增亏，减亏 RateType=3：超计划
if (tx.RateType > ty.RateType) //增亏 ，减亏，超计划
{
return(1);
}
if (tx.RateType == ty.RateType) //当类型相同时，这里特殊处理增亏，减亏
{
if (tx.Rate < ty.Rate)
{
if (tx.RateType != 1 && x.IsMissTarget)
{
return(-1);
}//筹备门店的单独算法 Update 2015-5-14 Start
else if (tx.RateType != 1 && x.IsMissTarget == false)
{
if (x.NAccumulativeDisplayRate.Substring(0, 2) == "增亏")
{
return(-1);
}
else
{
return(1);
}
}
//筹备门店的单独算法 Update 2015-5-14 End
return(1);
}
else if (tx.Rate == ty.Rate)
{
if (x.NAccumulativeActualAmmount < y.NAccumulativeActualAmmount)
{
return(1);
}
else if (x.NAccumulativeActualAmmount == y.NAccumulativeActualAmmount)
{
return(0);
}
else
{
return(-1);
}
}
else
{
if (tx.RateType != 1 && x.IsMissTarget)
{
return(1);
}//筹备门店的单独算法 Update 2015-5-14 Start
else if (tx.RateType != 1 && x.IsMissTarget == false)
{
if (x.NAccumulativeDisplayRate.Substring(0, 2) == "增亏")
{
return(1);
}
else
{
return(-1);
}
}//筹备门店的单独算法 Update 2015-5-14 End
return(-1);
}
}
else
{
return(-1);
}
}
private void Login(string email, string pass)
{
_jsonHelper = new JsonHelper<object>();
_cometProcessor = new CometClientProcessor();
_playerService = new PlayerService();
Player player = new Player();
player.password = pass;
player.email = email;
_playerService = new PlayerService();
if (_playerService.Verify(player))
{
player = _playerService.FindByEmail(LoginEmail.Text);
// Create Cookie
HttpCookie time = new HttpCookie("LastLogined", DateTime.Now.ToString());
HttpCookie userEmail = new HttpCookie("userEMail", player.email);
HttpCookie userId = new HttpCookie("userId", player.id.ToString());
time.Expires = DateTime.Now.AddDays(1);
userEmail.Expires = DateTime.Now.AddDays(1);
HttpContext.Current.Response.Cookies.Add(time);
HttpContext.Current.Response.Cookies.Add(userEmail);
HttpContext.Current.Response.Cookies.Add(userId);
HttpContext.Current.Session["Email"] = player.email;
HttpContext.Current.Session["Username"] = player.username;
Response.Redirect("Games.aspx"); //if true - so code after this not working - its abort the thread
}
else
{
string message = "<div class='alert alert-warning'>This email and password not found,Please register or try again</div>";
Alert.Text = message;
}
}
/// <summary>
/// 烘烤数据上传
/// </summary>
/// <param name="clamps"></param>
/// <returns></returns>
public static void UploadBatteryInfo(List <Clamp> clamps)
{
for (int i = 0; i < clamps.Count; i++)
{
var clamp = clamps[i];
var station = Station.StationList.FirstOrDefault(s => s.Id == clamp.OvenStationId);
if (station.GetPutType != GetPutType.烤箱)
{
clamp.IsUploaded = true;
LogHelper.WriteError(string.Format("异常,ID为{0}的夹具所属烤箱工位为：", clamp.Id, station.Name));
break;
}
var floor = station.GetFloor();
var oven = floor.GetOven();
try
{
var allIsPass = true;
for (int x = 0; x < clamp.Batteries.Count; x++)
{
var battery = clamp.Batteries[x];
if (!battery.Code.Contains("0000000000"))//样品电池数据不上传
{
var data = new BakingMesData()
{
Barcode = battery.Code,
TrayNo = clamp.CompleteCode,
StartTime = clamp.BakingStartTime.ToString("yyyy/MM/dd HH:mm:ss"),
EndTime = clamp.BakingStopTime.ToString("yyyy/MM/dd HH:mm:ss"),
Temperature = clamp.Temperature,
Vacuum = clamp.Vacuum,
MachineCode = station.Number
};
var info = JsonHelper.SerializeObject(data);
var result = wsProxy.UploadBakingData(info);
if (result.ResultCode == 0)
{
//LogHelper.WriteInfo(string.Format("上传mes成功，参数：{0}", info));
}
else
{
if (!result.ResultMsg.Contains("长度不是35或24"))
{
allIsPass = false;
}
LogHelper.WriteError(string.Format("上传mes失败，参数：{0} 原因：{1}", info, result.ResultMsg));
}
}
}
if (allIsPass)
{
clamp.IsUploaded = true;
LogHelper.WriteInfo(string.Format("上传mes成功，clamp.Id：{0}", clamp.Id));
}
//{"Barcode":"36ANCCB23140160N18E01C18E04H1000784","MachineCode":"BK02-04-01","TrayNo":"","StartTime":"2019\/6\/21 14:19:12","EndTime":"2019\/6\/21 14:19:12","Temperature":92.3,"Vacuum":12.3}
}
catch (System.Exception ex)
{
LogHelper.WriteError(ex);
}
}
}
private M_Product FillProductModel(ref DataTable table, M_Product proMod = null)
{
if (proMod == null)
{
proMod = new M_Product();
}
//DataTable gpdt = gpBll.GetGroupList();
/*--------------proMod------------*/
if (proMod.ID < 1)
{
proMod.Nodeid = NodeID;
proMod.FirstNodeID = nodeBll.SelFirstNodeID(proMod.Nodeid);
proMod.ModelID = ModelID;
proMod.TableName = modBll.SelReturnModel(ModelID).TableName;
proMod.AddUser = mu.UserName;
proMod.UserID = mu.UserID;
}
DataTable dt = fieldBll.GetModelFieldList(proMod.ModelID);
table = Call.GetDTFromMVC(dt, Request);
//-------------------------------------------
proMod.ProCode = RequestEx["ProCode"];
proMod.BarCode = RequestEx["BarCode"];
proMod.Proname = RequestEx["Proname"];
proMod.ShortProName = RequestEx["ShortProName"];
proMod.Kayword = RequestEx["tabinput"];
keyBll.AddKeyWord(proMod.Kayword, 1);
proMod.ProUnit = RequestEx["ProUnit"];
proMod.AllClickNum = DataConverter.CLng(RequestEx["AllClickNum"]);
proMod.Weight = DataConvert.CDouble(RequestEx["Weight_T"]);
proMod.ProClass = DataConverter.CLng(RequestEx["proclass_rad"]);
proMod.IDCPrice = RequestEx["IDC_Hid"];
proMod.PointVal = DataConverter.CLng(RequestEx["PointVal_T"]);
proMod.Proinfo = RequestEx["Proinfo"];
proMod.Procontent = RequestEx["Procontent"];
proMod.Clearimg = RequestEx["txt_Clearimg"];
proMod.Thumbnails = RequestEx["txt_Thumbnails"];
//proMod.Producer = RequestEx["Producer"];
//proMod.Brand = RequestEx["Brand"];
//proMod.Quota = DataConverter.CLng(Quota.Text);
//proMod.DownQuota = DataConverter.CLng(DownQuota.Text);
proMod.StockDown = DataConverter.CLng(RequestEx["StockDown"]);
proMod.Rate = DataConverter.CDouble(RequestEx["Rate"]);
proMod.Rateset = DataConverter.CLng(RequestEx["Rateset"]);
proMod.Dengji = DataConverter.CLng(RequestEx["Dengji"]);
proMod.ShiPrice = DataConverter.CDouble(RequestEx["ShiPrice"]);
proMod.LinPrice = DataConverter.CDouble(RequestEx["LinPrice"]);
//proMod.Preset = (OtherProject.SelectedValue == null) ? "" : OtherProject.SelectedValue; //促销
//proMod.Integral = DataConverter.CLng(Integral.Text);
//proMod.Propeid = DataConverter.CLng(Propeid.Text);
proMod.Recommend = DataConverter.CLng(RequestEx["Recommend"]);
//proMod.Largesspirx = DataConverter.CLng(Largesspirx.Text);
proMod.Largess = DataConvert.CLng(RequestEx["Largess"]);
//更新时间，若没有指定则为当前时间
proMod.UpdateTime = DataConverter.CDate(RequestEx["UpdateTime"]);
proMod.AddTime = DataConverter.CDate(RequestEx["AddTime"]);
proMod.ModeTemplate = RequestEx["ModeTemplate_hid"];
//proMod.bookDay = DataConverter.CLng(BookDay_T.Text);
proMod.BookPrice = DataConverter.CDouble(RequestEx["BookPrice"]);
proMod.FarePrice = RequestEx["FareTlp_Rad"];
//proMod.UserShopID = DataConvert.CLng(RequestEx["UserShopID"]);//店铺页面应该禁止此项
proMod.UserType = DataConverter.CLng(RequestEx["UserPrice_Rad"]);
proMod.Quota = DataConvert.CLng(RequestEx["Quota_Rad"]);
proMod.DownQuota = DataConvert.CLng(RequestEx["DownQuota_Rad"]);
switch (proMod.UserType)
{
case 1:
proMod.UserPrice = RequestEx["UserPrice"];
break;
case 2:
proMod.UserPrice = RequestEx["Price_Group_Hid"];
break;
}
switch (proMod.Quota)
{
case 0:
break;
case 2:
proMod.Quota_Json = RequestEx["Quota_Group_Hid"];
break;
}
switch (proMod.DownQuota)
{
case 0:
break;
case 2:
proMod.DownQuota_Json = RequestEx["DownQuota_Group_Hid"];
break;
}
proMod.Sales = DataConverter.CLng(RequestEx["Sales_Chk"]);
proMod.Istrue = DataConverter.CLng(RequestEx["istrue_chk"]);
proMod.Ishot = DataConverter.CLng(RequestEx["ishot_chk"]);
proMod.Isnew = DataConverter.CLng(RequestEx["isnew_chk"]);
proMod.Isbest = DataConverter.CLng(RequestEx["isbest_chk"]);
proMod.Allowed = DataConverter.CLng(RequestEx["Allowed"]);
proMod.GuessXML = RequestEx["GuessXML"];
proMod.Wholesalesinfo = RequestEx["ChildPro_Hid"];
proMod.DownCar = DataConvert.CLng(RequestEx["DownCar"]);
////捆绑商品
if (!string.IsNullOrEmpty(RequestEx["Bind_Hid"]))
{
//获取绑定商品
DataTable binddt = JsonHelper.JsonToDT(RequestEx["Bind_Hid"]);
proMod.BindIDS = StrHelper.GetIDSFromDT(binddt, "ID");
}
else
{
proMod.BindIDS = "";
}
return(proMod);
}
public static TaskDTO[] GetAllTasksSuccess()
{
//_responder = GameObject.FindGameObjectWithTag("MainCamera").GetComponent<Responder>();
//_responder.Request("get_all_task_success", "");
return(JsonHelper.GetArrayFromJson <TaskDTO>(_responder.Responce));
}
/// <summary>
/// 根据用户编号，查询该用户信息
/// </summary>
/// <param name="uid">用户编号</param>
/// <returns></returns>
public string GetUserModelByUserId(int uid)
{
sys_UsersModel userModel = sys_UserDAL.GetUsersModelByUserId(uid);
return(JsonHelper.ToJson(userModel));
}
public string GetO()
{
string opennode = Request["node"];
int pid = 0;//int.Parse(Request["id"].ToString());
List<AutekInfo.Model.Emp_Dept> list = new AutekInfo.BLL.Emp_Dept().GetModelList("").OrderBy(dept => dept.dept_order).ThenBy(dept => dept.dept_name).ToList();
JsonHelper js = new JsonHelper();
string json = new JsonHelper().GetOcharTree<AutekInfo.Model.Emp_Dept>(list, "dept_id", "dept_pid", "dept_name", pid);
if (!String.IsNullOrEmpty(opennode))
{
json=json.Replace("\"text\":\"公司\",\"state\":\"open\"", "\"text\":\"公司\",\"state\":\"open\"");
}
return json;
}
private void CheckTables(string jsonText)
{
if (string.IsNullOrEmpty(jsonText))
{
ShowMessage($"版本{this.EndVersion}的初始化json文件不存在，不执行数据库校验...");
ShowMessage("升级已经完成，请留意观察JieLink中心使用是否正常...");
return;
}
StringBuilder exceptMessage = new StringBuilder();
DBVersionScript script = JsonHelper.DeserializeObject <DBVersionScript>(jsonText);
foreach (var table in script.TableList)
{
if (table.Type == 1)
{
ShowMessage($"正在校验{table.TableName}表...");
if (TableIsExists(table.TableName))
{
Table dbTable = GetTable(table.TableName);
List <Column> columns = table.ColumnList.Where(x => !dbTable.ColumnList.Exists(y => x.Field.Equals(y.Field))).ToList();
foreach (Column column in columns)
{
StringBuilder builder = new StringBuilder();
builder.Append($"ALTER TABLE `{table.TableName}` Add COLUMN `{column.Field}` {column.Type}");
if (!column.IsNull)
{
builder.Append(" NOT NULL");
}
if (!string.IsNullOrEmpty(column.Default))
{
builder.Append($" DEFAULT '{column.Default}'");
}
builder.Append(" COLLATE utf8_unicode_ci;");
ShowMessage($"添加{column.Field}字段...");
try
{
MySqlHelperEx.ExecuteNonQueryEx(EnvironmentInfo.ConnectionString, builder.ToString());
}
catch (Exception)
{
exceptMessage.Append($"-- {table.TableName}表添加{column.Field}字段失败...").Append(Environment.NewLine);
exceptMessage.Append(builder.ToString()).Append(Environment.NewLine);
}
}
}
else
{
ShowMessage($"创建{table.TableName}表...");
string result = CreateTable(table);
if (!string.IsNullOrEmpty(result))
{
exceptMessage.Append(result).Append(Environment.NewLine);
}
}
}
}
ShowMessage("数据库校验完成...");
if (string.IsNullOrEmpty(exceptMessage.ToString()))
{
ShowMessage("升级已经完成，请留意观察JieLink中心使用是否正常...");
}
else
{
ShowMessage("升级已经完成，以下脚本执行异常，需要人工处理：");
ShowMessage(exceptMessage.ToString());
}
}
public int Compare(MonthlyReportDetail x, MonthlyReportDetail y)
{
if (x == null)
{
return(1); // 两两比较 1：在上 ， -1 ：在下 0:无序排列
}
if (y == null)
{
return(-1);
}
//完成和未完成对比
if ((x.IsMissTargetCurrent && !y.IsMissTargetCurrent) || (x.NDifference < 0 && y.NDifference >= 0))
{
return(1);
}
if ((!x.IsMissTargetCurrent && y.IsMissTargetCurrent) || (x.NDifference >= 0 && y.NDifference < 0))
{
return(-1);
}
//计划实际均为0的显示排序
if (x.NPlanAmmount == 0 && x.NActualAmmount == 0)
{
return(1);
}
if (y.NPlanAmmount == 0 && y.NActualAmmount == 0)
{
return(-1);
}
ActualRate tx = JsonHelper.Deserialize <ActualRate>(x.NActualRate);
ActualRate ty = JsonHelper.Deserialize <ActualRate>(y.NActualRate);
if (tx.RateType > ty.RateType)
{
return(1);
}
if (tx.RateType == ty.RateType)
{
if (tx.Rate < ty.Rate)
{
if (tx.RateType != 1 && x.IsMissTargetCurrent)
{
return(-1);
}//筹备门店的单独算法 Update 2015-5-14 Start
else if (tx.RateType != 1 && x.IsMissTargetCurrent == false)
{
if (x.NDisplayRate.Substring(0, 2) == "增亏")
{
return(-1);
}
else
{
return(1);
}
}
//筹备门店的单独算法 Update 2015-5-14 End
return(1);
}
else if (tx.Rate == ty.Rate)
{
if (x.NActualAmmount < y.NActualAmmount)
{
return(1);
}
else if (x.NActualAmmount == y.NActualAmmount)
{
return(0);
}
else
{
return(-1);
}
}
else
{
if (tx.RateType != 1 && x.IsMissTargetCurrent)
{
return(1);
}
else if (tx.RateType != 1 && x.IsMissTargetCurrent == false) //筹备门店的单独算法
{
if (x.NDisplayRate.Substring(0, 2) == "增亏")
{
return(1);
}
else
{
return(-1);
}
}
return(-1);
}
}
else
{
return(-1);
}
}
private void Login(CometAsyncResult clientState, string email, string pass)
{
_jsonHelper = new JsonHelper<object>();
_cometProcessor = new CometClientProcessor();
_playerService = new PlayerService();
Player player = new Player();
player.password = pass;
player.email = email;
_playerService = new PlayerService();
if (_playerService.Verify(player))
{
player = _playerService.FindByEmail(email);
// Create Cookie
HttpCookie time = new HttpCookie("LastLogined", DateTime.Now.ToString());
HttpCookie userEmail = new HttpCookie("userEMail", player.email);
HttpCookie userId = new HttpCookie("userId", player.id.ToString());
time.Expires = DateTime.Now.AddDays(1);
userEmail.Expires = DateTime.Now.AddDays(1);
clientState.HttpContext.Response.Cookies.Add(time);
clientState.HttpContext.Response.Cookies.Add(userEmail);
clientState.HttpContext.Response.Cookies.Add(userId);
currentAsyncRequestState.HttpContext.Session["Email"] = player.email;
currentAsyncRequestState.HttpContext.Session["Username"] = player.username;
_jsonHelper.message = "Welcome " + player.username + "!";
_jsonHelper.status = 200;
string responseJSON = Newtonsoft.Json.JsonConvert.SerializeObject(_jsonHelper);
clientState.HttpContext.Response.Write(responseJSON);
}
else
{
_jsonHelper.message = "This email and password not found,Please register or try again";
_jsonHelper.status = 404;
string responseJSON = Newtonsoft.Json.JsonConvert.SerializeObject(_jsonHelper);
clientState.HttpContext.Response.Write(responseJSON);
}
clientState.CompleteRequest();
}
private string GetYdCollectOnExport(string jsonDataTable)
{
string fn = "/XTemp/采集历史报表.xls";
string filePath = System.Web.HttpContext.Current.Server.MapPath(@"/XTemp");
if (System.IO.Directory.Exists(filePath) == false)
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = System.Web.HttpContext.Current.Server.MapPath(fn);
if (System.IO.File.Exists(filename))/*先删除已存在的文件，再汇出Excel*/
{
System.IO.File.Delete(filename);
}
DataTable dtSource = new DataTable();
if (jsonDataTable.Length > 10)
{
dtSource = JsonHelper.ToDataTable(jsonDataTable);
}
string funType = dtSource.Rows.Count == 0 ? "" : funType = CommFunc.ConvertDBNullToString(dtSource.Rows[0]["FunType"]);
string content = "";
System.Reflection.FieldInfo info = typeof(V0Fun).GetField(funType);
if (info != null)
{
var obj = info.GetCustomAttributes(typeof(Describe), false);
if (obj != null)
{
foreach (Describe md in obj)
{
content = md.describe;
}
}
}
Excel.ExcelCellStyle columnCellStyle0 = new Excel.ExcelCellStyle();
columnCellStyle0 = new Excel.ExcelCellStyle()
{
DataFormart = "0.00",
HorizontalAlignment = NPOI.SS.UserModel.HorizontalAlignment.RIGHT
};
Excel.ExcelCellStyle columnCellStyle1 = new Excel.ExcelCellStyle();
columnCellStyle1 = new Excel.ExcelCellStyle()
{
DataFormart = "yyyy-MM-dd HH:mm:ss",
};
Excel.ExcelColumnCollection columns = new Excel.ExcelColumnCollection();
columns.Add(new Excel.ExcelColumn("序号", "RowId", 5)
{
IsSetWith = true
});
columns.Add(new Excel.ExcelColumn("建筑", "CoStrcName", 15)
{
IsSetWith = true
});
columns.Add(new Excel.ExcelColumn("房间", "CoName", 15)
{
IsSetWith = true
});
columns.Add(new Excel.ExcelColumn("电表地址", "ModuleAddr", 15)
{
IsSetWith = true
});
columns.Add(new Excel.ExcelColumn("采集时间", "TagTime", 20)
{
IsSetWith = true
});
columns.Add(new Excel.ExcelColumn("读数", "LastVal", 15)
{
IsSetWith = true
});
Excel.ExcelOparete excel = new Excel.ExcelOparete("采集历史报表");
excel.SetObjectValue("采集历史报表" + (content == "" ? "" : ":" + content), 0, 0, 3);
excel.SetColumnName(columns, 1, 0);
excel.SetColumnValue(columns, dtSource.Select(), 2, 0);
excel.SaveExcelByFullFileName(filename);
return(fn);
}
private void btnSave_Click(object sender, EventArgs e)
{
List <ProcurementRegisterModel.ProcurementEntry> procurementEntries = new List <ProcurementRegisterModel.ProcurementEntry>();
int procurementEntryCount = dgvProcurementRegister.Rows.Count;
for (int i = 0; i < procurementEntryCount - 1; i++)
{
ProcurementRegisterModel.ProcurementEntry procurementEntry = new ProcurementRegisterModel.ProcurementEntry();
string poNum = dgvProcurementRegister.Rows[i].Cells[0].Value?.ToString() ?? "";
var itemTitle = dgvProcurementRegister.Rows[i].Cells[1].Value?.ToString() ?? "";
var itemDesc = dgvProcurementRegister.Rows[i].Cells[2].Value?.ToString() ?? "";
var quantity = dgvProcurementRegister.Rows[i].Cells[3].Value?.ToString() ?? "";
var unitPrice = dgvProcurementRegister.Rows[i].Cells[4].Value?.ToString() ?? "";
var totalPrice = dgvProcurementRegister.Rows[i].Cells[5].Value?.ToString() ?? "";
var reqByDate = dgvProcurementRegister.Rows[i].Cells[6].Value?.ToString() ?? "";
var company = dgvProcurementRegister.Rows[i].Cells[7].Value?.ToString() ?? "";
var contactName = dgvProcurementRegister.Rows[i].Cells[8].Value?.ToString() ?? "";
var contactPhNum = dgvProcurementRegister.Rows[i].Cells[9].Value?.ToString() ?? "";
var poStatus = dgvProcurementRegister.Rows[i].Cells[10].Value?.ToString() ?? "";
var poDate = dgvProcurementRegister.Rows[i].Cells[11].Value?.ToString() ?? "";
var deliveryStatus = dgvProcurementRegister.Rows[i].Cells[12].Value?.ToString() ?? "";
var deliveryDate = dgvProcurementRegister.Rows[i].Cells[13].Value?.ToString() ?? "";
var payMethod = dgvProcurementRegister.Rows[i].Cells[14].Value?.ToString() ?? "";
var payStatus = dgvProcurementRegister.Rows[i].Cells[15].Value?.ToString() ?? "";
var payDate = dgvProcurementRegister.Rows[i].Cells[16].Value?.ToString() ?? "";
try
{
procurementEntry.PO_Number = int.Parse(poNum);
}
catch
{
MessageBox.Show("The PO # field must contain only numbers.");
return;
}
procurementEntry.ItemTitle = itemTitle;
procurementEntry.ItemDescription = itemDesc;
try
{
procurementEntry.Quantity = int.Parse(quantity);
}
catch
{
MessageBox.Show("The Quantity field must contain only numbers.");
return;
}
try
{
procurementEntry.UnitPrice = int.Parse(unitPrice);
}
catch
{
MessageBox.Show("The Unit Price field must contain only numbers.");
return;
}
try
{
procurementEntry.TotalPrice = int.Parse(totalPrice);
}
catch
{
MessageBox.Show("The Total Price field must contain only numbers.");
return;
}
procurementEntry.RequiredByDate = reqByDate;
procurementEntry.Company = company;
procurementEntry.ContactName = contactName;
procurementEntry.ContactPhoneNumber = contactPhNum;
procurementEntry.PO_Status = poStatus;
procurementEntry.PO_Date = poDate;
procurementEntry.DeliveryStatus = deliveryStatus;
procurementEntry.DeliveryDate = deliveryDate;
procurementEntry.PaymentMethod = payMethod;
procurementEntry.PaymentStatus = payStatus;
procurementEntry.PaymentDate = payDate;
procurementEntries.Add(procurementEntry);
}
newProcurementRegisterModel.procurementEntries = procurementEntries;
newProcurementRegisterModel.ProcurementManagerName = txtProcurementManager.Text;
newProcurementRegisterModel.ProjectName = txtProcurementRegisterProjectName.Text;
newProcurementRegisterModel.ProjectManagerName = txtProjectManagerName.Text;
List <VersionControl <ProcurementRegisterModel> .DocumentModel> documentModels = versionControl.DocumentModels;
if (!versionControl.isEqual(currentProcurementRegisterModel, newProcurementRegisterModel))
{
VersionControl <ProcurementRegisterModel> .DocumentModel documentModel = new VersionControl <ProcurementRegisterModel> .DocumentModel(newProcurementRegisterModel, DateTime.Now, VersionControl <ProcurementRegisterModel> .generateID());
documentModels.Add(documentModel);
string json = JsonConvert.SerializeObject(versionControl);
currentProcurementRegisterModel = JsonConvert.DeserializeObject <ProcurementRegisterModel>(JsonConvert.SerializeObject(newProcurementRegisterModel));
JsonHelper.saveDocument(json, Settings.Default.ProjectID, "ProcurementRegister");
MessageBox.Show("Procurement register saved successfully", "save", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("No changes were made.", "save", MessageBoxButtons.OK);
}
}
private async void Publicar_Clicked(object sender, EventArgs e)
{
//Cadastro do Endereço
Endereco enderecoCadastrado = new Endereco();
enderecoCadastrado.CepEndereco = cepDoEvento;
enderecoCadastrado.CidadeEndereco = cidadeDoEvento;
enderecoCadastrado.BairroEndereco = bairroDoEvento;
enderecoCadastrado.NumeroEndereco = numeroDoEvento;
enderecoCadastrado.ComplementoEndereco = complementoDoEvento.Replace("'", "''");
enderecoCadastrado.LogradouroEndereco = enderecoDoEvento;
var jsonEndereco = JsonConvert.SerializeObject(enderecoCadastrado);
var cadastroEndereco = new JsonHelper().enviarPostParaServidorJson(jsonEndereco, "Enderecoes");
Endereco enderecoConvertido = JsonConvert.DeserializeObject <Endereco>(cadastroEndereco);
//Endereco enderecoConvertido = (Endereco)cadastroEndereco;
//Cadastro do Evento
Evento evento = new Evento();
evento.IdCriadorDoEvento = idDoCriadorEvento;
evento.NomeDoEvento = nomeDoEvento;
evento.CategoriaDoEvento = categoriaDoEvento;
evento.DescricaoDoEvento = descricaoDoEvento;
switch (usuarioL.TipoUsuario)
{
case "Uma pessoa": //Pessoa física = evento privado
evento.TipoDoEvento = true;
break;
case "Uma empresa": //Pessoa jurídica = evento público
evento.TipoDoEvento = false;
break;
}
evento.DataDoEvento = dataDoEvento;
evento.UrlDoEvento = urlDoEvento;
evento.IdEnderecoDoEvento = enderecoConvertido.IdEndereco; //id do endereço cadastrado acima
var jsonEvento = JsonConvert.SerializeObject(evento);
var cadastroEvento = new JsonHelper().enviarPostParaServidorJson(jsonEvento, "Eventos");
Evento eventoCadastrado = JsonConvert.DeserializeObject <Evento>(cadastroEvento);
//Cadastro da imagem principal
Galeria imagemPrincipal = new Galeria();
//imagemPrincipal.IdEventoGaleria = eventoCadastrado.IdEvento;
imagemPrincipal.imagemGaleria = imagemPrincipalDoEvento;
imagemPrincipal.imagemPrincipal = true;
var jsonGaleria = JsonConvert.SerializeObject(imagemPrincipal);
var cadastroImagem = new JsonHelper().enviarPostParaServidorJson(jsonGaleria, "Galerias");
Galeria imagemCadastrada = JsonConvert.DeserializeObject <Galeria>(cadastroImagem);
//Alocação da imagem em GALERIA - EVENTO
Galeria_Evento galEven = new Galeria_Evento();
galEven.IdEvento = eventoCadastrado.IdEvento;
galEven.IdGaleria = imagemCadastrada.idGaleria;
var jsonGaleriaEvento = JsonConvert.SerializeObject(galEven);
var cadastroImagemEvento = new JsonHelper().enviarPostParaServidorJson(jsonGaleriaEvento, "Galeria_Evento");
//Galeria_Evento imagemEventoCadastrada = JsonConvert.DeserializeObject<Galeria_Evento>(jsonGaleriaEvento);
//await Navigation.PushModalAsync(new InicioDetalhes(usuarioL.Id, usuarioL.Login), true);
await DisplayAlert("É isso aí!", "Você publicou " + evento.NomeDoEvento + " e ele já pode ser visto.", "Partiu!");
Application.Current.MainPage = new NavigationPage(new InicioDetalhes(usuarioL.Id, usuarioL.Login));
/*if (respostaDoServidor != null)
* {
* await DisplayAlert(, "Bem-vindo ao EvenTop!", "Partiu!");
* await Navigation.PushModalAsync(new MainPage(), true);
* }
* else
* {
* await DisplayAlert("Hm.. tivemos um problema", "Não conseguimos encontrar sua conta!", "Tente novamente!");
* }*/
}
/// <summary>
/// 监听指定端口 接收客户端发来的消息
/// </summary>
private void ReceiveMessage()
{
IPEndPoint remoteIPEndPoint = new IPEndPoint(IPAddress.Any, 0);
while (true)
{
try
{
byte[] receiveBytes = receiveUdpClient.Receive(ref remoteIPEndPoint);
string message = Encoding.Unicode.GetString(receiveBytes, 0, receiveBytes.Length);
AddMsgToLog(string.Format("{0}:{1}", remoteIPEndPoint, message));
UserDTO dto = JsonConvert.DeserializeObject <UserDTO>(message, JsonHelper.GetIPJsonSettings());
switch (dto.LoginState)
{
case UserLoginState.Login:
User user = dto.LoginUser;
userList.Add(user);
AddMsgToLog(string.Format("用户{0}({1})加入", user.Name, user.IPAndPort));
string sendMsg = JsonConvert.SerializeObject(new UserDTO
{
LoginState = UserLoginState.Accept,
ServerTcpPort = tcpPort
});
SendToClient(user, sendMsg);
AddMsgToLog(string.Format("向{0}({1})发出：[{2}]", user.Name, user.IPAndPort, sendMsg));
foreach (User otherUser in userList)
{
if (otherUser.IPAndPort.ToString() != user.IPAndPort.ToString())
{
SendToClient(otherUser, message);
}
}
AddMsgToLog(string.Format("广播：[{0}]", message));
break;
case UserLoginState.Logout:
for (int i = 0; i < userList.Count; i++)
{
if (userList[i].ID == dto.LoginUser.ID)
{
AddMsgToLog(string.Format("用户{0}({1})退出", userList[i].Name, userList[i].IPAndPort));
// 移除用户
userList.RemoveAt(i);
}
}
for (int i = 0; i < userList.Count; i++)
{
// 广播注销消息
SendToClient(userList[i], message);
}
AddMsgToLog(string.Format("广播:[{0}]", message));
break;
}
}
catch
{
break;
}
}
AddMsgToLog(string.Format("服务线程{0}终止", serverIPEndPoint));
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string pageindex = HttpContext.Current.Request.Params["pageindex"];
if (string.IsNullOrEmpty(pageindex))
{
HttpContext.Current.Response.Write("pageindex error");
return;
}
string pagesize = HttpContext.Current.Request.Params["pagesize"];
if (string.IsNullOrEmpty(pagesize))
{
HttpContext.Current.Response.Write("pagesize error");
return;
}
string MaterialDataNo = HttpContext.Current.Request.Params["materialDataNo"];
string MaterialDataName = HttpContext.Current.Request.Params["materialDataName"];
string Supplier = HttpContext.Current.Request.Params["supplier"];
string StoreId = HttpContext.Current.Request.Params["storeId"];
string sqlwhere = "";
if (MaterialDataNo.Trim() != "")
{
sqlwhere += " AND a.MaterialDataNo like N'%" + MaterialDataNo.Trim() + "%'";
}
if (MaterialDataName.Trim() != "")
{
sqlwhere += " AND a.MaterialDataName like N'%" + MaterialDataName.Trim() + "%'";
}
if (Supplier.Trim() != "")
{
sqlwhere += " AND a.Supplier like N'%" + Supplier.Trim() + "%'";
}
string sqlwherein = "select MaterialId from Material_W_S where 1=1 ";
if (StoreId.Trim() != "")
{
sqlwherein += " AND StoreId = N'" + StoreId.Trim() + "'";
sqlwhere += "AND a.ID in (" + sqlwherein + ")";
}
string sqlCount = string.Format(@"select count(1) from [MaterialData](nolock) a
where 1=1 {0}", sqlwhere);
DataSet dscount = SQLHelper.GetDataSet(sqlCount);
string sqlSearch = string.Format(@"SELECT temp.*
FROM ( SELECT TOP ( {0} * {1} )
ROW_NUMBER() OVER ( ORDER BY a.[ID] DESC ) AS rownum ,
a.*
FROM MaterialData(nolock) a
where 1=1 {2}
) AS temp
WHERE temp.rownum > ( {0} * ( {1} - 1 ))
ORDER BY temp.[ID] DESC", pagesize, pageindex, sqlwhere);
DataSet dsSearch = SQLHelper.GetDataSet(sqlSearch);
string jsonText = "";
JsonHelper jsonHelper = new JsonHelper();
if (dsSearch != null && dsSearch.Tables[0].Rows.Count > 0)
{
jsonText = jsonHelper.DataTableToJson(dsSearch.Tables[0], int.Parse(dscount.Tables[0].Rows[0][0].ToString()));
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("tips");
dt.AcceptChanges();
DataRow dr = dt.NewRow();
dr["tips"] = "没有数据";
dt.Rows.Add(dr);
dt.AcceptChanges();
jsonText = jsonHelper.DataTableToJson(dt, 0);
}
HttpContext.Current.Response.Write(jsonText);
}
catch (Exception ex)
{
JsonHelper jsonHelper = new JsonHelper();
DataTable dt = new DataTable();
dt.Columns.Add("tips");
dt.AcceptChanges();
DataRow dr = dt.NewRow();
dr["tips"] = "没有数据";
dt.Rows.Add(dr);
dt.AcceptChanges();
string jsonText = jsonHelper.DataTableToJson(dt, 0);
HttpContext.Current.Response.Write(jsonText);
//HttpContext.Current.Response.End();
}
}
public long CountWhere([FromBody] JArray filters)
{
try
{
List <EntityParser.Filter> f = filters.ToObject <List <EntityParser.Filter> >(JsonHelper.GetJsonSerializer());
return(this.StateSalesTaxScrudViewRepository.CountWhere(f));
}
catch (UnauthorizedException)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Forbidden));
}
catch (MixERPException ex)
{
throw new HttpResponseException(new HttpResponseMessage
{
Content = new StringContent(ex.Message),
StatusCode = HttpStatusCode.InternalServerError
});
}
catch
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
// GET: MainMenu
public ActionResult Index()
{
string userjson = Request["userInfo"];
TUserInfo userdata = null;
if ((userjson == null) || (userjson == String.Empty))
{
if (Request["UserCode"] == null || Request["UserCode"] == String.Empty ||
Request["Password"] == null || Request["Password"] == String.Empty
)
{
return(RedirectToAction("Index", "UserInfo"));
}
else
{
string sUCode = Request["UserCode"];
string sUPwd = Request["Password"];
userdata = TUserInfoBLL.ULogin(sUCode, sUPwd);
}
}
else
{
userdata = JsonHelper.DeserializeJsonToObject <TUserInfo>(Request["userInfo"]);
}
if (userdata == null)
{
return(RedirectToAction("Index", "UserInfo"));
}
else
{
bool bSaveUser = false;
HttpCookie pwdCookie = null;
HttpCookie uerCodeCookie = null;
HttpCookie remberCookie = null;
if (Request.Cookies["UserCode"] != null)
{
uerCodeCookie = Request.Cookies["UserCode"];
}
if (Request.Cookies["rememberUser"] != null)
{
remberCookie = Request.Cookies["rememberUser"];
bSaveUser = remberCookie.Value == "true";
}
if (Request.Cookies["Password"] != null)
{
pwdCookie = Request.Cookies["Password"];
}
pwdCookie.Value = Security.UGetMd5Str(userdata.Uid.ToString() + userdata.Upassword);
pwdCookie.Path = "/";
uerCodeCookie.Path = "/";
remberCookie.Path = "/";
if (bSaveUser)
{
pwdCookie.Expires = DateTime.Now.AddDays(15);
uerCodeCookie.Expires = DateTime.Now.AddDays(15);
remberCookie.Expires = DateTime.Now.AddDays(15);
}
else
{
pwdCookie.Expires = DateTime.Now.AddDays(-1);
uerCodeCookie.Expires = DateTime.Now.AddDays(-1);
remberCookie.Expires = DateTime.Now.AddDays(-1);
}
Response.Cookies.Add(pwdCookie);
Response.Cookies.Add(uerCodeCookie);
Response.Cookies.Add(remberCookie);
return(View());
}
}
protected override void AfterGetData(DataTable dt, bool isNew, string upperVersionID)
{
if (isNew)
{
var projectInfoID = dt.Rows[0]["ProjectInfoID"].ToString();
var sql = string.Format("select * from S_W_WBS with(nolock) where ProjectInfoID = '{0}'", projectInfoID);
var wbsDT = this.ProjectSQLDB.ExecuteDataTable(sql);
sql = string.Format("select * from S_W_RBS where ProjectInfoID = '{0}'", projectInfoID);
var rbsDT = this.ProjectSQLDB.ExecuteDataTable(sql);
var schemeSubProject = JsonHelper.ToList(dt.Rows[0]["SubProjectList"].ToString());
var schemeMajorList = JsonHelper.ToList(dt.Rows[0]["MajorList"].ToString());
var roleCodes = BaseConfigFO.GetRoleDefineList().Select(a => a.RoleCode).ToArray();
if (schemeMajorList.Count() > 0)
{
var attendRoles = schemeMajorList[0].Keys.Where(a => roleCodes.Contains(a)).ToArray();
foreach (var subProject in schemeSubProject)
{
var subProjectWBSID = subProject.GetValue("SubProjectWBSID");
//如果没有子项WBSID，则说明异构结构中，专业直接挂在了阶段节点下
if (String.IsNullOrEmpty(subProjectWBSID))
{
subProjectWBSID = subProject.GetValue("PhaseWBSID");
}
if (string.IsNullOrEmpty(subProject.GetValue("RBSJson")))
{
#region 没有RBSJson
//没有RBSJson，说明所有专业都参与
//没有RBSJson，需要判断是否修改过专业人员
var schemeToWrite = new List <Dictionary <string, object> >();
var flag = false;
for (int i = 0; i < schemeMajorList.Count(); i++)
{
var schemeMajor = schemeMajorList[i];
var rbsToWrite = new Dictionary <string, object>();
rbsToWrite.SetValue("SortIndex", i);
rbsToWrite.SetValue("MajorName", schemeMajor.GetValue("MajorName"));
rbsToWrite.SetValue("MajorCode", schemeMajor.GetValue("MajorCode"));
rbsToWrite.SetValue("Valid", "1");
rbsToWrite.SetValue("IsChange", false);
var majorWBS = wbsDT.AsEnumerable().Where(a => a["ParentID"].ToString() == subProjectWBSID &&
a["Code"].ToString() == schemeMajor.GetValue("MajorCode")).ToArray();
if (majorWBS.Length == 0)
{
continue;
}
foreach (var aRole in attendRoles)
{
var rbsList = rbsDT.AsEnumerable().Where(a => a["WBSID"].ToString() == majorWBS[0]["ID"].ToString() &&
a["RoleCode"].ToString() == aRole).ToArray();
var userIDs = rbsList.Select(a => a["UserID"].ToString()).ToArray();
var userNames = rbsList.Select(a => a["UserName"].ToString()).ToArray();
rbsToWrite.SetValue(aRole, string.Join(",", userIDs));
rbsToWrite.SetValue(aRole + "Name", string.Join(",", userNames));
//判断aRole角色在rbs中和策划的专业人员是否相同
var isSame = true;
var schemeMajorRBS = schemeMajor.GetValue(aRole).Split(',');
if (userIDs.Length == schemeMajorRBS.Length)
{
var q = (from a in userIDs join b in schemeMajorRBS on a equals b select a).ToArray();
if (q.Length != userIDs.Length)
{
isSame = false;
}
}
//schemeMajor.GetValue(aRole)会产生空字符串
else if (!(userIDs.Length == 0 && schemeMajor.GetValue(aRole) == ""))
{
isSame = false;
}
if (!isSame)
{
flag = true;
rbsToWrite.SetValue("IsChange", true);
}
}
schemeToWrite.Add(rbsToWrite);
}
if (flag)
{
subProject.SetValue("RBSJson", JsonHelper.ToJson(schemeToWrite));
}
#endregion
}
else
{
#region RBSJson
//有RBSJson，替换人员
var schemeRBS = JsonHelper.ToList(subProject.GetValue("RBSJson"));
var tmpRBS = JsonHelper.ToList(JsonHelper.ToJson(schemeRBS));
for (int i = 0; i < schemeRBS.Count(); i++)
{
var sRBS = schemeRBS[i];
if (sRBS.GetValue("Valid") == "1")
{
var majorWBS = wbsDT.AsEnumerable().Where(a => a["ParentID"].ToString() == subProjectWBSID &&
a["Code"].ToString() == sRBS.GetValue("MajorCode")).ToArray();
if (majorWBS.Length == 0)
{
continue;
}
var roleDefines = sRBS.Keys.Where(a => roleCodes.Contains(a));
foreach (var roleDefine in roleDefines)
{
var rbsList = rbsDT.AsEnumerable().Where(a => a["WBSID"].ToString() == majorWBS[0]["ID"].ToString() &&
a["RoleCode"].ToString() == roleDefine).ToArray();
var userIDs = rbsList.Select(a => a["UserID"].ToString()).ToArray();
var userNames = rbsList.Select(a => a["UserName"].ToString()).ToArray();
var schemeUserIDs = tmpRBS[i].GetValue(roleDefine).Split(',');
tmpRBS[i].SetValue(roleDefine, string.Join(",", userIDs));
tmpRBS[i].SetValue(roleDefine + "Name", string.Join(",", userNames));
var isSame = true;
if (userIDs.Length == schemeUserIDs.Length)
{
var q = (from a in userIDs join b in schemeUserIDs on a equals b select a).ToArray();
if (q.Length != userIDs.Length)
{
isSame = false;
}
}
//schemeMajor.GetValue(aRole)会产生空字符串
else if (!(userIDs.Length == 0 && tmpRBS[i].GetValue(roleDefine) == ""))
{
isSame = false;
}
if (!isSame)
{
tmpRBS[i].SetValue("IsChange", true);
}
}
}
}
subProject.SetValue("RBSJson", JsonHelper.ToJson(tmpRBS));
#endregion
}
}
dt.Rows[0]["SubProjectList"] = JsonHelper.ToJson(schemeSubProject);
}
}
}
public override void Init()
{
base.Init();
_jsonHelper = new JsonHelper(_helperContext);
}
public IEnumerable <MixERP.Net.Entities.Core.FrequencySetup> GetWhere(long pageNumber, [FromBody] JArray filters)
{
try
{
List <EntityParser.Filter> f = filters.ToObject <List <EntityParser.Filter> >(JsonHelper.GetJsonSerializer());
return(this.FrequencySetupRepository.GetWhere(pageNumber, f));
}
catch (UnauthorizedException)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Forbidden));
}
catch (MixERPException ex)
{
throw new HttpResponseException(new HttpResponseMessage
{
Content = new StringContent(ex.Message),
StatusCode = HttpStatusCode.InternalServerError
});
}
catch
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
private void Register(CometAsyncResult clientState, string email, string user, string pass, string passConfirm)
{
_playerService = new PlayerService();
_jsonHelper = new JsonHelper<Object>();
string responseJSON = null;
if (pass == passConfirm)
{
Player newPlayer = new Player();
newPlayer.email = email;
newPlayer.username = user;
// kod zashivrovali v settere
newPlayer.password = pass;
newPlayer.image = "ehse netu picture";
newPlayer.registration_date = DateTime.Now;
if (!_playerService.CheckIfExists(newPlayer))
{
// do stuff here to log the user in ...
if (_playerService.Insert(newPlayer))
{
Login(clientState, newPlayer.email, newPlayer.password);
}
}
else
{
_jsonHelper.status = 405;
_jsonHelper.message = "This email is registered,Please login or register another one";
responseJSON = Newtonsoft.Json.JsonConvert.SerializeObject(_jsonHelper);
clientState.HttpContext.Response.Headers.Add("Content-type", "application/json");
clientState.HttpContext.Response.Write(responseJSON);
}
}
else
{
_jsonHelper.status = 406;
_jsonHelper.message = "Passwords doesn't match!";
responseJSON = Newtonsoft.Json.JsonConvert.SerializeObject(_jsonHelper);
HttpContext.Current.Response.Headers.Add("Content-type", "application/json");
HttpContext.Current.Response.Write(responseJSON);
}
}
public IEnumerable <Frapid.Account.Entities.User> GetWhere(long pageNumber, [FromBody] JArray filters)
{
try
{
List <Frapid.DataAccess.Models.Filter> f = filters.ToObject <List <Frapid.DataAccess.Models.Filter> >(JsonHelper.GetJsonSerializer());
return(this.UserRepository.GetWhere(pageNumber, f));
}
catch (UnauthorizedException)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Forbidden));
}
catch (DataAccessException ex)
{
throw new HttpResponseException(new HttpResponseMessage
{
Content = new StringContent(ex.Message),
StatusCode = HttpStatusCode.InternalServerError
});
}
#if !DEBUG
catch
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
#endif
}
public void Setup()
{
_jsonHelper = new DependencyManager().ConfigureStartupDependencies().GetInstance<JsonHelper>();
}
private List <ExpandoObject> ParseCollection(JArray collection)
{
return(JsonConvert.DeserializeObject <List <ExpandoObject> >(collection.ToString(), JsonHelper.GetJsonSerializerSettings()));
}
public ActionResult ToExcel()
{
string CompanyID = this.CompanyID;
int PageIndex = 1;
int PageSize = Int32.MaxValue;
string OrderNum = WebUtil.GetFormValue <string>("OrderNum");
int OrderType = WebUtil.GetFormValue <int>("OrderType", 0);
string CusName = WebUtil.GetFormValue <string>("CusName", string.Empty);
string CusNum = WebUtil.GetFormValue <string>("CusNum", string.Empty);
string Phone = WebUtil.GetFormValue <string>("Phone", string.Empty);
int Status = WebUtil.GetFormValue <int>("Status", 0);
int AuditeStatus = WebUtil.GetFormValue <int>("AuditeStatus", -1);
string ContractOrder = WebUtil.GetFormValue <string>("ContractOrder", string.Empty);
string CusOrderNum = WebUtil.GetFormValue <string>("CusOrderNum", string.Empty);
string BarCode = WebUtil.GetFormValue <string>("BarCode", string.Empty);
string ProductName = WebUtil.GetFormValue <string>("ProductName", string.Empty);
string BeginTime = WebUtil.GetFormValue <string>("BeginTime", string.Empty);
string EndTime = WebUtil.GetFormValue <string>("EndTime", string.Empty);
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("OrderNum", OrderNum);
dic.Add("OrderType", OrderType.ToString());
dic.Add("CusName", CusName);
dic.Add("CusNum", CusNum);
dic.Add("Phone", Phone);
dic.Add("Status", Status.ToString());
dic.Add("AuditeStatus", AuditeStatus.ToString());
dic.Add("ContractOrder", ContractOrder);
dic.Add("CusOrderNum", CusOrderNum);
dic.Add("BarCode", BarCode);
dic.Add("ProductName", ProductName);
dic.Add("BeginTime", BeginTime);
dic.Add("EndTime", EndTime);
string result = client.Execute(SaleApiName.SaleApiName_GetDetailList, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <SaleDetailEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <SaleDetailEntity> >(result);
List <SaleDetailEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("订单号"));
dt.Columns.Add(new DataColumn("产品名称"));
dt.Columns.Add(new DataColumn("产品编号"));
dt.Columns.Add(new DataColumn("产品规格"));
dt.Columns.Add(new DataColumn("单价"));
dt.Columns.Add(new DataColumn("单位"));
dt.Columns.Add(new DataColumn("数量"));
dt.Columns.Add(new DataColumn("出库数"));
dt.Columns.Add(new DataColumn("总额"));
dt.Columns.Add(new DataColumn("客户单号"));
dt.Columns.Add(new DataColumn("客户编号"));
dt.Columns.Add(new DataColumn("客户名"));
dt.Columns.Add(new DataColumn("订单总额"));
dt.Columns.Add(new DataColumn("状态"));
dt.Columns.Add(new DataColumn("是否入账"));
dt.Columns.Add(new DataColumn("退货"));
dt.Columns.Add(new DataColumn("退货数"));
dt.Columns.Add(new DataColumn("创建时间"));
foreach (SaleDetailEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.OrderNum;
row[1] = t.ProductName;
row[2] = t.BarCode;
row[3] = t.Size;
row[4] = t.Price;
row[5] = t.UnitName;
row[6] = t.Num;
row[7] = t.RealNum;
row[8] = t.Amount;
row[9] = t.CusOrderNum;
row[10] = t.CusNum;
row[11] = t.CusName;
row[12] = t.OrderAmount;
row[13] = EnumHelper.GetEnumDesc <EOrderStatus>(t.OrderStatus);
row[14] = EnumHelper.GetEnumDesc <EBool>(t.AuditeStatus);
row[15] = EnumHelper.GetEnumDesc <EBool>(t.HasReturn);
row[16] = t.ReturnNum;
row[17] = t.CreateTime.To("yyyy-MM-dd");
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("销售订单{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("销售订单", "销售订单", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public void Extract(string pathName)
{
DDTFileTable table = new DDTFileTable();
this.GetEntry();
using (FileStream fs = File.OpenRead(this.ImgName))
{
using (BinaryReader br = new BinaryReader(fs))
{
for (int i = 0; i < this.mEntries.Count; i++)
{
Entry vEntry = mEntries[i];
string dstPath = pathName + "/" + vEntry.FullName;
string dirname = Path.GetDirectoryName(dstPath);
var vSubItems = new List <SubItem>();
br.BaseStream.Seek(vEntry.Offset, SeekOrigin.Begin);
byte[] entryData = br.ReadBytes(vEntry.Size);
Logger.Print(string.Format("{0}:at offset:{1:x8}", vEntry.FullName, vEntry.Offset));
if (!Directory.Exists(dirname))
{
Directory.CreateDirectory(dirname);
}
using (FileStream entrFile = File.OpenWrite(dstPath))
{
entrFile.Write(entryData, 0, entryData.Length);
}
//如果是lb，则额外进行解包操作。
if (Path.GetExtension(vEntry.FullName).ToLower().Equals(".lb"))
{
LB lbPackage = new LB();
lbPackage.Load(dstPath);
vSubItems = lbPackage.SubItems;
for (int p = 0; p < lbPackage.SubItems.Count; p++)
{
var vitem = lbPackage.SubItems[p];
var tExt = Path.GetExtension(vitem.FileName).ToLower();
if (tExt.Equals(".bf") ||
tExt.Equals(".tmx")
/*|| Path.GetExtension(vitem.FileName).ToLower().Equals(".pac")*/)
{
//如果是bf和tmx，则设定为解包并解压。
Logger.Print(string.Format("\t- Extract {0}", vitem.FileName));
byte[] zipdata = lbPackage.Unpack(vitem.FileName);
string dstName = Path.Combine(dirname, vitem.FileName);
if (vSubItems[p].IsCompressed)
{
vSubItems[p].NeedReCompress = true;
}
File.WriteAllBytes(dstName, zipdata);
}
else
{
Logger.Print(string.Format("\t- Unpack {0}", vitem.FileName));
byte[] zipdata = lbPackage.GetRaw(vitem.FileName);
string dstName = Path.Combine(dirname, vitem.FileName);
byte[] dezipdata = lbPackage.Unpack(vitem.FileName);
File.WriteAllBytes(dstName + ".decdata", dezipdata);
vSubItems[p].NeedReCompress = false;
File.WriteAllBytes(dstName, zipdata);
}
}
}
else
{
}
table.Files.Add(new SubFile()
{
FileName = vEntry.FullName,
SubItems = vSubItems
});
}
}
}
string jsontable = JsonHelper.Serialize(table);
File.WriteAllText("dds3_table.json", jsontable, new UTF8Encoding(false));
}
public static async Task <DefaultResponse <O> > RequestAsync(string service, string token = null, int triesNumber = 0, RequestType requestType = RequestType.Get, I SendObject = null)
{
DefaultResponse <O> resposta = new DefaultResponse <O>();
var url = $"{StarWars.Services.InfraStructure.ServiceConstants.BASESWAPI}{service}";
HttpResponseMessage response = new HttpResponseMessage();
for (int i = 0; i <= triesNumber; i++)
{
try
{
using (var client = new HttpClient())
{
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
if (!string.IsNullOrEmpty(token))
{
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token);
}
var content = JsonHelper <I> .ObjectToJson(SendObject);
switch (requestType)
{
case RequestType.Get:
response = await client.GetAsync(url);
break;
case RequestType.Post:
response = await client.PostAsync(url, new StringContent(content, Encoding.UTF8, "application/json"));
break;
case RequestType.Put:
response = await client.PutAsync(url, new StringContent(content, Encoding.UTF8, "application/json"));
break;
case RequestType.Delete:
response = await client.DeleteAsync(url);
break;
default:
break;
}
if (response.StatusCode == HttpStatusCode.OK)
{
string responseString = await response.Content.ReadAsStringAsync();
resposta.Content = JsonHelper <O> .JsonToObject(responseString);
resposta.IsSuccess = true;
triesNumber = i++;
}
else
{
if (response.StatusCode == System.Net.HttpStatusCode.RequestTimeout)
{
if (i == triesNumber)
{
resposta.Message = "Tempo limite atingido";
resposta.IsSuccess = false;
}
}
else if (response.StatusCode == System.Net.HttpStatusCode.BadRequest)
{
resposta.Message = "Serviço não encontrado";
resposta.IsSuccess = false;
}
else if (response.StatusCode == System.Net.HttpStatusCode.InternalServerError)
{
if (i == triesNumber)
{
resposta.Message = "Serviço indisponível no momento";
resposta.IsSuccess = false;
}
}
else
{
resposta.Message = "Falha no acesso!";
resposta.IsSuccess = false;
}
}
}
}
catch (JsonException jsonException)
{
resposta.Message = $"JsonException: {jsonException.Message}";
resposta.IsSuccess = false;
}
catch (HttpRequestException httpRequestException)
{
resposta.Message = $"Exception: {httpRequestException.Message}";
resposta.IsSuccess = false;
}
catch (Exception exception)
{
resposta.Message = $"Exception: {exception.Message}";
resposta.IsSuccess = false;
}
}
return(resposta);
}
private void ProcessServiceRequest(Object state, DateTime requestTime)
{
string responseJSON = null;
JsonHelper<Object> _jsonHelper = new JsonHelper<Object>();
CometAsyncResult _curAsyncResult = state as CometAsyncResult;
JavaScriptSerializer serializer = new JavaScriptSerializer();
CometClientProcessor _cometProcessor = new CometClientProcessor();
_curAsyncResult.HttpContext.Response.ContentType = "text/plain";
try
{
uidForImage = new Guid();
string dirFullPath = _curAsyncResult.HttpContext.Server.MapPath("~/Content/img/avatars/");
string[] files;
int numFiles;
files = System.IO.Directory.GetFiles(dirFullPath);
numFiles = files.Length;
numFiles = numFiles + 1;
string str_image = "";
string imgPath = "~/Content/img/avatars/";
foreach (string s in currentAsyncRequestState.HttpContext.Request.Files)
{
HttpPostedFile file = _curAsyncResult.HttpContext.Request.Files[s];
string fileName = file.FileName;
string fileExtension = file.ContentType;
if (!string.IsNullOrEmpty(fileName))
{
fileExtension = Path.GetExtension(fileName);
str_image = "MyPHOTO_" + numFiles.ToString() + fileExtension;
string _saveLocation = _curAsyncResult.HttpContext.Server.MapPath(imgPath) + "" + uidForImage + fileName;
// string pathToSave_100 = _curAsyncResult.HttpContext.Server.MapPath(imgPath) + str_image;
file.SaveAs(_saveLocation);
}
}
// database record update logic here ()
_curAsyncResult.HttpContext.Response.Write(str_image);
}
catch (Exception ac)
{
}
_curAsyncResult.HttpContext.Request.InputStream.Position = 0;
string jsonRequest = new StreamReader(_curAsyncResult.HttpContext.Request.InputStream).ReadToEnd();
Dictionary<string, string> values = serializer.Deserialize<Dictionary<string, string>>(jsonRequest);
string command = values["command"];
switch (command)
{
case "CONNECT":
CometClientProcessor.AddClient(_curAsyncResult);
_curAsyncResult.HttpContext.Response.Write(_curAsyncResult.ClientGuid.ToString());
_curAsyncResult.CompleteRequest();
break;
case "DISCONNECT":
CometClientProcessor.RemoveClient(_curAsyncResult);
_curAsyncResult.CompleteRequest();
break;
case "CLIENTGUID":
if (values["ClientID"] != null)
{
CometClientProcessor.UpdateClient(_curAsyncResult, values["ClientID"].ToString());
}
break;
case "login":
Login(_curAsyncResult, values["email"], values["password"]);
break;
case "register":
Register(_curAsyncResult, values["email"], values["user"], values["pass"], values["passConfirm"]);
break;
case "logout":
CometClientProcessor.RemoveClient(_curAsyncResult);
_curAsyncResult.HttpContext.Response.Cookies["LastLogined"].Expires = DateTime.Now.AddDays(-1);
_curAsyncResult.HttpContext.Response.Cookies["userEMail"].Expires = DateTime.Now.AddDays(-1);
_jsonHelper.status = 1000; // status 1000 logout
_jsonHelper.message = "GoodBye ";
responseJSON = Newtonsoft.Json.JsonConvert.SerializeObject(_jsonHelper);
_curAsyncResult.HttpContext.Response.Headers.Add("Content-type", "application/json");
_curAsyncResult.HttpContext.Response.Write(responseJSON);
ExpireAllCookies();
_curAsyncResult.HttpContext.Session.Clear();
_curAsyncResult.HttpContext.Session.RemoveAll();
_curAsyncResult.HttpContext.Session.Abandon();
_curAsyncResult.CompleteRequest();
break;
case "getGames":
JsonHelper<Category> _jsonHelperGames = new JsonHelper<Category>();
_jsonHelperGames.status = 200; //getGames
_jsonHelperGames.listData = _cometProcessor.getGames(_curAsyncResult);
responseJSON = Newtonsoft.Json.JsonConvert.SerializeObject(_jsonHelperGames);
_curAsyncResult.HttpContext.Response.Headers.Add("Content-type", "application/json");
_curAsyncResult.HttpContext.Response.Write(responseJSON);
_curAsyncResult.CompleteRequest();
break;
case "startGame":
int catId = Convert.ToInt32(values["categoryId"]);
_cometProcessor.startGame(_curAsyncResult, catId);
JsonHelper<Answer> _jsonHelperQandAnswers = new JsonHelper<Answer>();
// Cleaning Buffer for each response to client
_curAsyncResult.HttpContext.Response.BufferOutput = false;
_curAsyncResult.HttpContext.Response.Flush();
_jsonHelperQandAnswers.status = 10; // Continue Game
_jsonHelperQandAnswers.message = StaticMembers._questionNumber + " / " + StaticMembers._questionListWas; ;
_jsonHelperQandAnswers.objData = StaticMembers.question;
_jsonHelperQandAnswers.listData = AnswerService.getAllByQuestionId(StaticMembers.question.id);
responseJSON = Newtonsoft.Json.JsonConvert.SerializeObject(_jsonHelperQandAnswers);
_curAsyncResult.HttpContext.Response.Write(responseJSON);
_curAsyncResult.CompleteRequest();
break;
case "continueGame":
bool play = Convert.ToBoolean(values["gameAction"]);
int score = Convert.ToInt32(values["score"]);
GameService _gameService = new GameService();
if (_cometProcessor.continueGame(play, score))
{
JsonHelper<Answer> _jsonHelperQandAns = new JsonHelper<Answer>();
// Cleaning Buffer for each response to client
_curAsyncResult.HttpContext.Response.BufferOutput = false;
_curAsyncResult.HttpContext.Response.Flush();
_jsonHelperQandAns.status = 10; // Continue Game
_jsonHelperQandAns.message = StaticMembers._questionNumber + " / " + StaticMembers._questionListWas; ;
_jsonHelperQandAns.objData = StaticMembers.question;
_jsonHelperQandAns.listData = AnswerService.getAllByQuestionId(StaticMembers.question.id);
responseJSON = Newtonsoft.Json.JsonConvert.SerializeObject(_jsonHelperQandAns);
_curAsyncResult.HttpContext.Response.Write(responseJSON);
_curAsyncResult.CompleteRequest();
break;
}
// when games End - show last Game Result;
JsonHelper<Game> _jsonHelperGameResult = new JsonHelper<Game>();
_jsonHelperGameResult.status = 20; // end game
_jsonHelperGameResult.objData = _gameService.GetPlayersLastGameResult(StaticMembers._game.player_id);
responseJSON = Newtonsoft.Json.JsonConvert.SerializeObject(_jsonHelperGameResult);
_curAsyncResult.HttpContext.Response.Write(responseJSON);
_curAsyncResult.CompleteRequest();
break;
case "getUserInfo":
string _email = _curAsyncResult.HttpContext.Session["Email"].ToString();
PlayerService playerService = new PlayerService();
Player player = playerService.FindByEmail(_email);
HttpCookie userId = new HttpCookie("userId", player.id.ToString());
_jsonHelper.status = 30; // 30 Fresh user info Loaded
_jsonHelper.userData = PlayerService.GetProfileInfo(player.id); // returns Players Info
_jsonHelper.userGamesData = PlayerService.GetPlayerAllStats(player.id); // returns all info about users games
responseJSON = Newtonsoft.Json.JsonConvert.SerializeObject(_jsonHelper);
_curAsyncResult.HttpContext.Response.Write(responseJSON);
_curAsyncResult.CompleteRequest();
break;
}
}
public override object GetResponse()
{
DoRequest();
JsonHelper jsonHelper = new JsonHelper(mResponse);
return UInt64.Parse(jsonHelper.GetVal("Counts"));
}
/// <summary>
/// 使用优惠券
/// </summary>
/// <param name="dicPar"></param>
public void AddCoupon(Dictionary <string, object> dicPar)
{
//要检测的参数信息
List <string> pra = new List <string>()
{
"key", "buscode", "stocode", "billcode", "couponinfo"
};
//检测方法需要的参数
if (!CheckActionParameters(dicPar, pra))
{
return;
}
//获取参数信息
string guid = "1";
string uid = "1";
string buscode = dicPar["buscode"].ToString();
string stocode = dicPar["stocode"].ToString();
string billcode = dicPar["billcode"].ToString();
//string couponJson = dicPar["couponinfo"].ToString();
string memcode = "";
dynamic couponObj = dicPar["couponinfo"];
string paymethod = couponObj["usepaytype"].ToString();
//获取账单详情、菜品详情
DataSet ds = new bllTB_Bill().GetDetail("", "", billcode, stocode, "");
DataTable dtBill = ds.Tables[0];
DataTable dtPay = ds.Tables[1];
DataTable dtDish = ds.Tables[2];
DataTable dtCoupon = ds.Tables[4];
//使用优惠券
if (dtBill != null && dtBill.Rows.Count > 0)
{
string BillCode = dtBill.Rows[0]["PKCode"].ToString();
string ShiftCode = dtBill.Rows[0]["ShiftCode"].ToString();
memcode = dtBill.Rows[0]["CCode"].ToString();
decimal ToPayMoney = StringHelper.StringToDecimal(dtBill.Rows[0]["ToPayMoney"].ToString());
decimal PayMoney = StringHelper.StringToDecimal(dtBill.Rows[0]["PayMoney"].ToString());
if (PayMoney > 0)
{
ReturnResultJson("1", "账单已有支付，无法使用优惠券");
return;
}
if (ToPayMoney <= 0)
{
ReturnResultJson("1", "付款金额为0，无法使用优惠券。");
return;
}
//使用优惠券
TB_BillCouponEntity CouponEntity = new TB_BillCouponEntity();
CouponEntity.BusCode = buscode;
CouponEntity.StoCode = stocode;
CouponEntity.BillCode = billcode;
CouponEntity.ShiftCode = ShiftCode;
CouponEntity.TicType = "0";
CouponEntity.TicWay = "";
string msg = OrderHelper.UseCoupon(billcode, couponObj, ToPayMoney, ref dtDish, ref CouponEntity, dtCoupon);
if (string.IsNullOrWhiteSpace(msg))
{
//线上验券
string MemcardUrl = Helper.GetAppSettings("ServiceUrl") + "/coupon/WScheckcoupon.ashx";
StringBuilder postStr = new StringBuilder();
postStr.Append("actionname=couponrecoverynew&usercode=" + uid + "¶meters={\"GUID\":\"" + guid + "\",\"USER_ID\":\"" + guid + "\",\"buscode\":\"" + buscode + "\",\"couponcode\":\"" + CouponEntity.CouponCode + "\",\"stocode\":\"" + stocode + "\",\"way\":\"PC\",\"username\":\"线上点餐\",\"usercode\":\"" + memcode + "\",\"orderno\":\"" + billcode + "\"}");
string strAdminJson = Helper.HttpWebRequestByURL(MemcardUrl, postStr.ToString());
if (!string.IsNullOrEmpty(strAdminJson))
{
string checkmsg = string.Empty;
string status = string.Empty;
DataSet dsCheckCcoupon = JsonHelper.JsonToDataSet(strAdminJson, out status, out checkmsg);
if (status == "0")
{
//添加使用券记录
string id = "";
DataTable dtAdd = new BLL.bllTB_BillCoupon().Add("", "", id, buscode, stocode, "", "线上点餐", "1", CouponEntity.BillCode, CouponEntity.CouponCode, CouponEntity.CouponMoney.ToString(), "", CouponEntity.RealPay.ToString(), CouponEntity.VIMoney.ToString(), CouponEntity.Remark, CouponEntity.UseType, ShiftCode, CouponEntity.CouponName, CouponEntity.McCode, CouponEntity.TicType, CouponEntity.TicWay);
string restatus = "1";
string remsg = "优惠券使用失败";
if (dtAdd != null && dtAdd.Rows.Count > 0)
{
restatus = "0";
remsg = "优惠券使用成功";
//更新菜品和账单信息
dtCoupon.Rows.Add(CouponEntity.CouponName, CouponEntity.CouponCode, CouponEntity.CouponMoney, CouponEntity.RealPay, CouponEntity.VIMoney, CouponEntity.BillCode, CouponEntity.McCode);
dtCoupon.AcceptChanges();
OrderHelper.ResetBillMoney(ref dtBill, dtDish, dtCoupon);
dtBill.Rows[0]["PayMethod"] = paymethod;
UpdateBillAndDish(dtBill, dtDish);
RefreshBill(billcode, stocode, "");
return;
}
if (restatus != "0")
{
//执行取消优惠券接口
postStr = new StringBuilder();
postStr.Append("actionname=couponrecoverycancelnew&usercode=" + uid + "¶meters=" +
"{\"GUID\":\"" + guid + "\"," +
"\"USER_ID\":\"" + guid + "\"," +
"\"buscode\":\"" + buscode + "\"," +
"\"couponcode\":\"" + CouponEntity.CouponCode + "\"," +
"\"stocode\":\"" + stocode + "\"," +
"\"username\":\"线上点餐\"," +
"\"usercode\":\"" + memcode + "\"," +
"\"way\":\"App\"}");
Helper.HttpWebRequestByURL(MemcardUrl, postStr.ToString());
}
ReturnResultJson(restatus, checkmsg);
return;
}
}
ReturnResultJson("1", "线上消券错误");
return;
}
else
{
ReturnResultJson("1", msg);
return;
}
}
else
{
ReturnResultJson("1", "账单获取错误，请重试");
}
}
protected void Register_Click(object sender, EventArgs e)
{
uidForImage = Guid.NewGuid();
string fileName = System.IO.Path.GetFileName(PictureUpload.PostedFile.FileName);
_playerService = new PlayerService();
_jsonHelper = new JsonHelper<Object>();
Player newPlayer = new Player();
newPlayer.username = RegisterUsername.Text;
newPlayer.email = RegisterEmail.Text;
// kod zashivrovali v settere
newPlayer.password = RegisterPassword.Text;
newPlayer.image = uidForImage + fileName;
newPlayer.registration_date = DateTime.Now;
if (!_playerService.CheckIfExists(newPlayer))
{
// do stuff here to log the user in ...
if (_playerService.Insert(newPlayer))
{
UploadImage(sender, e);
Login(newPlayer.email, newPlayer.password);
}
}
else
{
string message = "<div class='alert alert-warning'>This email is registered,Please login or register another one</div>";
Alert.Text = message;
Response.Redirect("Home.aspx");
}
}
/// <summary>
///添加支付信息
/// </summary>
/// <param name="dicPar"></param>
public void AddWxPay(Dictionary <string, object> dicPar)
{
//要检测的参数信息
List <string> pra = new List <string>()
{
"key", "buscode", "stocode", "memcode", "billcode", "paymoney", "openid"
};
//检测方法需要的参数
if (!CheckActionParameters(dicPar, pra))
{
return;
}
//获取参数信息
string GUID = "";
string USER_ID = "";
string Id = "0";
string BusCode = dicPar["buscode"].ToString();
string StoCode = dicPar["stocode"].ToString();
string CCode = dicPar["memcode"].ToString();
string CCname = dicPar["memcode"].ToString();
string TStatus = "0";
string PKCode = "0";
string BillCode = dicPar["billcode"].ToString();
string PayMoney = dicPar["paymoney"].ToString();
string PayMethodName = "微信支付";
string PayMethodCode = "2";
string Remar = "";
string OutOrderCode = "";
string PPKCode = "";
string openid = dicPar["openid"].ToString();
//获取账单详情、菜品详情
DataSet ds = new bllTB_Bill().GetDetail("", "", BillCode, StoCode, "");
DataTable dtBill = ds.Tables[0];
DataTable dtPay = ds.Tables[1];
DataTable dtDish = ds.Tables[2];
DataTable dtTable = ds.Tables[3];
DataTable dtCoupon = ds.Tables[4];
if (dtBill == null || dtBill.Rows.Count < 1)
{
ReturnResultJson("1", "账单信息获取失败");
return;
}
//账单信息
string DiscountMoney = dtBill.Rows[0]["DiscountMoney"].ToString();
string DiscountName = dtBill.Rows[0]["DiscountName"].ToString();
string ZeroCutMoney = dtBill.Rows[0]["ZeroCutMoney"].ToString();
string AuthCode = "";
string AuthName = "";
//调用逻辑
new bllTB_BillPay().Add(GUID, USER_ID, Id, BusCode, StoCode, CCode, CCname, TStatus, PKCode, BillCode, PayMoney, PayMethodName, PayMethodCode, Remar, OutOrderCode, PPKCode, DiscountName, DiscountMoney, ZeroCutMoney, AuthCode, AuthName, "", "", "0", "", "");
if (PKCode.Length > 4)
{
switch (PayMethodCode)
{
case "2": //微信支付
string WxUrl = Helper.GetAppSettings("ServiceUrl") + "/networkpay/WxPayEx.ashx";
StringBuilder wxPostStr = new StringBuilder();
wxPostStr.Append("actionname=getpayparms¶meters={" +
string.Format("'GUID':'{0}'", GUID) +
string.Format(",'USER_ID': '{0}'", USER_ID) +
string.Format(",'buscode': '{0}'", BusCode) + //商户编号
string.Format(",'stocode': '{0}'", StoCode) + //门店编号
string.Format(",'openid': '{0}'", openid) + //openid
string.Format(",'orderno': '{0}'", PKCode) + //支付单号
string.Format(",'money': '{0}'", PayMoney) + //订单金额
string.Format(",'callback': '{0}'", HttpUtility.UrlEncode(Helper.GetAppSettings("StoBackRoot") + "/App/Ws_Bill.ashx?actionname=i_refreshWxPay¶meters={\"payno\":\"" + PKCode + "\",\"buscode\":\"" + BusCode + "\",\"stocode\":\"" + StoCode + "\"}")) +
"}"); //键值对
string wxResultJson = Helper.HttpWebRequestByURL(WxUrl, wxPostStr.ToString());
string wxPayStatus = JsonHelper.GetJsonValByKey(wxResultJson, "status");
if (wxPayStatus == "0")
{
dynamic jsonObj = Newtonsoft.Json.JsonConvert.DeserializeObject(wxResultJson);
ReturnJsonStr("{\"code\":0,\"msg\":" + jsonObj["mes"].ToString() + "}");
}
else
{
ReturnResultJson("1", "请求微信支付失败");
}
break;
}
}
else
{
ReturnResultJson("1", "支付失败");
}
}
/// <summary>
/// 取消支付
/// </summary>
/// <param name="dicPar"></param>
public void CancelPay(Dictionary <string, object> dicPar)
{
//要检测的参数信息
List <string> pra = new List <string>()
{
"key", "buscode", "stocode", "billcode", "memcode"
};
//检测方法需要的参数
if (!CheckActionParameters(dicPar, pra))
{
return;
}
string buscode = dicPar["buscode"].ToString();
string stocode = dicPar["stocode"].ToString();
string billcode = dicPar["billcode"].ToString();
string memcode = dicPar["memcode"].ToString();
//检查账单的状态，是否能进行反结
TB_BillEntity billEntity = new bllTB_Bill().GetEntitySigInfo(" where PKCode='" + billcode + "' and StoCode='" + stocode + "'");
if (billEntity == null || billEntity.TStatus != "2")
{
ReturnResultJson("1", "账单无法取消支付！");
return;
}
//获取改账单的支付方式
int nums = 0;
string filter = " where BillCode='" + billcode + "' and PayMethodCode='7' and TStatus='1' ";
DataTable dtBillPay = new bllTB_BillPay().GetPagingListInfo("", "", int.MaxValue, 1, filter, "", out nums, out nums);
//反结
string msg = "反结成功";
if (dtBillPay != null && dtBillPay.Rows.Count > 0)
{
foreach (DataRow dr in dtBillPay.Rows)
{
string PKCode = "";
string PayMoney = dr["PayMoney"].ToString();
string Remar = dr["Remar"].ToString();
string OutOrderCode = "";
string PPKCode = dr["PKCode"].ToString();
string PayMethodCode = "";
string memcard = dr["MemberCard"].ToString();
new bllTB_BillPay().Back("", "", buscode, stocode, memcode, "小程序", "2", out PKCode, PayMoney, Remar, out OutOrderCode, PPKCode, out PayMethodCode);
if (PKCode.Length > 4)
{
string MemUrl = Helper.GetAppSettings("ServiceUrl") + "/memcardpay/memcardreturn.ashx";
StringBuilder memPostStr = new StringBuilder();
memPostStr.Append("actionname=cardpayreturnnew¶meters={" +
string.Format("'GUID':'{0}'", memcode) +
string.Format(",'USER_ID': '{0}'", memcode) +
string.Format(",'buscode': '{0}'", buscode) + //商户编号
string.Format(",'stocode': '{0}'", stocode) + //门店编号
string.Format(",'terminalType': '{0}'", "App") + //终端编号
string.Format(",'ucode': '{0}'", memcode) + //操作人编号
string.Format(",'uname': '{0}'", "小程序") + //操作人姓名
string.Format(",'paycode': '{0}'", billcode) + //主支付编号
string.Format(",'vicepaycode': '{0}'", PKCode) + //副支付编号
string.Format(",'rvicepaycode': '{0}'", PPKCode) + //待反结副支付编号
string.Format(",'couponcode': '{0}'", "") + //优惠券编号（多个以英文逗号分隔）
string.Format(",'cardcode': '{0}'", memcard) + //卡号
string.Format(",'expend': '{0}'", PayMoney) + //消费金额
string.Format(",'isopen': '{0}'", "0") + //是否开票
string.Format(",'invamount': '{0}'", "0") + //开票金额
string.Format(",'addint': '{0}'", "0") + //可积积分
string.Format(",'deductionint': '{0}'", "0") + //抵扣积分
"}"); //键值对
string memResultJson = Helper.HttpWebRequestByURL(MemUrl, memPostStr.ToString());
string memPayStatus = JsonHelper.GetJsonValByKey(memResultJson, "status");
if (memPayStatus != "0")
{
msg = "有支付反结失败，请重试";
new bllTB_BillPay().Delete(memcode, memcode, PKCode, stocode);
break;
}
}
}
}
RefreshBill(billcode, stocode, msg);
}
public void ItShouldHandleSerializationException()
{
JsonHelper instance = new JsonHelper();
TestObject oops = instance.ToObject<TestObject>("{{\"property\": he");
}
/// <summary>
/// 返回分页后的JSON字符串
/// </summary>
/// <param name="SelectColumns">将展示的字段</param>
/// <param name="KeyID">主键ID</param>
/// <param name="TableName">表名</param>
/// <param name="strWhere">条件查询</param>
/// <param name="strOrder">排序</param>
/// <param name="DBConn">数据库连接</param>
/// <param name="start"></param>
/// <param name="limit"></param>
/// <param name="isDistinct">过滤重复值</param>
/// <returns></returns>
public static string GetPageMethod(string SelectColumns, string KeyID, string TableName, string strWhere, string strOrder, int start, int limit, bool isDistinct)
{
#region 参数判定
if (string.IsNullOrEmpty(SelectColumns)) { return "{total:1,success:true,error:'',data:[{'info':'执行分页方法错误，原因为：缺失参数：SelectColumns!'}]}"; }
if (string.IsNullOrEmpty(KeyID)) { return "{total:1,success:true,error:'',data:[{'info':'执行分页方法错误，原因为：缺失参数：KeyID!'}]}"; }
if (string.IsNullOrEmpty(TableName)) { return "{total:1,success:true,error:'',data:[{'info':'执行分页方法错误，原因为：缺失参数：TableName!'}]}"; }
if (string.IsNullOrEmpty(start.ToString())) { return "{total:1,success:true,error:'',data:[{'info':'执行分页方法错误，原因为：缺失参数：start!'}]}"; }
if (string.IsNullOrEmpty(limit.ToString())) { return "{total:1,success:true,error:'',data:[{'info':'执行分页方法错误，原因为：缺失参数：limit!'}]}"; }
#endregion
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select " + (isDistinct ? "distinct" : string.Empty) + " top {0} {2} ");
strSql.Append(" FROM {4} ");
strSql.Append(" where {3} not in (select " + (isDistinct ? "distinct" : string.Empty) + " top {1} {3} from {4} {7} {6} ) {5} {6};");
string sql = strSql.ToString();
strWhere = strWhere.Trim();
if (!string.IsNullOrEmpty(strOrder))
{
strOrder = " order by " + strOrder;
}
if (KeyID.Equals(string.Empty))
{
KeyID = DataSource.Query("Execute sp_pkeys '" + TableName + "'").Tables[0].Rows[0]["PK_NAME"].ToString();
}
if (strWhere.ToLower().IndexOf("and") == 0)
{
strWhere = strWhere.Substring(strWhere.IndexOf("and") + 3);
}
sql = string.Format(sql, limit, start, SelectColumns, KeyID, TableName, strWhere.Equals(string.Empty) ? string.Empty : " and " + strWhere, strOrder, strWhere.Equals(string.Empty) ? string.Empty : " where " + strWhere);
DataTable dt = DataSource.Query(sql).Tables[0];
JsonHelper json = new JsonHelper();
json.totlal = 0;
json.success = true;
if (dt.Rows.Count > 0)
{
int totalCount = 0;
string sqlCount = "select count(" + (isDistinct ? "distinct" : string.Empty) + " {0}) as cou from {1} {2}";
if (!string.IsNullOrEmpty(strWhere))
{
strWhere = " where " + strWhere;
}
sqlCount = string.Format(sqlCount, KeyID, TableName, strWhere);
object obj = DataSource.Query(sqlCount).Tables[0].Rows[0]["cou"];
if (obj != null) totalCount = int.Parse(obj.ToString());
json.totlal = totalCount;
json.success = true;
foreach (DataRow dr in dt.Rows)
{
foreach (DataColumn dc in dt.Columns)
{
json.AddItem(dc.ColumnName.ToString(), dr[dc.ColumnName].ToString().Replace("\"", "\\\"").Replace("\r", "").Replace("\n", ""));
}
json.ItemOk();
}
}
return json.ToString();
}
catch (Exception error) { return "{total:1,success:true,error:'',data:[{'info':'执行分页方法错误，原因为：" + error.Message + "'}]}"; }
}
