OracleConnection Con = new System.Data.OracleClient.OracleConnection(connectStr);
try
{
decimal
MsgId = 20;
string InsertSql = @
"insert into MSG
(ID, TITLE, CONTENT, SORT, TIME, AUTHOR, GROUP)
values
(:ID,
:TITLE,
:CONTENT,
:SORT,
:TIME,
:AUTHOR,
:GROUP)"
;
Con.
Open
();
OracleCommand cmd = new OracleCommand(InsertSql, Con);
OracleParameter TITLE = new OracleParameter(
"TITLE"
, OracleType.NVarChar);
OracleParameter CONTENT = new OracleParameter(
"CONTENT"
, OracleType.Clob);
OracleParameter GID = new OracleParameter(
"GID"
, OracleType.NVarChar);
OracleParameter SORT = new OracleParameter(
"SORT"
, OracleType.Number);
OracleParameter
TIME
= new OracleParameter(
"TIME"
, OracleType.DateTime);
OracleParameter AUTHOR = new OracleParameter(
"AUTHOR"
, OracleType.NVarChar);
OracleParameter
GROUP
= new OracleParameter(
"GROUP"
, OracleType.NVarChar);
TITLE.Value = Model.MsgTitle;
CONTENT.Value = Model.MsgContent;
ID.Value = Guid.NewGuid().ToString();
SORT.Value = MsgId;
TIME
.Value = DateTime.Now;
AUTHOR.Value = Model.MsgAuthor;
GROUP
.Value = Model.GroupId;
cmd.Parameters.
Add
(MSGTITLE);
cmd.Parameters.
Add
(MSGCONTENT);
cmd.Parameters.
Add
(MSGID);
cmd.Parameters.
Add
(MSGSORT);
cmd.Parameters.
Add
(MSGTIME);
cmd.Parameters.
Add
(MSGAUTHOR);
cmd.Parameters.
Add
(MGSGROUP);
cmd.ExecuteNonQuery();
Con.
Close
();
}
catch (Exception ex)
{
}