/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ServiceQualityInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into servicequalityinfo(");
strSql.Append("LSH,CASEID,CCCC,CLID,TIMETAKEN,MONEY,KM,ADDTIME)");
strSql.Append(" values (");
strSql.Append("@LSH,@CASEID,@CCCC,@CLID,@TIMETAKEN,@MONEY,@KM,@ADDTIME)");
MySqlParameter[] parameters =
{
new MySqlParameter("@LSH", DBOpHelper.GetString(model.LSH)),
new MySqlParameter("@CASEID", DBOpHelper.GetString(model.CASEID)),
new MySqlParameter("@CCCC", DBOpHelper.GetNumber(model.CCCC)),
new MySqlParameter("@CLID", DBOpHelper.GetString(model.CLID)),
new MySqlParameter("@TIMETAKEN", DBOpHelper.GetNumber(model.TIMETAKEN)),
new MySqlParameter("@MONEY", DBOpHelper.GetNumber(model.MONEY)),
new MySqlParameter("@KM", DBOpHelper.GetNumber(model.KM)),
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);
}
}
/// <summary>
/// 发送服务质量信息给route server
/// </summary>
/// <param name="cl"></param>
public void SendQualityInfo(ServiceQualityInfo sqi)
{
Hashtable ht = GetQualityInfoHashtableByModel(sqi);
ScsTextMessage message = new ScsTextMessage(JSON.Encode(ht));
SendMessage(message);
}
public void HandleQualityInfo(ServiceQualityInfo sqi)
{
try
{
//Save Database
// DBServiceQualityInfo db = new DBServiceQualityInfo();
IDBServiceQualityInfo db = DataAccess.DataAccess.GetDBServiceQualityInfo();
db.Add(sqi);
QualityInfoManagerDelegateClient client = new QualityInfoManagerDelegateClient();
client.addQualityInfoCompleted += new EventHandler <addQualityInfoCompletedEventArgs>(Service_Completed);
CredentialSoapHeader header = new CredentialSoapHeader();
header.Username = SysParameters.AppAPIUsername;
header.Password = SysParameters.AppAPIPassword;
string strJson = ConvertModelToJson(sqi);
WebserviceUserState UserState = new WebserviceUserState();
UserState.TIMES = 1;
UserState.MESSAGE = strJson;
client.addQualityInfoAsync(header, strJson, UserState);
}
catch (Exception ex)
{
LogHelper.WriteLog("", ex);
}
}
private ServiceQualityInfo GetServiceQualityInfoModelByHashtable(Hashtable htMessage)
{
ServiceQualityInfo cl = new ServiceQualityInfo();
cl.CASEID = htMessage["caseId"].ToString();
return(cl);
}
private string ConvertModelToJson(ServiceQualityInfo sqi)
{
string strJson = "";
Hashtable ht = new Hashtable();
ht.Add("caseId", sqi.CASEID);
ht.Add("cccc", sqi.CCCC);
ht.Add("clid", sqi.CLID);
ht.Add("km", sqi.KM);
ht.Add("lsh", sqi.LSH);
ht.Add("money", sqi.MONEY);
strJson = JSON.Encode(ht);
return(strJson);
}
public Hashtable GetQualityInfoHashtableByModel(ServiceQualityInfo sqi)
{
/*
* lsh; String 服务流水号 Varchar2(50)，not null 50 必填,主键，接口服务端自动生成，并返回客户端
* caseId String CaseID Varchar2(50) 50 必填,由APP提供
* cccc Integer 出车车次 Number(2) 2 必填
* clid String 车俩ID Varchar2(10) not null 10 必填
* money Double 服务费用 Number(8,3) 8
* km Double 公里数 Number(8,3) 8
*/
Hashtable ht = new Hashtable();
ht.Add("messageName", "ServiceQualityInfo");
ht.Add("caseId", sqi.CASEID);
ht.Add("cccc", sqi.CCCC);
ht.Add("clid", sqi.CLID);
ht.Add("km", sqi.KM);
ht.Add("lsh", sqi.LSH);
ht.Add("money", sqi.MONEY);
return(ht);
}
public void SendQualityInfo(ServiceQualityInfo sqi)
{
aqi.HandleQualityInfo(sqi);
}
private void HandleServiceQualityInfo(Hashtable htMessage)
{
ServiceQualityInfo sqi = GetServiceQualityInfoModelByHashtable(htMessage);
Appserver.SendQualityInfo(sqi);
}
