public void Insert(IDbConnection cn, YZSoft.P2PGroup.P2PGroup group)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = cn as OracleConnection;
cmd.BindByName = true;
cmd.CommandText = "SELECT BPMSEQ_YZAPPP2PGROUP.NEXTVAL FROM DUAL";
group.GroupID = System.Convert.ToInt32(cmd.ExecuteScalar());
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO YZAppP2PGroup(");
sb.Append("GroupID,");
sb.Append("Account1,");
sb.Append("Account2,");
sb.Append("UserName1,");
sb.Append("UserName2,");
sb.Append("FolderID,");
sb.Append("CreateBy,");
sb.Append("CreateAt) ");
sb.Append("VALUES(");
sb.Append(":GroupID,");
sb.Append(":Account1,");
sb.Append(":Account2,");
sb.Append(":UserName1,");
sb.Append(":UserName2,");
sb.Append(":FolderID,");
sb.Append(":CreateBy,");
sb.Append(":CreateAt)");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add(":GroupID", OracleDbType.Int32).Value = group.GroupID;
cmd.Parameters.Add(":Account1", OracleDbType.NVarchar2).Value = this.Convert(group.Account1, false);
cmd.Parameters.Add(":Account2", OracleDbType.NVarchar2).Value = this.Convert(group.Account2, false);
cmd.Parameters.Add(":UserName1", OracleDbType.NVarchar2).Value = this.Convert(group.UserName1, false);
cmd.Parameters.Add(":UserName2", OracleDbType.NVarchar2).Value = this.Convert(group.UserName2, false);
cmd.Parameters.Add(":FolderID", OracleDbType.Int32).Value = this.Convert(group.FolderID, true);
cmd.Parameters.Add(":CreateBy", OracleDbType.NVarchar2).Value = this.Convert(group.CreateBy, false);
cmd.Parameters.Add(":CreateAt", OracleDbType.Date).Value = this.Convert(group.CreateAt, false);
cmd.ExecuteNonQuery();
}
}
public void Insert(IDbConnection cn, YZSoft.P2PGroup.P2PGroup group)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn as SqlConnection;
StringBuilder sb = new StringBuilder();
sb.Append("SET NOCOUNT ON;");
sb.Append("INSERT INTO YZAppP2PGroup(");
sb.Append("Account1,");
sb.Append("Account2,");
sb.Append("UserName1,");
sb.Append("UserName2,");
sb.Append("FolderID,");
sb.Append("CreateBy,");
sb.Append("CreateAt) ");
sb.Append("VALUES(");
sb.Append("@Account1,");
sb.Append("@Account2,");
sb.Append("@UserName1,");
sb.Append("@UserName2,");
sb.Append("@FolderID,");
sb.Append("@CreateBy,");
sb.Append("@CreateAt);");
sb.Append("SELECT SCOPE_IDENTITY()");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add("@Account1", SqlDbType.NVarChar).Value = this.Convert(group.Account1, false);
cmd.Parameters.Add("@Account2", SqlDbType.NVarChar).Value = this.Convert(group.Account2, false);
cmd.Parameters.Add("@UserName1", SqlDbType.NVarChar).Value = this.Convert(group.UserName1, false);
cmd.Parameters.Add("@UserName2", SqlDbType.NVarChar).Value = this.Convert(group.UserName2, false);
cmd.Parameters.Add("@FolderID", SqlDbType.Int).Value = this.Convert(group.FolderID, false);
cmd.Parameters.Add("@CreateBy", SqlDbType.NVarChar).Value = this.Convert(group.CreateBy, false);
cmd.Parameters.Add("@CreateAt", SqlDbType.DateTime).Value = this.Convert(group.CreateAt, false);
group.GroupID = System.Convert.ToInt32(cmd.ExecuteScalar());
}
}
