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);
        }
    }
}