// PUT: api/Faults/5 public void Put(int id, [FromBody] FaultDataModel value) { var service = new FaultService(); var result = new FaultModel() { id_mieszkania = value.id_mieszkania, id_usterki = value.id_usterki, opis = value.opis, stan = value.stan }; service.AddOrEditFault(result); }
public FaultDataModel GetSingleFaultDataModel(int faultId) { var rental = new FaultDataModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.FaultsDataView.FirstOrDefault(x => x.id_usterki == faultId); rental = ModelMapper.Mapper.Map <FaultDataModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(rental); }
public bool CreateFaultOrder(FaultType _type) { var fdm = new FaultDataModel(); if (User == null) { //不能创建 Prompt = "报修人员未选择!"; return(false); } else { fdm.user_id = User.Key; } if (Department == null) { //不能创建 Prompt = "请选择部门!"; return(false); } else { fdm.department_id = Department.Key; } if (AssetType == null) { //不能创建 Prompt = "资产类型未选择!"; return(false); } else { fdm.asset_type_id = AssetType.Key; } if (Company == null) { //不能创建 Prompt = "请选择区域!"; return(false); } else { fdm.company_id = Company.Key; } if (OrderType == null) { //不能创建 Prompt = "请选择工单类型!"; return(false); } else { fdm.work_property = OrderType.Text; } //故障类型 if (BreakDownCate == null) { fdm.breakdown_categ = FaultDict[2].Text; } else { fdm.breakdown_categ = BreakDownCate.Text; } //故障主题------------(-1可能导致外键错误) if (KnowLedge == null) { fdm.knowledge_id = 0; } else { fdm.knowledge_id = KnowLedge.Key; } //去除换行符 Regex reg = new Regex(@"\b\r\n"); fdm.note = reg.Replace(Note, ";"); fdm.address = reg.Replace(Address, ";"); fdm.note_result = reg.Replace(Note_Result, ";"); //设置录音记录信息 fdm.SetData(_DataModel); //这里地址需要加上ip地址(目前不需要加IP了) //string ipStr = Provider.getIPAddress(); //if (ipStr == Properties.Settings.Default.ServerIP) //{ fdm.WaveFilePath = WaveFilePath; //} //else //{ // fdm.WaveFilePath = ipStr + "\\" + WaveFilePath; //} //插入服务器 if (CreteFaultList.CreateOrder(fdm, _type, IsInsert)) { CreteFaultList.UpdateIsCreate(AccessID, _type); return(true); } return(false); }
/// <summary> /// 创建故障单 /// </summary> /// <param name="fdm"></param> /// <returns></returns> public static bool CreateOrder(FaultDataModel fdm, FaultType _type, bool _IsInsert) { string sql = string.Empty; int rows = 0; //只有当未接听的时候才插入,否则都是更新 #region postgreSQL /* * if (_IsInsert) * { * sql = "insert into call_log(date,start_time,during_time,phone,note,file_path,line_no,chan_id,user_id,asset_type_id,breakdown_categ,company_id,address,state,work_property,department_id,knowledge_id,note_result,source_id)" + * " values(@date,@start_time,@during_time,@phone,@note,@file_path,@line_no,@chan_id,@user_id,@asset_type_id,@breakdown_categ,@company_id,@address,@state,@work_property,@department_id,@knowledge_id,@note_result,@source_id)"; * NpgsqlParameter[] para = { * new NpgsqlParameter("@date", NpgsqlDbType.Date), * new NpgsqlParameter("@start_time",NpgsqlDbType.Varchar), * new NpgsqlParameter("@during_time", NpgsqlDbType.Varchar), * new NpgsqlParameter("@phone",NpgsqlDbType.Varchar), * new NpgsqlParameter("@note", NpgsqlDbType.Varchar), * new NpgsqlParameter("@file_path", NpgsqlDbType.Varchar), * new NpgsqlParameter("@line_no", NpgsqlDbType.Varchar), * new NpgsqlParameter("@chan_id",NpgsqlDbType.Integer), * new NpgsqlParameter("@user_id", NpgsqlDbType.Integer), * new NpgsqlParameter("@asset_type_id",NpgsqlDbType.Integer), * new NpgsqlParameter("@breakdown_categ",NpgsqlDbType.Varchar), * new NpgsqlParameter("@company_id",NpgsqlDbType.Integer), * new NpgsqlParameter("@address",NpgsqlDbType.Varchar), * new NpgsqlParameter("@state",NpgsqlDbType.Varchar), * new NpgsqlParameter("@work_property",NpgsqlDbType.Varchar), * new NpgsqlParameter("@department_id",NpgsqlDbType.Integer), * new NpgsqlParameter("@knowledge_id",NpgsqlDbType.Integer), * new NpgsqlParameter("@note_result",NpgsqlDbType.Varchar), * new NpgsqlParameter("@source_id",NpgsqlDbType.Integer), * }; * para[0].Value = fdm.StartDate; * para[1].Value = fdm.StartTime; * para[2].Value = fdm.DuringTime; * para[3].Value = fdm.CallerID; * para[4].Value = fdm.note; * para[5].Value = fdm.WaveFilePath; * para[6].Value = fdm.LineID; * para[7].Value = fdm.Chan; * para[8].Value = fdm.user_id; * para[9].Value = fdm.asset_type_id; * para[10].Value = fdm.breakdown_categ; * para[11].Value = fdm.company_id; * para[12].Value = fdm.address; * para[13].Value = GetState(_type); * para[14].Value = fdm.work_property; * para[15].Value = fdm.department_id; * para[16].Value = fdm.knowledge_id; * para[17].Value = fdm.note_result; * para[18].Value = fdm.ID; * * rows = PostgresqlHelper.ExecuteNonQuery(sql, para); * } * else * { * sql = "update call_log set note=@note,user_id=@user_id,asset_type_id=@asset_type_id,breakdown_categ=@breakdown_categ,company_id=@company_id,address=@address,state=@state," + "work_property=@work_property,department_id=@department_id,knowledge_id=@knowledge_id,note_result=@note_result where source_id=@source_id and phone=@phone"; + NpgsqlParameter[] para = { + + new NpgsqlParameter("@phone",NpgsqlDbType.Varchar), + new NpgsqlParameter("@note", NpgsqlDbType.Varchar), + new NpgsqlParameter("@user_id", NpgsqlDbType.Integer), + new NpgsqlParameter("@asset_type_id",NpgsqlDbType.Integer), + new NpgsqlParameter("@breakdown_categ",NpgsqlDbType.Varchar), + new NpgsqlParameter("@company_id",NpgsqlDbType.Integer), + new NpgsqlParameter("@address",NpgsqlDbType.Varchar), + new NpgsqlParameter("@state",NpgsqlDbType.Varchar), + new NpgsqlParameter("@work_property",NpgsqlDbType.Varchar), + new NpgsqlParameter("@department_id",NpgsqlDbType.Integer), + new NpgsqlParameter("@knowledge_id",NpgsqlDbType.Integer), + new NpgsqlParameter("@note_result",NpgsqlDbType.Varchar), + new NpgsqlParameter("@source_id",NpgsqlDbType.Integer), + }; + para[0].Value = fdm.CallerID; + para[1].Value = fdm.note; + para[2].Value = fdm.user_id; + para[3].Value = fdm.asset_type_id; + para[4].Value = fdm.breakdown_categ; + para[5].Value = fdm.company_id; + para[6].Value = fdm.address; + para[7].Value = GetState(_type); + para[8].Value = fdm.work_property; + para[9].Value = fdm.department_id; + para[10].Value = fdm.knowledge_id; + para[11].Value = fdm.note_result; + para[12].Value = fdm.ID; + + rows = PostgresqlHelper.ExecuteNonQuery(sql, para); + }*/ #endregion //sqlserver if (_IsInsert) { sql = "insert into call_log(date,start_time,during_time,phone,note,file_path,line_no,chan_id,user_id,asset_type_id,breakdown_categ,company_id,address,state,work_property,department_id,knowledge_id,note_result,source_id)" + " values(@date,@start_time,@during_time,@phone,@note,@file_path,@line_no,@chan_id,@user_id,@asset_type_id,@breakdown_categ,@company_id,@address,@state,@work_property,@department_id,@knowledge_id,@note_result,@source_id)"; MySqlParameter[] para = { new MySqlParameter("@date", MySqlDbType.Date), new MySqlParameter("@start_time", MySqlDbType.VarChar), new MySqlParameter("@during_time", MySqlDbType.VarChar), new MySqlParameter("@phone", MySqlDbType.VarChar), new MySqlParameter("@note", MySqlDbType.VarChar), new MySqlParameter("@file_path", MySqlDbType.VarChar), new MySqlParameter("@line_no", MySqlDbType.VarChar), new MySqlParameter("@chan_id", MySqlDbType.Int32), new MySqlParameter("@user_id", MySqlDbType.Int32), new MySqlParameter("@asset_type_id", MySqlDbType.Int32), new MySqlParameter("@breakdown_categ", MySqlDbType.VarChar), new MySqlParameter("@company_id", MySqlDbType.Int32), new MySqlParameter("@address", MySqlDbType.VarChar), new MySqlParameter("@state", MySqlDbType.VarChar), new MySqlParameter("@work_property", MySqlDbType.VarChar), new MySqlParameter("@department_id", MySqlDbType.Int32), new MySqlParameter("@knowledge_id", MySqlDbType.Int32), new MySqlParameter("@note_result", MySqlDbType.VarChar), new MySqlParameter("@source_id", MySqlDbType.Int32), }; para[0].Value = fdm.StartDate; para[1].Value = fdm.StartTime; para[2].Value = fdm.DuringTime; para[3].Value = fdm.CallerID; para[4].Value = fdm.note; para[5].Value = fdm.WaveFilePath; para[6].Value = fdm.LineID; para[7].Value = fdm.Chan; para[8].Value = fdm.user_id; para[9].Value = fdm.asset_type_id; para[10].Value = fdm.breakdown_categ; para[11].Value = fdm.company_id; para[12].Value = fdm.address; para[13].Value = GetState(_type); para[14].Value = fdm.work_property; para[15].Value = fdm.department_id; para[16].Value = fdm.knowledge_id; para[17].Value = fdm.note_result; para[18].Value = fdm.ID; rows = MySqlHelperClass.ExecuteNonQuery(MySqlHelperClass.GetConn(), System.Data.CommandType.Text, sql, para); } else { sql = "update call_log set note=@note,user_id=@user_id,asset_type_id=@asset_type_id,breakdown_categ=@breakdown_categ,company_id=@company_id,address=@address,state=@state," + "work_property=@work_property,department_id=@department_id,knowledge_id=@knowledge_id,note_result=@note_result where source_id=@source_id and phone=@phone"; MySqlParameter[] para = { new MySqlParameter("@phone", MySqlDbType.VarChar), new MySqlParameter("@note", MySqlDbType.VarChar), new MySqlParameter("@user_id", MySqlDbType.Int32), new MySqlParameter("@asset_type_id", MySqlDbType.Int32), new MySqlParameter("@breakdown_categ", MySqlDbType.VarChar), new MySqlParameter("@company_id", MySqlDbType.Int32), new MySqlParameter("@address", MySqlDbType.VarChar), new MySqlParameter("@state", MySqlDbType.VarChar), new MySqlParameter("@work_property", MySqlDbType.VarChar), new MySqlParameter("@department_id", MySqlDbType.Int32), new MySqlParameter("@knowledge_id", MySqlDbType.Int32), new MySqlParameter("@note_result", MySqlDbType.VarChar), new MySqlParameter("@source_id", MySqlDbType.Int32), }; para[0].Value = fdm.CallerID; para[1].Value = fdm.note; para[2].Value = fdm.user_id; para[3].Value = fdm.asset_type_id; para[4].Value = fdm.breakdown_categ; para[5].Value = fdm.company_id; para[6].Value = fdm.address; para[7].Value = GetState(_type); para[8].Value = fdm.work_property; para[9].Value = fdm.department_id; para[10].Value = fdm.knowledge_id; para[11].Value = fdm.note_result; para[12].Value = fdm.ID; rows = MySqlHelperClass.ExecuteNonQuery(MySqlHelperClass.GetConn(), System.Data.CommandType.Text, sql, para); } if (rows > 0) { return(true); } else { return(false); } }