public HttpResponseMessage AddProudct(Product product)
{
ResultMsg resultMsg = null;
resultMsg = new ResultMsg();
resultMsg.StatusCode = (int)StatusCodeEnum.Success;
resultMsg.Info = StatusCodeEnum.Success.GetEnumText();
resultMsg.Data = product;
return(HttpResponseExtension.toJson(JsonConvert.SerializeObject(resultMsg).ToLower()));
}
public ResultMsg Add(OPC_AuthRole model)
{
bool result = RestClient.Post("Role/AddRole", model);
if (result)
{
return(ResultMsg.Success());
}
return(ResultMsg.Failure("添加失败！"));
}
protected static ResultMsg CreateResultMsg(string message = null)
{
var lMsg = new ResultMsg
{
Status = 0,
Message = message
};
return(lMsg);
}
/// <summary>
/// Author：Geek Dog Content：普通请求失败(警告提示) AddTime：2019-9-19 16:52:39
/// </summary>
/// <param name="ResultCode"></param>
/// <param name="Model"></param>
/// <returns></returns>
public static ResultMsg ReturnWarning(object ResultCode, dynamic Model = null)
{
ResultMsg msg = new ResultMsg();
msg.ResultCode = ResultCode;
msg.ResultType = "warning";
msg.ResultMsgs = JosnHelp.Readjson(ResultCode.ToString(), LanguageConfig.CN);
msg.ResultData = Model;
return(msg);
}
public ResultMsg Delete(OPC_AuthRole model)
{
bool result = RestClient.Put("Role/DeleteRole", model.Id);
if (result)
{
return(ResultMsg.Success());
}
return(ResultMsg.Failure("删除失败！"));
}
public ResultMsg OnePrams(string id)
{
ResultMsg resultMsg = new ResultMsg();
resultMsg.Pass = true;
resultMsg.Msg = "操作成功,OnePrams";
resultMsg.Data = id;
logger.Info("GetProduct");
return(resultMsg);
}
public ResultMsg <Result> CmdDeviced()
{
int deviceId = 3010;
string apiTag = "nl_fan";
int data = 1;
ResultMsg <Result> opResult = SDK.CmdDeviced(deviceId, apiTag, data, this.Token);
return(opResult);
}
public ResultMsg TwoPrams(string id, string name)
{
ResultMsg resultMsg = new ResultMsg();
resultMsg.Pass = true;
resultMsg.Msg = "操作成功,TwoPrams";
resultMsg.Data = id + name;
logger.Info("GetProduct");
return(resultMsg);
}
public HttpResponseMessage GetList(string id)
{
var a = AccountService.GetInstance().GetModelById(1);
resultMsg = new ResultMsg();
resultMsg.StatusCode = (int)StatusCodeEnum.Success;
resultMsg.Info = StatusCodeEnum.Success.GetEnumText();
resultMsg.Data = a;
return(HttpResponseExtension.toJson(JsonConvert.SerializeObject(resultMsg)));
}
public HttpResponseMessage GetUserInfo(string userName)
{
var data = MemberShipBase.GetMemberShipServiceInstance().GetUserInfo(userName);
resultMsg = new ResultMsg();
resultMsg.StatusCode = (int)StatusCodeEnum.Success;
resultMsg.Info = StatusCodeEnum.Success.GetEnumText();
resultMsg.Data = data;
return(HttpResponseExtension.toJson(JsonConvert.SerializeObject(resultMsg)));
}
public ResultMsg Edit(OPC_AuthRole model)
{
bool result = RestClient.Put("Role/UpdateRole", model);
if (result)
{
return(ResultMsg.Success());
}
return(ResultMsg.Failure("更新失败！"));
}
public IActionResult CodeViewWeb(string SchemaName, string TableName, string SetTableName)
{
ISqlDataSource dataSource = DataToModel.GetDataSource("mysql");
DataTable table = dataSource.GetDataTableByName(SchemaName, TableName);
List <DataField> list = dataSource.GetDataFieldByName(SchemaName, TableName);
StringBuilder sb = new StringBuilder();
//外部设置的表名
if (string.IsNullOrEmpty(SetTableName))
{
SetTableName = table.TableName;
}
if (table != null)
{
sb.Append(" /// <summary>\r\n");
sb.Append(" ///" + table.TableNote).Append("\r\n");
sb.Append(" /// </summary>").Append("\r\n");
sb.Append(" public class ").Append(SetTableName).Append("\r\n").Append(" {");
sb.Append("\r\n");
foreach (var item in list)
{
string systemtype = DataTypeExtend.MySql2CSharpType(item.FieldType);
if (item.FieldName == "Guid")
{
systemtype = "Guid";
}
string def = DataTypeExtend.GetDefValue(systemtype);
string field_p = "_" + DataTypeExtend.FirstLetterLowercase(item.FieldName);
//long特殊处理
if (systemtype == "long")
{
systemtype = "string";
def = "\"0\"";
}
sb.Append(string.Format(" private {0} {1}= {2};", systemtype, field_p, def));
sb.Append("\r\n");
sb.Append(" /// <summary>\r\n");
sb.Append(" ///" + item.FieldNote).Append("\r\n");
sb.Append(" /// </summary>").Append("\r\n");
sb.Append(string.Format(" public virtual {0} {1}", systemtype, item.FieldName)); sb.Append("\r\n");
sb.Append(" {"); sb.Append("\r\n");
sb.Append(" get { return " + field_p + "; }"); sb.Append("\r\n");
sb.Append(" set { " + field_p + " = value; }"); sb.Append("\r\n");
sb.Append(" }"); sb.Append("\r\n");
}
sb.Append(" }");
}
ResultMsg msg = new ResultMsg(true);
msg.Data = sb.ToString();
return(Json(msg));
}
public void Button_Click_login(object sender, RoutedEventArgs e)
{
SDK = new NLECloudAPI("http://api.nlecloud.com");
SentencedToEmpty();
ProgressBar.IsIndeterminate = true;
//string LocalLoginAuthentication = ""
AccountLoginDTO data_account = new AccountLoginDTO() //实例化登录信息
{
Account = getUsername.Text, //从xaml中的TextBox中的name中获取账号文本
Password = getPassword.Password //从xaml中的PasswordBox中的name中获取密码
};
/*
* 自己写的账号密码判空提示
* 缺陷：代码冗余，且不符合使用逻辑
* 改进：使用this.getUsername.Focus聚焦文本框提示用户、使用return跳出方法
* while (LocalLoginAuthentication == "")
* {
* LocalLoginAuthentication = "账号密码判空通过";
* if (getUsername.Text == "")
* {//账号判空提示
* MessageBox.Show("账号不能为空！", "登陆失败");
* LocalLoginAuthentication = "";
* break;
* }
* //密码判空提示
* if (getPassword.Password == "")
* {
* LocalLoginAuthentication = "";
* MessageBox.Show("密码不能为空！", "登陆失败");
* break;
* }
* }
*/
//Thread.Sleep(5000);//全界面Sleep 5秒
ResultMsg <AccountLoginResultDTO> data_account_verify = SDK.UserLogin(data_account);
if (data_account_verify.IsSuccess())
{//问题：输入账号时，textbox内预留的提示文字应消失（×）
//问题：password内没有预留的提示文字（√）
//问题：记住密码（×）
Schoolname = data_account_verify.ResultObj.CollegeName; //获取ResultObj.CollegeName学校名
accessToken = data_account_verify.ResultObj.AccessToken; //获取ResultObj.AccessToken,用于后续API调用
MessageBox.Show("登陆成功！，您位于" + Schoolname + "\n即将进入空调控制器！", "登录成功");
MainWindow mainWindow = new MainWindow();
mainWindow.Show();
this.Close();
}
else
{
MessageBox.Show("登录失败！，请重试", "登录失败");
}
}
private void btnLogin_Click(object sender, RoutedEventArgs e)
{
AccountLoginDTO loginDTO = new AccountLoginDTO()
{
Account = "ytvciot", Password = "******"
};
ResultMsg <AccountLoginResultDTO> result = api.UserLogin(loginDTO);
token = result.ResultObj.AccessToken;
}
/// <summary>
/// 删除仓库
/// </summary>
/// <param name="Rid"></param>
/// <returns></returns>
public ActionResult Delete(int Rid)
{
ResultMsg msg = new ResultMsg();
if (Rid > 0)
{
msg = new DALPurchaseLog().Delete(Rid);
}
return(Json(new { Success = msg.Success, Result = msg.ReturnInt, ErrMsg = msg.ErrMsg }));
}
/// <summary>
/// 更新传感器
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public ResultMsg <Result> UpdateSensorOfDevice(SensorType type)
{
ResultMsg <Result> opResult = null;
int deviceId = 6636;
SensorQueryData s = new SensorQueryData()
{
Name = "湿度传感器更新2",
ApiTag = "liquidSensor"
};
ActuatorQueryData a = new ActuatorQueryData()
{
Name = "风扇执行器更新",
ApiTag = "fanActuator",
OperType = 1,
OperTypeAttrs = "{ 'MaxRange' : 200 ,'MinRange' : 0, 'Step' : 10}"
};
CameraQueryData c = new CameraQueryData()
{
Name = "大华摄像头更新",
ApiTag = "dahuaCamera1",
HttpIp = "192.168.14.111",
HttpPort = 5000,
UserName = "******",
Password = "******"
};
switch (type)
{
case SensorType.Sensor: //如果是传感器
{
opResult = SDK.UpdateSensorOfDevice(s, deviceId, s.ApiTag, this.Token);
break;
}
case SensorType.Actuator: //如果是执行器
{
opResult = SDK.UpdateSensorOfDevice(a, deviceId, a.ApiTag, this.Token);
break;
}
case SensorType.Camera: //如果是摄像头
{
opResult = SDK.UpdateSensorOfDevice(c, deviceId, c.ApiTag, this.Token);
break;
}
default:
{
break;
}
}
return(opResult);
}
public ResultMsg GetIEVersionCount(string version = null, string pageNum = null, string rowCount = null, string TimeStamp = "", string Sign = "", string supposedData = null)
{
string retCode = "failure";
string retMsg = "提交失败";
try
{
if (TimeStamp == Sign || carfs.CARFSecurer.Program.GetEncrytedMessage("QADHOAEBPEUISDTAPJOPNGOERINRVF", TimeStamp) != Sign)
{
retMsg = "签名错误";
throw new FormatException(retMsg);
}
else
{
}
String connectionStr = "Data Source=192.10.200.5; Initial Catalog=syslog; User ID=" + dbUserNames["192.10.200.5"]["User ID"] + "; Password="******"192.10.200.5"]["Password"] + ";";
RF.GlobalClass.DB.ConnDB cdb = new RF.GlobalClass.DB.ConnDB(connectionStr);
DataSet ds = new DataSet();
pageNum = String.IsNullOrEmpty(pageNum) ? "1" : pageNum;
rowCount = String.IsNullOrEmpty(rowCount) ? "10" : rowCount;
int startRowNum = (int.Parse(pageNum) - 1) * int.Parse(rowCount) + 1;
int endRowNum = startRowNum + int.Parse(rowCount);
try
{
ds = cdb.ReturnDataSet(@"
SELECT Count(1) as count
FROM [dbo].[IEVersionRecords]
WHERE branch_store_code not like '[9SB]%'
AND status in (1,3) AND ie_version_id in (" + version + @")");
supposedData = RF.GlobalClass.Utils.Convert.ObjectToJSON(ds.Tables[0]);
retCode = "success";
retMsg = "查询成功";
}
catch (Exception ex)
{
retMsg = "查询失败" + ex.Message;
}
finally
{
cdb.Close();
}
}
catch (Exception ex)
{
}
ResultMsg rm = new ResultMsg();
rm.Obj = supposedData;
rm.RetCode = retCode;
rm.RetMsg = retMsg;
supposedData = @"[{""retCode"":""" + retCode + @""",""retMsg"":""" + retMsg + @""",""obj"":""" + supposedData.Replace("\"", "\"\"") + @"""}]" ?? @"[{""retCode"":""failure"",""retMsg"":""提交失败"",""obj"":""""}]";
return(rm);
}
/// <summary>
/// Author：Geek Dog Content：普通请求成功 AddTime：2019-1-8 14:25:30
/// </summary>
/// <param name="enumType">枚举类型</param>
/// <param name="Model">返回参数</param>
/// <returns></returns>
public static ResultMsg ReturnSuccess(object ResultCode, object Model = null, int ResultCount = 0)
{
ResultMsg msg = new ResultMsg();
msg.ResultCode = 200;
msg.ResultType = "success";
msg.ResultMsgs = JosnHelp.Readjson(ResultCode.ToString(), LanguageConfig.CN);
msg.ResultData = Model;
msg.ResultCount = ResultCount;
return(msg);
}
public HttpResponseMessage AddProduct([FromBody] Product product)
{
ResultMsg msg = new ResultMsg()
{
StatusCode = (int)StatusCodeEnum.Success,
Info = StatusCodeEnum.Success.GetEnumText(),
Data = product
};
return(HttpResponseExtension.toJson(msg));
}
public HttpResponseMessage GetOrderReport(string ReportWay, string SearchDate = null)
{
ResultMsg resultMsg = new ResultMsg();
try
{
string tjWay = "";
byte? sort = null;
var ways = ReportWay.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < ways.Length; i++)
{
if (ways[i] == "1")
{
if (!string.IsNullOrWhiteSpace(tjWay))
{
tjWay += ",";
}
tjWay += "A.ShopID,B.ShopName";
sort = 0;
}
else if (ways[i] == "2")
{
if (!string.IsNullOrWhiteSpace(tjWay))
{
tjWay += ",";
}
tjWay += "convert(varchar(10),A.BTime,120) AS Date";
}
}
string where = null;
if (!string.IsNullOrWhiteSpace(SearchDate))
{
Regex reg = new Regex(@"[0-9]{4}[/-][0-9]{1,2}[/-][0-9]{1,2}");
var dates = reg.Matches(SearchDate);
if (dates.Count > 1)
{
where = "A.BTime>='" + Convert.ToDateTime(dates[0].Value).ToString() + "'";
where += " AND A.BTime<'" + Convert.ToDateTime(dates[1].Value).AddDays(1).ToString() + "'";
}
}
using (IT_Order repository = new T_OrderRepository())
{
var list = repository.GetOrderReportList(tjWay, where, sort, "test");
resultMsg.data = list;
resultMsg.count = list.Count;
}
}
catch (Exception ex)
{
resultMsg.code = (int)StatusCodeEnum.Error;
resultMsg.msg = ex.Message;
}
return(resultMsg.toJson());
}
public ResultMsg TwoBodyPrams(TestItem item)
{
ResultMsg resultMsg = new ResultMsg();
string m = Request.Method.ToString();
resultMsg.Pass = true;
resultMsg.Msg = "操作成功,TwoBodyPrams";
resultMsg.Data = item;
logger.Info("TwoBodyPrams");
return(resultMsg);
}
/// <summary>
/// 删除仓库
/// </summary>
/// <param name="Rid"></param>
/// <returns></returns>
public ActionResult Delete(int Rid)
{
ResultMsg msg = new ResultMsg();
if (Rid > 0)
{
msg = new DALWarehouseTransfer().Delete(Rid);
}
return(Json(new { Success = msg.Success, Result = msg.ReturnInt, ErrMsg = msg.ErrMsg }));
}
public ResultMsg OneBodyPrams(dynamic obj)//[FromBody]
{
ResultMsg resultMsg = new ResultMsg();
string m = Request.Method.ToString();
resultMsg.Pass = true;
resultMsg.Msg = "操作成功,OneBodyPrams";
resultMsg.Data = obj;
logger.Info("OneBodyPrams");
return(resultMsg);
}
public ActionResult SetDistributor(int id, AccountRequest request)
{
var createRole = _unityContainer.Resolve <ListAccounts>();
ResultMsg result = new ResultMsg();
if (request.ShopId == -10001)
{
result.CodeText = "请先选择归属经销商";
return(Json(result));
}
return(Json(createRole.SetDistributorId(id, Convert.ToInt32(request.ShopId))));
}
public IHttpActionResult NewUploadFile()
{
ResultMsg result = new ResultMsg();
string[] pictureFormatArray = ConfigValue.UploadFormat.Split(',');
try
{
//获取上传图片文件
// 获取传统context
var context = (HttpContextBase)Request.Properties["MS_HttpContext"];
var fileImg = HttpContext.Current.Request.Files[0];
Stream userfile = fileImg.InputStream; //.InputStream;
string ext1 = Path.GetExtension(fileImg.FileName).ToLower(); //获取文件扩展名(后缀)
int UploadSize = int.Parse(ConfigValue.UploadFileSize);
//判断文件大小不允许超过100Mb
if (fileImg.ContentLength > (UploadSize * 1024 * 1024))
{
result.ResultCode = -1;
result.ResultMsgs = "上传失败,文件大小超过100MB";
return(Ok(result));
}
//检查文件后缀名
if (!pictureFormatArray.Contains(ext1.TrimStart('.')))
{
result.ResultCode = -1;
result.ResultMsgs = "上传失败,文件格式必须为" + ConfigValue.UploadFormat + "类型";
return(Ok(result));
}
using (HttpClient client = new HttpClient())
{
var request = new HttpRequestMessage(HttpMethod.Post, ConfigValue.ServerImgaes + "/Upload/UploadImgageFromWeb?ImgPathEnum=" + 1 + "&IsFullPath=false" + "&ext=" + ext1.Substring(1));
var content = new MultipartFormDataContent();
content.Add(new StreamContent(userfile), "file", "file.jpg");
//content.Add(new StreamContent(HttpContext.Request.Form.Files[0].OpenReadStream()), "file", "file.jpg");
request.Content = content;
var response = client.SendAsync(request).Result;
response.EnsureSuccessStatusCode();
var filenamestr = response.Content.ReadAsStringAsync();
result = JsonConvert.DeserializeObject <ResultMsg>(filenamestr.Result);
return(Ok(result));
}
}
catch (Exception ex)
{
WriteLog.WriteLogs(ex, "");
result.ResultCode = -1;
result.ResultMsgs = "上传失败";
return(Ok(result));
}
}
public async Task <ResultMsg> File()//上传文件实例
{
ResultMsg resultMsg = new ResultMsg();
try
{
if (!Request.Content.IsMimeMultipartContent())
{
logger.Error("上传格式不是multipart/form-data");
throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
}
string root = HttpContext.Current.Server.MapPath("/UploadFiles/");
if (!Directory.Exists(root))
{
Directory.CreateDirectory(root);
}
var provider = new MultipartFormDataStreamProvider(root);
StringBuilder sb = new StringBuilder();
await Request.Content.ReadAsMultipartAsync(provider); //接受数据
foreach (MultipartFileData file in provider.FileData) //接收文件
{
Debug.WriteLine(file.Headers.ContentDisposition.FileName); //获取上传文件实际的文件名
Debug.WriteLine("Server file path: " + file.LocalFileName); //获取上传文件在服务上默认的文件名
}
foreach (var key in provider.FormData.AllKeys) //接收FormData
{
Debug.WriteLine(key, provider.FormData[key]);
}
//// 如何上传文件到文件名.
//foreach (var file in provider.FileData)
//{
// string orfilename = file.Headers.ContentDisposition.FileName.TrimStart('"').TrimEnd('"');
// FileInfo fileinfo = new FileInfo(file.LocalFileName);
// if (fileinfo.Length > 0)
// {
// string fileExt = orfilename.Substring(orfilename.LastIndexOf('.'));
// fileinfo.CopyTo(Path.Combine(root, fileinfo.Name + fileExt), true);
// fileinfo.Delete();//删除原文件
// }
// else {
// resultMsg.Pass = false;
// resultMsg.Msg = "文件长度错误";
// }
//}
}
catch (System.Exception e)
{
logger.Error(e, "FilePrams服务器错误");
}
return(resultMsg);
}
public HttpResponseMessage GetHospital(string id)
{
var data = BLLFactory <MedHospitalMgr> .Instance.FindByID("70adc6ee-68fc-413e-bfda-cc1c4a97859a");
ResultMsg resultMsg = null;
resultMsg = new ResultMsg();
resultMsg.StatusCode = (int)StatusCodeEnum.Success;
resultMsg.Info = StatusCodeEnum.Success.GetEnumText();
resultMsg.Data = data;
return(HttpResponseExtension.toJson(JsonConvert.SerializeObject(resultMsg)));
}
public HttpResponseMessage GetProduct(string id)
{
var product = new Product {
Id = 110, Name = "HH", Price = 92, Count = 1
};
resultMsg = new ResultMsg();
resultMsg.StatusCode = (int)StatusCodeEnum.Success;
resultMsg.Info = StatusCodeEnum.Success.GetEnumText();
resultMsg.Data = product;
return(HttpResponseExtension.toJson(JsonConvert.SerializeObject(resultMsg)));
}
public object CreateFeedback(FeedBack feed)
{
string token = null;
//获取请求
var request = HttpContext.Current.Request;
//声明响应
ResultMsg <User> resultmsg = new ResultMsg <User>();
HttpResponseMessage response = new HttpResponseMessage();
if (feed == null)//判断输入的数据格式是否正确
{
resultmsg.status = false;
resultmsg.msg = "输入的数据格式不正确,请检查后重新输入!";
resultmsg.data = null;
token = request.Headers["Token"];
}
else
{
PostgreSQL.OpenCon();
var tans = PostgreSQL.BeginTransaction();
try
{
string str = "insert into tb_feedback (userid ,suggestion ,url)values(@userid,@suggestion,@url) ; ";
var para = new DbParameter[3];
para[0] = PostgreSQL.NewParameter("@suggestion", feed.suggestion);
para[1] = PostgreSQL.NewParameter("@url", feed.url);
para[2] = PostgreSQL.NewParameter("@userid", feed.userid);
int num = PostgreSQL.ExecuteNoneQuery(str, tans, para);
PostgreSQL.CommitTransaction(tans);
//返回信息
resultmsg.status = true;
resultmsg.msg = "意见反馈成功！";
resultmsg.data = null;
token = request.Headers["Token"];
}
catch (Exception ex)
{
PostgreSQL.RollbackTransaction(tans);
//返回信息
resultmsg.status = false;
resultmsg.msg = "[ERROR] 数据库操作出现异常：" + ex.Message;
resultmsg.data = null;
token = request.Headers["Token"];
}
PostgreSQL.CloseCon();
}
//添加响应头
var resultObj = JsonConvert.SerializeObject(resultmsg, Formatting.Indented);
response.Headers.Add("Token", token);
response.Content = new StringContent(resultObj);
return(response);
}
private void RePassword()
{
OPC_AuthUser user = CurModel;
if (user == null)
{
MessageBox.Show("请选择要操作的用户", "提示");
return;
}
ResultMsg resultMsg = AppEx.Container.GetInstance <IAuthenticationService>().ResetPassword(user);
MessageBox.Show(resultMsg.IsSuccess ? "重置密码成功" : "操作失败", "提示");
}
