private List <RoadFlow.Data.Model.SMSLog> DataReaderToList(MySqlDataReader dataReader)
{
List <RoadFlow.Data.Model.SMSLog> list = new List <RoadFlow.Data.Model.SMSLog>();
RoadFlow.Data.Model.SMSLog sMSLog = null;
while (((DbDataReader)dataReader).Read())
{
sMSLog = new RoadFlow.Data.Model.SMSLog();
sMSLog.ID = ((DbDataReader)dataReader).GetString(0).ToGuid();
sMSLog.MobileNumber = ((DbDataReader)dataReader).GetString(1);
sMSLog.Contents = ((DbDataReader)dataReader).GetString(2);
if (!((DbDataReader)dataReader).IsDBNull(3))
{
sMSLog.SendUserID = ((DbDataReader)dataReader).GetString(3).ToGuid();
}
if (!((DbDataReader)dataReader).IsDBNull(4))
{
sMSLog.SendUserName = ((DbDataReader)dataReader).GetString(4);
}
sMSLog.SendTime = ((DbDataReader)dataReader).GetDateTime(5);
sMSLog.Status = ((DbDataReader)dataReader).GetInt32(6);
if (!((DbDataReader)dataReader).IsDBNull(7))
{
sMSLog.Note = ((DbDataReader)dataReader).GetString(7);
}
list.Add(sMSLog);
}
return(list);
}
public int Update(RoadFlow.Data.Model.SMSLog model)
{
string sql = "UPDATE SMSLog SET \r\n\t\t\t\tMobileNumber=@MobileNumber,Contents=@Contents,SendUserID=@SendUserID,SendUserName=@SendUserName,SendTime=@SendTime,Status=@Status,Note=@Note\r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] parameter = new SqlParameter[8]
{
new SqlParameter("@MobileNumber", SqlDbType.VarChar, -1)
{
Value = model.MobileNumber
},
new SqlParameter("@Contents", SqlDbType.NVarChar, 400)
{
Value = model.Contents
},
(!model.SendUserID.HasValue) ? new SqlParameter("@SendUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@SendUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.SendUserID
},
(model.SendUserName == null) ? new SqlParameter("@SendUserName", SqlDbType.NVarChar, 1000)
{
Value = DBNull.Value
} : new SqlParameter("@SendUserName", SqlDbType.NVarChar, 1000)
{
Value = model.SendUserName
},
new SqlParameter("@SendTime", SqlDbType.DateTime, 8)
{
Value = model.SendTime
},
new SqlParameter("@Status", SqlDbType.Int, -1)
{
Value = model.Status
},
(model.Note == null) ? new SqlParameter("@Note", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.VarChar, -1)
{
Value = model.Note
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.SMSLog model)
{
string sql = "INSERT INTO SMSLog\r\n\t\t\t\t(ID,MobileNumber,Contents,SendUserID,SendUserName,SendTime,Status,Note) \r\n\t\t\t\tVALUES(@ID,@MobileNumber,@Contents,@SendUserID,@SendUserName,@SendTime,@Status,@Note)";
SqlParameter[] parameter = new SqlParameter[8]
{
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@MobileNumber", SqlDbType.VarChar, -1)
{
Value = model.MobileNumber
},
new SqlParameter("@Contents", SqlDbType.NVarChar, 400)
{
Value = model.Contents
},
(!model.SendUserID.HasValue) ? new SqlParameter("@SendUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@SendUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.SendUserID
},
(model.SendUserName == null) ? new SqlParameter("@SendUserName", SqlDbType.NVarChar, 1000)
{
Value = DBNull.Value
} : new SqlParameter("@SendUserName", SqlDbType.NVarChar, 1000)
{
Value = model.SendUserName
},
new SqlParameter("@SendTime", SqlDbType.DateTime, 8)
{
Value = model.SendTime
},
new SqlParameter("@Status", SqlDbType.Int, -1)
{
Value = model.Status
},
(model.Note == null) ? new SqlParameter("@Note", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.VarChar, -1)
{
Value = model.Note
}
};
return(dbHelper.Execute(sql, parameter));
}
public static void AddSync(RoadFlow.Data.Model.SMSLog model)
{
new dgWriteLog(add).BeginInvoke(model, null, null);
}
private static void add(RoadFlow.Data.Model.SMSLog model)
{
dataSMSLog.Add(model);
}
public int Update(RoadFlow.Data.Model.SMSLog model)
{
return(dataSMSLog.Update(model));
}
public int Add(RoadFlow.Data.Model.SMSLog model)
{
return(dataSMSLog.Add(model));
}
public int Add(RoadFlow.Data.Model.SMSLog model)
{
//IL_001a: Unknown result type (might be due to invalid IL or missing references)
//IL_001f: Unknown result type (might be due to invalid IL or missing references)
//IL_0030: Expected O, but got Unknown
//IL_0031: Expected O, but got Unknown
//IL_003e: Unknown result type (might be due to invalid IL or missing references)
//IL_0043: Unknown result type (might be due to invalid IL or missing references)
//IL_004f: Expected O, but got Unknown
//IL_0050: Expected O, but got Unknown
//IL_0061: Unknown result type (might be due to invalid IL or missing references)
//IL_0066: Unknown result type (might be due to invalid IL or missing references)
//IL_0072: Expected O, but got Unknown
//IL_0073: Expected O, but got Unknown
//IL_0091: Unknown result type (might be due to invalid IL or missing references)
//IL_0096: Unknown result type (might be due to invalid IL or missing references)
//IL_00a7: Expected O, but got Unknown
//IL_00b5: Unknown result type (might be due to invalid IL or missing references)
//IL_00ba: Unknown result type (might be due to invalid IL or missing references)
//IL_00c5: Expected O, but got Unknown
//IL_00c6: Expected O, but got Unknown
//IL_00db: Unknown result type (might be due to invalid IL or missing references)
//IL_00e0: Unknown result type (might be due to invalid IL or missing references)
//IL_00ec: Expected O, but got Unknown
//IL_00f9: Unknown result type (might be due to invalid IL or missing references)
//IL_00fe: Unknown result type (might be due to invalid IL or missing references)
//IL_0109: Expected O, but got Unknown
//IL_010a: Expected O, but got Unknown
//IL_0114: Unknown result type (might be due to invalid IL or missing references)
//IL_0119: Unknown result type (might be due to invalid IL or missing references)
//IL_012a: Expected O, but got Unknown
//IL_012b: Expected O, but got Unknown
//IL_0135: Unknown result type (might be due to invalid IL or missing references)
//IL_013a: Unknown result type (might be due to invalid IL or missing references)
//IL_014b: Expected O, but got Unknown
//IL_014c: Expected O, but got Unknown
//IL_0161: Unknown result type (might be due to invalid IL or missing references)
//IL_0166: Unknown result type (might be due to invalid IL or missing references)
//IL_0172: Expected O, but got Unknown
//IL_017f: Unknown result type (might be due to invalid IL or missing references)
//IL_0184: Unknown result type (might be due to invalid IL or missing references)
//IL_018f: Expected O, but got Unknown
//IL_0190: Expected O, but got Unknown
string sql = "INSERT INTO smslog\r\n\t\t\t\t(ID,MobileNumber,Contents,SendUserID,SendUserName,SendTime,Status,Note) \r\n\t\t\t\tVALUES(@ID,@MobileNumber,@Contents,@SendUserID,@SendUserName,@SendTime,@Status,@Note)";
MySqlParameter[] obj = new MySqlParameter[8];
MySqlParameter val = new MySqlParameter("@ID", 253, 36);
((DbParameter)val).Value = model.ID;
obj[0] = val;
MySqlParameter val2 = new MySqlParameter("@MobileNumber", 751, -1);
((DbParameter)val2).Value = model.MobileNumber;
obj[1] = val2;
MySqlParameter val3 = new MySqlParameter("@Contents", 253, 200);
((DbParameter)val3).Value = model.Contents;
obj[2] = val3;
_003F val4;
if (model.SendUserID.HasValue)
{
val4 = new MySqlParameter("@SendUserID", 253, 36);
((DbParameter)val4).Value = model.SendUserID;
}
else
{
val4 = new MySqlParameter("@SendUserID", 253, 36);
((DbParameter)val4).Value = DBNull.Value;
}
obj[3] = val4;
_003F val5;
if (model.SendUserName != null)
{
val5 = new MySqlParameter("@SendUserName", 752, -1);
((DbParameter)val5).Value = model.SendUserName;
}
else
{
val5 = new MySqlParameter("@SendUserName", 752, -1);
((DbParameter)val5).Value = DBNull.Value;
}
obj[4] = val5;
MySqlParameter val6 = new MySqlParameter("@SendTime", 12, -1);
((DbParameter)val6).Value = model.SendTime;
obj[5] = val6;
MySqlParameter val7 = new MySqlParameter("@Status", 3, 11);
((DbParameter)val7).Value = model.Status;
obj[6] = val7;
_003F val8;
if (model.Note != null)
{
val8 = new MySqlParameter("@Note", 751, -1);
((DbParameter)val8).Value = model.Note;
}
else
{
val8 = new MySqlParameter("@Note", 751, -1);
((DbParameter)val8).Value = DBNull.Value;
}
obj[7] = val8;
MySqlParameter[] parameter = (MySqlParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.SMSLog model)
{
//IL_0019: Unknown result type (might be due to invalid IL or missing references)
//IL_001e: Unknown result type (might be due to invalid IL or missing references)
//IL_002a: Expected O, but got Unknown
//IL_002b: Expected O, but got Unknown
//IL_003c: Unknown result type (might be due to invalid IL or missing references)
//IL_0041: Unknown result type (might be due to invalid IL or missing references)
//IL_004d: Expected O, but got Unknown
//IL_004e: Expected O, but got Unknown
//IL_006c: Unknown result type (might be due to invalid IL or missing references)
//IL_0071: Unknown result type (might be due to invalid IL or missing references)
//IL_0082: Expected O, but got Unknown
//IL_0090: Unknown result type (might be due to invalid IL or missing references)
//IL_0095: Unknown result type (might be due to invalid IL or missing references)
//IL_00a0: Expected O, but got Unknown
//IL_00a1: Expected O, but got Unknown
//IL_00b6: Unknown result type (might be due to invalid IL or missing references)
//IL_00bb: Unknown result type (might be due to invalid IL or missing references)
//IL_00c7: Expected O, but got Unknown
//IL_00d4: Unknown result type (might be due to invalid IL or missing references)
//IL_00d9: Unknown result type (might be due to invalid IL or missing references)
//IL_00e4: Expected O, but got Unknown
//IL_00e5: Expected O, but got Unknown
//IL_00ef: Unknown result type (might be due to invalid IL or missing references)
//IL_00f4: Unknown result type (might be due to invalid IL or missing references)
//IL_0105: Expected O, but got Unknown
//IL_0106: Expected O, but got Unknown
//IL_0110: Unknown result type (might be due to invalid IL or missing references)
//IL_0115: Unknown result type (might be due to invalid IL or missing references)
//IL_0126: Expected O, but got Unknown
//IL_0127: Expected O, but got Unknown
//IL_013c: Unknown result type (might be due to invalid IL or missing references)
//IL_0141: Unknown result type (might be due to invalid IL or missing references)
//IL_014d: Expected O, but got Unknown
//IL_015a: Unknown result type (might be due to invalid IL or missing references)
//IL_015f: Unknown result type (might be due to invalid IL or missing references)
//IL_016a: Expected O, but got Unknown
//IL_016b: Expected O, but got Unknown
//IL_0179: Unknown result type (might be due to invalid IL or missing references)
//IL_017e: Unknown result type (might be due to invalid IL or missing references)
//IL_018f: Expected O, but got Unknown
//IL_0190: Expected O, but got Unknown
string sql = "UPDATE smslog SET \r\n\t\t\t\tMobileNumber=@MobileNumber,Contents=@Contents,SendUserID=@SendUserID,SendUserName=@SendUserName,SendTime=@SendTime,Status=@Status,Note=@Note\r\n\t\t\t\tWHERE ID=@ID";
MySqlParameter[] obj = new MySqlParameter[8];
MySqlParameter val = new MySqlParameter("@MobileNumber", 751, -1);
((DbParameter)val).Value = model.MobileNumber;
obj[0] = val;
MySqlParameter val2 = new MySqlParameter("@Contents", 253, 200);
((DbParameter)val2).Value = model.Contents;
obj[1] = val2;
_003F val3;
if (model.SendUserID.HasValue)
{
val3 = new MySqlParameter("@SendUserID", 253, 36);
((DbParameter)val3).Value = model.SendUserID;
}
else
{
val3 = new MySqlParameter("@SendUserID", 253, 36);
((DbParameter)val3).Value = DBNull.Value;
}
obj[2] = val3;
_003F val4;
if (model.SendUserName != null)
{
val4 = new MySqlParameter("@SendUserName", 752, -1);
((DbParameter)val4).Value = model.SendUserName;
}
else
{
val4 = new MySqlParameter("@SendUserName", 752, -1);
((DbParameter)val4).Value = DBNull.Value;
}
obj[3] = val4;
MySqlParameter val5 = new MySqlParameter("@SendTime", 12, -1);
((DbParameter)val5).Value = model.SendTime;
obj[4] = val5;
MySqlParameter val6 = new MySqlParameter("@Status", 3, 11);
((DbParameter)val6).Value = model.Status;
obj[5] = val6;
_003F val7;
if (model.Note != null)
{
val7 = new MySqlParameter("@Note", 751, -1);
((DbParameter)val7).Value = model.Note;
}
else
{
val7 = new MySqlParameter("@Note", 751, -1);
((DbParameter)val7).Value = DBNull.Value;
}
obj[6] = val7;
MySqlParameter val8 = new MySqlParameter("@ID", 253, 36);
((DbParameter)val8).Value = model.ID;
obj[7] = val8;
MySqlParameter[] parameter = (MySqlParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.SMSLog model)
{
//IL_0015: Unknown result type (might be due to invalid IL or missing references)
//IL_001a: Unknown result type (might be due to invalid IL or missing references)
//IL_002b: Expected O, but got Unknown
//IL_002c: Expected O, but got Unknown
//IL_0035: Unknown result type (might be due to invalid IL or missing references)
//IL_003a: Unknown result type (might be due to invalid IL or missing references)
//IL_0046: Expected O, but got Unknown
//IL_0047: Expected O, but got Unknown
//IL_0050: Unknown result type (might be due to invalid IL or missing references)
//IL_0055: Unknown result type (might be due to invalid IL or missing references)
//IL_0061: Expected O, but got Unknown
//IL_0062: Expected O, but got Unknown
//IL_007b: Unknown result type (might be due to invalid IL or missing references)
//IL_0080: Unknown result type (might be due to invalid IL or missing references)
//IL_0091: Expected O, but got Unknown
//IL_009a: Unknown result type (might be due to invalid IL or missing references)
//IL_009f: Unknown result type (might be due to invalid IL or missing references)
//IL_00aa: Expected O, but got Unknown
//IL_00ab: Expected O, but got Unknown
//IL_00bc: Unknown result type (might be due to invalid IL or missing references)
//IL_00c1: Unknown result type (might be due to invalid IL or missing references)
//IL_00cd: Expected O, but got Unknown
//IL_00db: Unknown result type (might be due to invalid IL or missing references)
//IL_00e0: Unknown result type (might be due to invalid IL or missing references)
//IL_00eb: Expected O, but got Unknown
//IL_00ec: Expected O, but got Unknown
//IL_00f5: Unknown result type (might be due to invalid IL or missing references)
//IL_00fa: Unknown result type (might be due to invalid IL or missing references)
//IL_010b: Expected O, but got Unknown
//IL_010c: Expected O, but got Unknown
//IL_0115: Unknown result type (might be due to invalid IL or missing references)
//IL_011a: Unknown result type (might be due to invalid IL or missing references)
//IL_012b: Expected O, but got Unknown
//IL_012c: Expected O, but got Unknown
//IL_0135: Unknown result type (might be due to invalid IL or missing references)
//IL_013a: Unknown result type (might be due to invalid IL or missing references)
//IL_0146: Expected O, but got Unknown
//IL_0147: Expected O, but got Unknown
string sql = "INSERT INTO SMSLog\r\n\t\t\t\t(ID,MobileNumber,Contents,SendUserID,SendUserName,SendTime,Status,Note) \r\n\t\t\t\tVALUES(:ID,:MobileNumber,:Contents,:SendUserID,:SendUserName,:SendTime,:Status,:Note)";
OracleParameter[] obj = new OracleParameter[8];
OracleParameter val = new OracleParameter(":ID", 126);
((DbParameter)val).Value = model.ID;
obj[0] = val;
OracleParameter val2 = new OracleParameter(":MobileNumber", 126);
((DbParameter)val2).Value = model.MobileNumber;
obj[1] = val2;
OracleParameter val3 = new OracleParameter(":Contents", 119);
((DbParameter)val3).Value = model.Contents;
obj[2] = val3;
_003F val4;
if (model.SendUserID.HasValue)
{
val4 = new OracleParameter(":SendUserID", 126);
((DbParameter)val4).Value = model.SendUserID;
}
else
{
val4 = new OracleParameter(":SendUserID", 126);
((DbParameter)val4).Value = DBNull.Value;
}
obj[3] = val4;
_003F val5;
if (model.SendUserName != null)
{
val5 = new OracleParameter(":SendUserName", 119);
((DbParameter)val5).Value = model.SendUserName;
}
else
{
val5 = new OracleParameter(":SendUserName", 119, 1000);
((DbParameter)val5).Value = DBNull.Value;
}
obj[4] = val5;
OracleParameter val6 = new OracleParameter(":SendTime", 106);
((DbParameter)val6).Value = model.SendTime;
obj[5] = val6;
OracleParameter val7 = new OracleParameter(":Status", 112);
((DbParameter)val7).Value = model.Status;
obj[6] = val7;
OracleParameter val8 = new OracleParameter(":Note", 126);
((DbParameter)val8).Value = model.Note;
obj[7] = val8;
OracleParameter[] parameter = (OracleParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.SMSLog model)
{
//IL_0015: Unknown result type (might be due to invalid IL or missing references)
//IL_001a: Unknown result type (might be due to invalid IL or missing references)
//IL_0026: Expected O, but got Unknown
//IL_0027: Expected O, but got Unknown
//IL_0030: Unknown result type (might be due to invalid IL or missing references)
//IL_0035: Unknown result type (might be due to invalid IL or missing references)
//IL_0041: Expected O, but got Unknown
//IL_0042: Expected O, but got Unknown
//IL_005b: Unknown result type (might be due to invalid IL or missing references)
//IL_0060: Unknown result type (might be due to invalid IL or missing references)
//IL_0071: Expected O, but got Unknown
//IL_007a: Unknown result type (might be due to invalid IL or missing references)
//IL_007f: Unknown result type (might be due to invalid IL or missing references)
//IL_008a: Expected O, but got Unknown
//IL_008b: Expected O, but got Unknown
//IL_009c: Unknown result type (might be due to invalid IL or missing references)
//IL_00a1: Unknown result type (might be due to invalid IL or missing references)
//IL_00ad: Expected O, but got Unknown
//IL_00b6: Unknown result type (might be due to invalid IL or missing references)
//IL_00bb: Unknown result type (might be due to invalid IL or missing references)
//IL_00c6: Expected O, but got Unknown
//IL_00c7: Expected O, but got Unknown
//IL_00d0: Unknown result type (might be due to invalid IL or missing references)
//IL_00d5: Unknown result type (might be due to invalid IL or missing references)
//IL_00e6: Expected O, but got Unknown
//IL_00e7: Expected O, but got Unknown
//IL_00f0: Unknown result type (might be due to invalid IL or missing references)
//IL_00f5: Unknown result type (might be due to invalid IL or missing references)
//IL_0106: Expected O, but got Unknown
//IL_0107: Expected O, but got Unknown
//IL_0110: Unknown result type (might be due to invalid IL or missing references)
//IL_0115: Unknown result type (might be due to invalid IL or missing references)
//IL_0121: Expected O, but got Unknown
//IL_0122: Expected O, but got Unknown
//IL_012b: Unknown result type (might be due to invalid IL or missing references)
//IL_0130: Unknown result type (might be due to invalid IL or missing references)
//IL_0141: Expected O, but got Unknown
//IL_0142: Expected O, but got Unknown
string sql = "UPDATE SMSLog SET \r\n\t\t\t\tMobileNumber=:MobileNumber,Contents=:Contents,SendUserID=:SendUserID,SendUserName=:SendUserName,SendTime=:SendTime,Status=:Status,Note=:Note\r\n\t\t\t\tWHERE ID=:ID";
OracleParameter[] obj = new OracleParameter[8];
OracleParameter val = new OracleParameter(":MobileNumber", 126);
((DbParameter)val).Value = model.MobileNumber;
obj[0] = val;
OracleParameter val2 = new OracleParameter(":Contents", 119);
((DbParameter)val2).Value = model.Contents;
obj[1] = val2;
_003F val3;
if (model.SendUserID.HasValue)
{
val3 = new OracleParameter(":SendUserID", 126);
((DbParameter)val3).Value = model.SendUserID;
}
else
{
val3 = new OracleParameter(":SendUserID", 126);
((DbParameter)val3).Value = DBNull.Value;
}
obj[2] = val3;
_003F val4;
if (model.SendUserName != null)
{
val4 = new OracleParameter(":SendUserName", 119);
((DbParameter)val4).Value = model.SendUserName;
}
else
{
val4 = new OracleParameter(":SendUserName", 119);
((DbParameter)val4).Value = DBNull.Value;
}
obj[3] = val4;
OracleParameter val5 = new OracleParameter(":SendTime", 106);
((DbParameter)val5).Value = model.SendTime;
obj[4] = val5;
OracleParameter val6 = new OracleParameter(":Status", 112);
((DbParameter)val6).Value = model.Status;
obj[5] = val6;
OracleParameter val7 = new OracleParameter(":Note", 126);
((DbParameter)val7).Value = model.Note;
obj[6] = val7;
OracleParameter val8 = new OracleParameter(":ID", 126);
((DbParameter)val8).Value = model.ID;
obj[7] = val8;
OracleParameter[] parameter = (OracleParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
