/// <summary>
/// 查询用户 返回列表 酒店数
/// </summary>
/// <param name="eBookingUserEntity"></param>
/// <returns></returns>
public static eBookingUserEntity eBookingUserQuery(eBookingUserEntity eBookingUserEntity)
{
DataSet dsResult = new DataSet();
dsResult.Tables.Add(new DataTable());
dsResult.Tables[0].Columns.Add(new DataColumn("USERNAME"));
dsResult.Tables[0].Columns.Add(new DataColumn("HOTELNAME"));
dsResult.Tables[0].Columns.Add(new DataColumn("CREATETIME"));
dsResult.Tables[0].Columns.Add(new DataColumn("RECORDCOUNT"));
try
{
eBookingUserDBEntity dbParm = (eBookingUserEntity.eBookingUserDBEntity.Count > 0) ? eBookingUserEntity.eBookingUserDBEntity[0] : new eBookingUserDBEntity();
string DataString = "{\"loginName\":\"" + dbParm.LoginName + "\"," + "\"hotelId\":\"" + dbParm.HotelId + "\"," + "\"operator\":\"" + dbParm.OperatorId + "\"," + "\"pageSize\":\"" + dbParm.PageSize + "\"," + "\"pageNum\":\"" + dbParm.PageNum + "\"}";
string HotelFullRoomUrl = JsonRequestURLBuilder.eBookingUserQuery();
CallWebPage callWebPage = new CallWebPage();
string strJson = callWebPage.CallWebByURL(HotelFullRoomUrl, DataString);
//解析json数据
JObject o = JObject.Parse(strJson);
if ("success".Equals(JsonRequestURLBuilder.GetJsonStringValue(o, "message").Trim('"')))
{
string oList = o.SelectToken("result").ToString();
JArray jsa = (JArray)JsonConvert.DeserializeObject(oList);
string oPage = o.SelectToken("page").SelectToken("count").ToString().Trim('"');
//JArray jsa = (JArray)JsonConvert.DeserializeObject(oList);
for (int i = 0; i < jsa.Count; i++)
{
string oHotelInfoList = jsa[i].SelectToken("hotelinfo").ToString();
JObject jsoHotelInfoList = (JObject)jsa[i];
JArray jsoHotelInfo = (JArray)JsonConvert.DeserializeObject(oHotelInfoList);
DataRow drRow = dsResult.Tables[0].NewRow();
if (jsoHotelInfo.Count == 1)
{
JObject jso = (JObject)jsoHotelInfo[0];
drRow["USERNAME"] = JsonRequestURLBuilder.GetJsonStringValue(jsoHotelInfoList, "loginname").Trim('"');
drRow["HOTELNAME"] = JsonRequestURLBuilder.GetJsonStringValue(jso, "hotelname").Trim('"');
drRow["CREATETIME"] = JsonRequestURLBuilder.GetJsonStringValue(jsoHotelInfoList, "createtime").Trim('"');
}
else if (jsoHotelInfo.Count > 1)
{
drRow["USERNAME"] = JsonRequestURLBuilder.GetJsonStringValue(jsoHotelInfoList, "loginname").Trim('"');
drRow["HOTELNAME"] = jsoHotelInfo.Count + "家";
drRow["CREATETIME"] = JsonRequestURLBuilder.GetJsonStringValue(jsoHotelInfoList, "createtime").Trim('"');
}
drRow["RECORDCOUNT"] = oPage;
dsResult.Tables[0].Rows.Add(drRow);
}
}
}
catch (Exception ex)
{
}
eBookingUserEntity.QueryResult = dsResult;
return eBookingUserEntity;
}
public static string CommonCallWebUrl(string strUrl)
{
string strJson = string.Empty;
try
{
CallWebPage callWebPage = new CallWebPage();
strJson = callWebPage.CallWebByURL(strUrl, "");
}
catch
{
}
return strJson;
}
//用于CC根据电话号码，查询生产新的验证码.
public string getSignByPhoneForCC(string userPhoneNumber)
{
bool boolResult = false;
try
{
string url = JsonRequestURLBuilder.QueryUserSign();
string postDataStr = "{\"LmLoginRQ\":{\"loginMobile\":\"" + userPhoneNumber + "\"}}";
CallWebPage callWebPage = new CallWebPage();
string strJson = callWebPage.CallWebByURL(url, postDataStr);
//解析json数据
JObject o = JObject.Parse(strJson);
JObject oLoginMember = (JObject)o.SelectToken("LoginLmRS[0]");
string strSign = string.Empty;
if (oLoginMember.SelectToken("result.success") != null)
{
boolResult = (bool)oLoginMember.SelectToken("result.success");
if (boolResult == true)
{
if (oLoginMember.SelectToken("signKey") != null)
{
strSign = oLoginMember.SelectToken("signKey").ToString().Trim('"');
}
}
else
{
if (oLoginMember.SelectToken("result.errormsg") != null)
{
strSign = oLoginMember.SelectToken("result.errormsg").ToString().Trim('"');
}
}
}
return strSign;
}
catch
{
return "";
}
}
private void InitiData()
{
try
{
//主界面控件各类事件
Image.GetThumbnailImageAbort callBack = new Image.GetThumbnailImageAbort(ThumbnailCallback);
picShow.Image = Resources.MedicalLogo.GetThumbnailImage(picShow.Width, picShow.Height, callBack, IntPtr.Zero);
this.Closing += (sender, args) => Application.Exit();
tsmSettingMenues.DropDownOpened += (sender, args) => tsmSettingMenues.ForeColor = Color.Black;
tsmSettingMenues.DropDownClosed += (sender, args) => tsmSettingMenues.ForeColor = Color.White;
//权限
tmsLookPat.Enabled = Information.UsePower.ContainsKey(CommonInfo.UserPowers.门诊处方.SafeDbValue <int>());
tsmCheckSetting.Enabled = Information.UsePower.ContainsKey(CommonInfo.UserPowers.检查费调整.SafeDbValue <int>());
tsmSetting.Enabled = Information.UsePower.ContainsKey(CommonInfo.UserPowers.基础设置.SafeDbValue <int>());
tsmThemes.Enabled = Information.UsePower.ContainsKey(CommonInfo.UserPowers.主题变换.SafeDbValue <int>());
tsmPws.Enabled = Information.UsePower.ContainsKey(CommonInfo.UserPowers.密码修改.SafeDbValue <int>());
//加载底部信息栏
JsonRead jsonRead = new JsonRead();
try
{
string weatherAddress = CallWebPage.CallWeb("http://www.weather.com.cn/data/cityinfo/101040100.html", 60000, Encoding.UTF8);
Weather weather = jsonRead.JsonReadInfo(weatherAddress);
lblWeather.Text = "城市: " + weather.city + " 天气: " + weather.weather + " 温度: " + weather.temp1 + "-" + weather.temp2;
}
catch { }
lblWelcome.Text = @"欢迎 " + Information.CurrentUser.Name + " " + Information.CurrentUser.DutyName + " ";
//提示到期、库存少的药品
DataTable drInMed = ErpServer.GetInMedDataSet(null).Tables[0];
string StockMedicines = string.Empty;
string DueDateMedicines = string.Empty;
DataRow[] rowsStock = drInMed.Select("Quantity <= 30");//库存少于30
for (int i = 0; i < rowsStock.Length; i++)
{
StockMedicines += ", " + rowsStock[i]["MedName"].ToString();
}
DataRow[] rowsDate = drInMed.Select($@"DueDate <= '{DateTime.Now}'");//药品到了保质期
for (int i = 0; i < rowsStock.Length; i++)
{
DueDateMedicines += ", " + rowsStock[i]["MedName"].ToString();
}
string medicinesInfo = string.Empty;
if (!string.IsNullOrEmpty(DueDateMedicines))
{
medicinesInfo += "库存少于30的药品：" + DueDateMedicines;
}
if (!string.IsNullOrEmpty(DueDateMedicines))
{
medicinesInfo += "\r\n" + "到了保质期的药品：" + DueDateMedicines;
}
if (!string.IsNullOrEmpty(medicinesInfo))
{
MessageBox.Show(medicinesInfo, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
}
drInMed.Dispose();
//时间实时刷新
timer1.Start();
}
catch (Exception ex)
{
MessageBox.Show("主界面初始化数据加载失败！" + ex.ToString());
}
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="eBookingUserEntity"></param>
/// <returns></returns>
public static string eBookingUserUpdate(string userId, string loginName, string password, string hotelIds, string remark, string tel, string operatorIds)
{
string DataString = "{\"userId\":" + userId + "," + "\"loginName\":\"" + loginName + "\"," + "\"password\":\"" + password + "\"," + "\"hotelIds\":\"" + hotelIds + "\"," + "\"remark\":\"" + remark + "\"," + "\"tel\":\"" + tel + "\"," + "\"operator\":\"" + userId + "\"," + "\"roleId\":\"2\"}";
string HotelFullRoomUrl = JsonRequestURLBuilder.eBookingUserUpdate();
CallWebPage callWebPage = new CallWebPage();
string strJson = callWebPage.CallWebByURL(HotelFullRoomUrl, DataString);
JObject oHotelFullRoom = JObject.Parse(strJson);
if ("success".Equals(JsonRequestURLBuilder.GetJsonStringValue(oHotelFullRoom, "message").Trim('"')))
{
return "{\"d\":\"[" + JsonRequestURLBuilder.GetJsonStringValue(oHotelFullRoom, "message").Trim('"') + "]\"}";
}
else
{
return "{\"d\":\"[" + JsonRequestURLBuilder.GetJsonStringValue(oHotelFullRoom, "message").Trim('"') + "]\"}";
}
}
/// <summary>
/// 用户查询 转JSON字符串
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public static DataSet eBookingUserQuery(string userName)
{
DataSet dsResult = new DataSet();
dsResult.Tables.Add(new DataTable());
dsResult.Tables[0].Columns.Add(new DataColumn("USERID"));
dsResult.Tables[0].Columns.Add(new DataColumn("USERNAME"));
dsResult.Tables[0].Columns.Add(new DataColumn("USERTEL"));
dsResult.Tables[0].Columns.Add(new DataColumn("USERPWD"));
dsResult.Tables[0].Columns.Add(new DataColumn("HOTELID"));
dsResult.Tables[0].Columns.Add(new DataColumn("HOTELNAME"));
dsResult.Tables[0].Columns.Add(new DataColumn("REMARK"));
try
{
string DataString = "{\"loginName\":\"" + userName + "\"}";
string HotelFullRoomUrl = JsonRequestURLBuilder.eBookingUserQuery();
CallWebPage callWebPage = new CallWebPage();
string strJson = callWebPage.CallWebByURL(HotelFullRoomUrl, DataString);
//解析json数据
JObject o = JObject.Parse(strJson);
if ("success".Equals(JsonRequestURLBuilder.GetJsonStringValue(o, "message").Trim('"')))
{
string oList = o.SelectToken("result").ToString();
JArray jsa = (JArray)JsonConvert.DeserializeObject(oList);
for (int i = 0; i < jsa.Count; i++)
{
string oHotelInfoList = jsa[i].SelectToken("hotelinfo").ToString();
JObject jsoHotelInfoList = (JObject)jsa[i];
JArray jsoHotelInfo = (JArray)JsonConvert.DeserializeObject(oHotelInfoList);
for (int j = 0; j < jsoHotelInfo.Count; j++)
{
DataRow drRow = dsResult.Tables[0].NewRow();
JObject jso = (JObject)jsoHotelInfo[j];
drRow["USERID"] = jsa[i].SelectToken("userid").ToString().Trim('"');
drRow["USERNAME"] = JsonRequestURLBuilder.GetJsonStringValue(jsoHotelInfoList, "loginname").Trim('"');
drRow["USERTEL"] = JsonRequestURLBuilder.GetJsonStringValue(jsoHotelInfoList, "tel").Trim('"');
drRow["USERPWD"] = JsonRequestURLBuilder.GetJsonStringValue(jsoHotelInfoList, "password").Trim('"');
drRow["HOTELID"] = JsonRequestURLBuilder.GetJsonStringValue(jso, "hotelid").Trim('"');
drRow["HOTELNAME"] = JsonRequestURLBuilder.GetJsonStringValue(jso, "hotelname").Trim('"');
drRow["REMARK"] = JsonRequestURLBuilder.GetJsonStringValue(jsoHotelInfoList, "remark").Trim('"');
dsResult.Tables[0].Rows.Add(drRow);
}
}
}
}
catch (Exception ex)
{
}
return dsResult;
}
