public int InsQunar_visitperson(CreateOrderForBeforePaySyncRequestBodyorderInfovisitPersonperson mperson, string qunar_orderId)
{
using (var helper = new SqlHelper())
{
int id = new InternalQunar_CreateOrderForBeforePaySyncvisitperson(helper).InsQunar_visitperson(mperson, qunar_orderId);
return(id);
}
}
internal int InsQunar_visitperson(CreateOrderForBeforePaySyncRequestBodyorderInfovisitPersonperson mperson, string qunar_orderId)
{
try
{
string sql = @"INSERT INTO [qunar_CreateOrderForBeforePaySyncvisitperson]
([name]
,[namePinyin]
,[credentials]
,[credentialsType]
,[defined1Value]
,[defined2Value]
,[qunar_orderid])
VALUES
(@name
,@namePinyin
,@credentials
,@credentialsType
,@defined1Value
,@defined2Value
,@qunar_orderid);select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@name", mperson.name);
cmd.AddParam("@namePinyin", mperson.namePinyin);
cmd.AddParam("@credentials", mperson.credentials);
cmd.AddParam("@credentialsType", mperson.credentialsType);
cmd.AddParam("@defined1Value", mperson.defined1Value);
cmd.AddParam("@defined2Value", mperson.defined2Value);
cmd.AddParam("@qunar_orderid", qunar_orderId);
object o = cmd.ExecuteScalar();
return(int.Parse(o.ToString()));
}
catch
{
return(0);
}
}
