/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HandleCallError model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HandleCallError(");
strSql.Append("CASEID,ERRORCODE,ERRORMSG,ERRORTIME,ADDTIME)");
strSql.Append(" values (");
strSql.Append(":CASEID,:ERRORCODE,:ERRORMSG,:ERRORTIME,:ADDTIME)");
OracleParameter[] parameters =
{
new OracleParameter(":CASEID", DBOpHelper.GetString(model.CASEID)),
new OracleParameter(":ERRORCODE", DBOpHelper.GetString(model.ERRORCODE)),
new OracleParameter(":ERRORMSG", DBOpHelper.GetString(model.ERRORMSG)),
new OracleParameter(":ERRORTIME", DBOpHelper.GetDateTime(model.ERRORTIME)),
new OracleParameter(":ADDTIME", DBOpHelper.GetDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")))
};
int rows = DbHelperOra.ExecuteSql(SysParameters.DBConnectString, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HandleCallError model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into handlecallerror(");
strSql.Append("CASEID,ERRORCODE,ERRORMSG,ERRORTIME,ADDTIME)");
strSql.Append(" values (");
strSql.Append("@CASEID,@ERRORCODE,@ERRORMSG,@ERRORTIME,@ADDTIME)");
MySqlParameter[] parameters =
{
new MySqlParameter("@CASEID", DBOpHelper.GetString(model.CASEID)),
new MySqlParameter("@ERRORCODE", DBOpHelper.GetString(model.ERRORCODE)),
new MySqlParameter("@ERRORMSG", DBOpHelper.GetString(model.ERRORMSG)),
new MySqlParameter("@ERRORTIME", DBOpHelper.GetDateTime(model.ERRORTIME)),
new MySqlParameter("@ADDTIME", DBOpHelper.GetDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")))
};
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void HandleCallError(HandleCallError hce)
{
try
{
//Save Database
IDBHandleCallError db = DataAccess.DataAccess.GetDBHandleCallError();
db.Add(hce);
CallErrorManagerDelegateClient client = new CallErrorManagerDelegateClient();
client.addCallErrorCompleted += new EventHandler <addCallErrorCompletedEventArgs>(Service_Completed);
CredentialSoapHeader header = new CredentialSoapHeader();
header.Username = SysParameters.AppAPIUsername;
header.Password = SysParameters.AppAPIPassword;
string strJson = ConvertModelToJson(hce);
WebserviceUserState UserState = new WebserviceUserState();
UserState.TIMES = 1;
UserState.MESSAGE = strJson;
client.addCallErrorAsync(header, strJson, UserState);
}
catch (Exception ex)
{
LogHelper.WriteLog("", ex);
}
}
private string ConvertModelToJson(HandleCallError hce)
{
string strJson = "";
Hashtable ht = new Hashtable();
ht.Add("caseId", hce.CASEID);
ht.Add("errorCode", hce.ERRORCODE);
ht.Add("errorMsg", hce.ERRORMSG);
ht.Add("errorTime", string.Format("{0:yyyy-MM-dd HH:mm:ss}", hce.ERRORTIME));
strJson = JSON.Encode(ht);
return(strJson);
}
private void HandleAppCallInfo(AppCallInfo aci)
{
try
{
IDBRouter router = DataAccess.DataAccess.GetDBRouter();
string strUnitCode = router.GetUnitCodeByRegistCity(aci.PROVINCE, aci.CITY, aci.AREA);
if (string.IsNullOrEmpty(strUnitCode))
{
//send error msg to app server
HandleCallError hce = new HandleCallError();
hce.CASEID = aci.CASEID;
hce.ERRORCODE = "1";
hce.ERRORMSG = "未注册APP急救服务";
hce.ERRORTIME = DateTime.Now;
Appserver.SendCallError(hce);
}
else
{
ServerClient client = CoreService.GetInstance().CallInServer.GetServerClientByUnitCode(strUnitCode);
if (client != null)
{
//send msg to app client
string msg = CreateCallInfoJsonByModel(aci);
client.SendMessage(new ScsTextMessage(msg));
}
else
{
//send error msg to app server
HandleCallError hce = new HandleCallError();
hce.CASEID = aci.CASEID;
hce.ERRORCODE = "2";
hce.ERRORMSG = "未找到服务通讯";
hce.ERRORTIME = DateTime.Now;
Appserver.SendCallError(hce);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog("程序异常!", ex);
}
}
public void SendCallError(HandleCallError hce)
{
ace.HandleCallError(hce);
}
