// 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);
}
}
