//保存语音查询记录
public bool SaveVoiceQuery(VoiceQueryRecord record)
{
SqlConnection connection = new SqlConnection();
SqlTransaction transaction = null;
SqlCommand command = new SqlCommand();
connection.ConnectionString = SqlHelper.ConnString;
try
{
connection.Open();
command.Connection = connection;
transaction = connection.BeginTransaction();
command.Transaction = transaction;
UpdateVoiceQueryTime(command, record);
AddVoiceQueryRecrod(command, record);
transaction.Commit();
return(true);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
if (connection.State != ConnectionState.Closed)
{
connection.Close();
}
command.Dispose();
connection.Dispose();
}
return(false);
}
public bool GetTrainmanBaseInfoByNumber(string strTrainmanNumber, ref VoiceQueryRecord record)
{
string sqlText = string.Format("select strTrainmanJiaoluGUID,strTrainmanName,strTrainmanGUID from TAB_Org_Trainman where strTrainmanNumber='{0}' ", strTrainmanNumber);
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strTrainmanNumber", strTrainmanNumber) };
DataTable table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sqlText).Tables[0];
if (table != null && table.Rows.Count > 0)
{
table.Rows[0]["strTrainmanJiaoluGUID"].ToString();
record.strTrainmanNumber = strTrainmanNumber;
record.strTrainmanName = table.Rows[0]["strTrainmanName"].ToString();
record.strTrainmanGUID = table.Rows[0]["strTrainmanGUID"].ToString();
}
sqlText = string.Format("SELECT TOP 1 strTrainmanJiaoluGUID,strTrainmanJiaoluName FROM VIEW_Nameplate_Group where strTrainmanNumber1 = '{0}' or strTrainmanNumber2 = '{0}' or strTrainmanNumber3 = '{0}' or strTrainmanNumber4 = '{0}'", strTrainmanNumber);
table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sqlText).Tables[0];
if (table != null && table.Rows.Count > 0)
{
record.strTrainmanJiaoluGUID = table.Rows[0]["strTrainmanJiaoluGUID"].ToString();
record.strTrainmanJiaoluName = GetTrainmanJiaoluNameByGUID(record.strTrainmanJiaoluGUID);
return(true);
}
return(false);
}
public JsonModel GetBanXuByTrainmanGUID(string data)
{
JsonModel jsonModel = new JsonModel();
TF.RunSafty.BLL.LCNameGroup bllNameGroup = new RunSafty.BLL.LCNameGroup();
try
{
OrderGroupQuery paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <OrderGroupQuery>(data);
//string jiaoluID = "";
VoiceQueryRecord record = new VoiceQueryRecord();
//根据工号获取人员交路GUID
//jiaoluID = GetTrainmanJiaoluGUIDByNumber(paramModel.strTrainmanNumber);
GetTrainmanBaseInfoByNumber(paramModel.strTrainmanNumber, ref record);
record.strCallerNum = paramModel.strPhoneNum;
List <string> placeIDs = new List <string>();
string trainmanID = paramModel.strTrainmanNumber;
string strLatestStartTime = GetLatestStartTimeOfTrainjiaolu(record.strTrainmanJiaoluGUID);
List <OrderGroup> groups = GetOrderGroups(record.strTrainmanJiaoluGUID, placeIDs, "");
int nIndex = GetTrainmanIndex(groups, record.strTrainmanNumber);
if (nIndex > 0)
{
jsonModel.data.strWorkOrder = nIndex.ToString();
jsonModel.data.strStartTime = strLatestStartTime;
if (paramModel.nSave == 1)
{
record.dtQueryTime = DateTime.Now;
record.nOrder = nIndex;
record.strGroupGUID = groups[nIndex - 1].group.groupID;
if (strLatestStartTime != "")
{
record.dtLastBeginWorkTime = Convert.ToDateTime(strLatestStartTime);
}
SaveVoiceQuery(record);
}
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
}
else
{
jsonModel.result = 1;
jsonModel.resultStr = "提交失败,找不到乘务员所属机组信息";
}
}
catch (Exception ex)
{
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
return(jsonModel);
}
//更新最后一次语音查询班序时间
public void UpdateVoiceQueryTime(SqlCommand command, VoiceQueryRecord record)
{
string sqlText = "update TAB_Nameplate_TrainmanJiaolu_Order set dtLastVoiceQueryTime = @dtLastVoiceQueryTime where strGroupGUID = @strGoupGUID";
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("dtLastVoiceQueryTime", record.dtQueryTime),
new SqlParameter("strGoupGUID", record.strGroupGUID)
};
command.CommandText = sqlText;
command.Parameters.Clear();
command.Parameters.AddRange(sqlParams);
command.ExecuteNonQuery();
}
//插入语音查询记录
public void AddVoiceQueryRecrod(SqlCommand command, VoiceQueryRecord record)
{
string sqlText = "Insert into TAB_Voice_QueryOrderRecord values(@strGUID,@strTrainmanJiaoluGUID,@strTrainmanJiaoluName,@strGroupGUID,@strTrainmanGUID";
sqlText = sqlText + ",@strTrainmanNumber,@strTrainmanName,@strCallerNum,@dtQueryTime,@dtLastBeginWorkTime,@nOrder)";
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("strGUID", Guid.NewGuid().ToString()),
new SqlParameter("strTrainmanJiaoluGUID", record.strTrainmanJiaoluGUID),
new SqlParameter("strTrainmanJiaoluName", record.strTrainmanJiaoluName),
new SqlParameter("strGroupGUID", record.strGroupGUID),
new SqlParameter("strTrainmanGUID", record.strTrainmanGUID),
new SqlParameter("strTrainmanNumber", record.strTrainmanNumber),
new SqlParameter("strTrainmanName", record.strTrainmanName),
new SqlParameter("strCallerNum", record.strCallerNum),
new SqlParameter("dtQueryTime", record.dtQueryTime),
new SqlParameter("dtLastBeginWorkTime", record.dtLastBeginWorkTime),
new SqlParameter("nOrder", record.nOrder)
};
command.CommandText = sqlText;
command.Parameters.Clear();
command.Parameters.AddRange(sqlParams);
command.ExecuteNonQuery();
}
