1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| namespace AsiaINFO.SMS.DBFactory
| {
| using AsiaINFO.DBHelpers.MSSqlDB;
| using AsiaINFO.SMS.Entity;
| using System;
| using System.Data;
| using System.Data.SqlClient;
|
| public class MOFactory
| {
| public static void AddMOInfo(MOInfo mo)
| {
| SqlParameter[] commandParameters = new SqlParameter[] { DBHelper.MakeInParam("@GUID", SqlDbType.VarChar, 50, mo.Guid), DBHelper.MakeInParam("@MSGID", SqlDbType.VarChar, 50, mo.MSGID.ToString()), DBHelper.MakeInParam("@UP_TIME", SqlDbType.DateTime, 20, mo.UP_TIME), DBHelper.MakeInParam("@LONG_SERV_NO", SqlDbType.VarChar, 30, mo.LONG_SERV_NO), DBHelper.MakeInParam("@SERV_CODE", SqlDbType.VarChar, 10, mo.SERV_CODE), DBHelper.MakeInParam("@MOBILE_NO", SqlDbType.VarChar, 0x20, mo.MOBILE_NO), DBHelper.MakeInParam("@MOBILE_NO_TYPE", SqlDbType.Char, 1, mo.MOBILE_NO_TYPE), DBHelper.MakeInParam("@SMS_CONTENT", SqlDbType.VarChar, 160, mo.SMS_CONTENT), DBHelper.MakeInParam("@LINK_ID", SqlDbType.VarChar, 20, mo.LINKID), DBHelper.MakeInParam("@OUT_GATEWAY_ID", SqlDbType.VarChar, 20, mo.OUT_GATEWAY_ID) };
| string commandText = "Insert into sms_mo_wait (GUID,MSGID,UP_TIME,LONG_SERV_NO,SERV_CODE,MOBILE_NO,MOBILE_NO_TYPE,SMS_CONTENT,LINK_ID,OUT_GATEWAY_ID) values(@GUID,@MSGID,@UP_TIME,@LONG_SERV_NO,@SERV_CODE,@MOBILE_NO,@MOBILE_NO_TYPE,@SMS_CONTENT,@LINK_ID,@OUT_GATEWAY_ID)";
| DBHelper.ExecuteScalar(CommandType.Text, commandText, commandParameters);
| }
| }
| }
|
|
