/// <summary>
/// 保存语音文件名到数据库
/// </summary>
/// <param name="ss"></param>
public static bool SavaVoiceFiles(List <string> ss)
{
if (ss != null)
{
List <string> list;
GetVoiceList(out list);
var sqlmodels = new List <SqlTextModel>();
for (int i = 0; i < ss.Count; i++)
{
string name = ss[i].Split(';').ToList()[0];
string time = ss[i].Split(';').ToList()[1];
if (!list.Contains(name))
{
string sql = "insert into ipvt_voicefiletable(VoiceFileName,Description) values(?name,?filetime)";
var ps = new MySqlParameter[2];
ps[0] = new MySqlParameter("?name", name);
ps[1] = new MySqlParameter("?filetime", time);
var model = new SqlTextModel {
SqlString = sql, MySqlParams = ps
};
sqlmodels.Add(model);
}
}
return(CustomMySqlHelper.ExecuteSqlList(sqlmodels));
}
return(false);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="models"></param>
/// <returns></returns>
public static bool SavePortAlarmModels(ObservableCollection <CommonModel> models)
{
List <SqlTextModel> list = new List <SqlTextModel>();
if (models != null)
{
for (int i = 0; i < models.Count; i++)
{
SqlTextModel model = new SqlTextModel();
model.SqlString = "update ipvt_alarmtypetable set AlarmType=?type where AlarmTypeID=?id";
model.MySqlParams = new[]
{
new MySqlParameter("?type", models[i].Content),
new MySqlParameter("?id", models[i].Id)
};
list.Add(model);
}
}
if (list.Count > 0)
{
return(CustomMySqlHelper.ExecuteSqlList(list));
}
return(false);
}
/// <summary>
/// 生成删除语句
/// </summary>
/// <param name="tran">转移对象</param>
public static SqlTextModel CreateSqlTextModel(Transfer tran)
{
SqlTextModel model = null;
if (tran != null)
{
if (tran.Id != 0)
{
string sqlStr = "delete from ipvt_transferinfotable where TransferID=?id";
var parameteres = new MySqlParameter[1];
parameteres[0] = new MySqlParameter("?id", tran.Id);
if (tran.ExtensionNo == "2")
{
model = new SqlTextModel {
SqlString = sqlStr, MySqlParams = parameteres
};
}
else if (tran.ExtensionNo == "1")
{
model = new SqlTextModel {
SqlString = sqlStr, MySqlParams = parameteres
};
}
}
}
return(model);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static bool DeleteFiles(List <string> list)
{
if (list != null)
{
var sqlmodels = new List <SqlTextModel>();
for (int i = 0; i < list.Count; i++)
{
string sql = "delete from ipvt_voicefiletable where VoiceFileName=?name and VoiceType=0";
var ps = new MySqlParameter("?name", list[i]);
var model = new SqlTextModel {
SqlString = sql, MySqlParams = new[] { ps }
};
sqlmodels.Add(model);
}
return(CustomMySqlHelper.ExecuteSqlList(sqlmodels));
}
return(false);
}
/// <summary>
/// 保存广播语音文件名到数据库
/// </summary>
/// <param name="ss"></param>
/// <param name="phoneId">中心分机id</param>
public static bool SavaBroadcastVoices(List <string> ss, int phoneId)
{
if (ss != null && ss.Count > 0)
{
Dictionary <int, string> dictionary = GetVoices(phoneId);
var sqlmodels = new List <SqlTextModel>();
foreach (int id in dictionary.Keys)
{
if (!ss.Contains(dictionary[id]))
{
DeleteVoice(id);
}
}
for (int i = 0; i < ss.Count; i++)
{
if (!dictionary.Values.Contains(ss[i]))
{
string sql =
"insert into ipvt_voicefiletable(VoiceFileName,VoiceType,PhoneNumber) values(?name,?type,?num)";
var ps = new MySqlParameter[3];
ps[0] = new MySqlParameter("?name", ss[i]);
ps[1] = new MySqlParameter("?type", 1);
ps[2] = new MySqlParameter("?num", phoneId);
var model = new SqlTextModel {
SqlString = sql, MySqlParams = ps
};
sqlmodels.Add(model);
}
}
return(CustomMySqlHelper.ExecuteSqlList(sqlmodels));
}
return(false);
}
