public void Insert(IDbConnection cn, YZSoft.Library.Library lib)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = cn as OracleConnection;
cmd.BindByName = true;
cmd.CommandText = "SELECT BPMSEQ_YZAPPLIBRARY.NEXTVAL FROM DUAL";
lib.LibID = System.Convert.ToInt32(cmd.ExecuteScalar());
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO YZAppLibrary(");
sb.Append("LibID,");
sb.Append("LibType,");
sb.Append("Name,");
sb.Append("\"DESC\",");
sb.Append("FolderID,");
sb.Append("DocumentFolderID,");
sb.Append("Owner,");
sb.Append("CreateAt,");
sb.Append("ImageFileID,");
sb.Append("OrderIndex,");
sb.Append("Deleted,");
sb.Append("DeleteBy,");
sb.Append("DeleteAt) ");
sb.Append("VALUES(");
sb.Append(":LibID,");
sb.Append(":LibType,");
sb.Append(":Name,");
sb.Append(":Desc1,");
sb.Append(":FolderID,");
sb.Append(":DocumentFolderID,");
sb.Append(":Owner,");
sb.Append(":CreateAt,");
sb.Append(":ImageFileID,");
sb.Append(":OrderIndex,");
sb.Append(":Deleted,");
sb.Append(":DeleteBy,");
sb.Append(":DeleteAt)");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add(":LibID", OracleDbType.Int32).Value = lib.LibID;
cmd.Parameters.Add(":LibType", OracleDbType.NVarchar2).Value = this.Convert(lib.LibType, false);
cmd.Parameters.Add(":Name", OracleDbType.NVarchar2).Value = this.Convert(lib.Name, false);
cmd.Parameters.Add(":Desc1", OracleDbType.NVarchar2).Value = this.Convert(lib.Desc, true);
cmd.Parameters.Add(":FolderID", OracleDbType.Int32).Value = this.Convert(lib.FolderID, true);
cmd.Parameters.Add(":DocumentFolderID", OracleDbType.Int32).Value = this.Convert(lib.DocumentFolderID, true);
cmd.Parameters.Add(":Owner", OracleDbType.NVarchar2).Value = this.Convert(lib.Owner, true);
cmd.Parameters.Add(":CreateAt", OracleDbType.Date).Value = this.Convert(lib.CreateAt, true);
cmd.Parameters.Add(":ImageFileID", OracleDbType.NVarchar2).Value = this.Convert(lib.ImageFileID, true);
cmd.Parameters.Add(":OrderIndex", OracleDbType.Int32).Value = this.Convert(lib.OrderIndex, false);
cmd.Parameters.Add(":Deleted", OracleDbType.Int16).Value = this.ConvertBoolToInt16(lib.Deleted);
cmd.Parameters.Add(":DeleteBy", OracleDbType.NVarchar2).Value = this.Convert(lib.DeleteBy, true);
cmd.Parameters.Add(":DeleteAt", OracleDbType.Date).Value = this.Convert(lib.DeleteAt, true);
cmd.ExecuteNonQuery();
}
}
public void Insert(IDbConnection cn, YZSoft.Library.Library lib)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn as SqlConnection;
StringBuilder sb = new StringBuilder();
sb.Append("SET NOCOUNT ON;");
sb.Append("INSERT INTO YZAppLibrary(");
sb.Append("LibType,");
sb.Append("Name,");
sb.Append("[Desc],");
sb.Append("FolderID,");
sb.Append("DocumentFolderID,");
sb.Append("Owner,");
sb.Append("CreateAt,");
sb.Append("ImageFileID,");
sb.Append("OrderIndex,");
sb.Append("Deleted,");
sb.Append("DeleteBy,");
sb.Append("DeleteAt) ");
sb.Append("VALUES(");
sb.Append("@LibType,");
sb.Append("@Name,");
sb.Append("@Desc,");
sb.Append("@FolderID,");
sb.Append("@DocumentFolderID,");
sb.Append("@Owner,");
sb.Append("@CreateAt,");
sb.Append("@ImageFileID,");
sb.Append("@OrderIndex,");
sb.Append("@Deleted,");
sb.Append("@DeleteBy,");
sb.Append("@DeleteAt);");
sb.Append("SELECT SCOPE_IDENTITY()");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add("@LibType", SqlDbType.NVarChar).Value = this.Convert(lib.LibType, false);
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = this.Convert(lib.Name, false);
cmd.Parameters.Add("@Desc", SqlDbType.NVarChar).Value = this.Convert(lib.Desc, true);
cmd.Parameters.Add("@FolderID", SqlDbType.Int).Value = this.Convert(lib.FolderID, true);
cmd.Parameters.Add("@DocumentFolderID", SqlDbType.Int).Value = this.Convert(lib.DocumentFolderID, true);
cmd.Parameters.Add("@Owner", SqlDbType.NVarChar).Value = this.Convert(lib.Owner, true);
cmd.Parameters.Add("@CreateAt", SqlDbType.DateTime).Value = this.Convert(lib.CreateAt, true);
cmd.Parameters.Add("@ImageFileID", SqlDbType.NVarChar).Value = this.Convert(lib.ImageFileID, true);
cmd.Parameters.Add("@OrderIndex", SqlDbType.Int).Value = this.Convert(lib.OrderIndex, false);
cmd.Parameters.Add("@Deleted", SqlDbType.Bit).Value = lib.Deleted;
cmd.Parameters.Add("@DeleteBy", SqlDbType.NVarChar).Value = this.Convert(lib.DeleteBy, true);
cmd.Parameters.Add("@DeleteAt", SqlDbType.DateTime).Value = this.Convert(lib.DeleteAt, true);
lib.LibID = System.Convert.ToInt32(cmd.ExecuteScalar());
}
}
public void UpdateOrderIndex(IDbConnection cn, YZSoft.Library.Library lib)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn as SqlConnection;
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE YZAppLibrary SET ");
sb.Append("OrderIndex=@OrderIndex ");
sb.Append("WHERE LibID=@LibID");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add("@OrderIndex", SqlDbType.Int).Value = this.Convert(lib.OrderIndex, true);
cmd.Parameters.Add("@LibID", SqlDbType.Int).Value = lib.LibID;
cmd.ExecuteNonQuery();
}
}
public void UpdateOrderIndex(IDbConnection cn, YZSoft.Library.Library lib)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = cn as OracleConnection;
cmd.BindByName = true;
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE YZAppLibrary SET ");
sb.Append("OrderIndex=:OrderIndex ");
sb.Append("WHERE LibID=:LibID");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add(":OrderIndex", OracleDbType.Int32).Value = this.Convert(lib.OrderIndex, true);
cmd.Parameters.Add(":LibID", OracleDbType.Int32).Value = lib.LibID;
cmd.ExecuteNonQuery();
}
}
public void Update(IDbConnection cn, YZSoft.Library.Library lib)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = cn as OracleConnection;
cmd.BindByName = true;
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE YZAppLibrary SET ");
sb.Append("LibType=:LibType,");
sb.Append("Name=:Name,");
sb.Append("\"DESC\"=:Desc1,");
sb.Append("FolderID=:FolderID,");
sb.Append("DocumentFolderID=:DocumentFolderID,");
sb.Append("Owner=:Owner,");
sb.Append("CreateAt=:CreateAt,");
sb.Append("ImageFileID=:ImageFileID,");
sb.Append("Deleted=:Deleted,");
sb.Append("DeleteBy=:DeleteBy,");
sb.Append("DeleteAt=:DeleteAt ");
sb.Append("WHERE LibID=:LibID");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add(":LibType", OracleDbType.NVarchar2).Value = this.Convert(lib.LibType, false);
cmd.Parameters.Add(":Name", OracleDbType.NVarchar2).Value = this.Convert(lib.Name, false);
cmd.Parameters.Add(":Desc1", OracleDbType.NVarchar2).Value = this.Convert(lib.Desc, true);
cmd.Parameters.Add(":FolderID", OracleDbType.Int32).Value = this.Convert(lib.FolderID, true);
cmd.Parameters.Add(":DocumentFolderID", OracleDbType.Int32).Value = this.Convert(lib.DocumentFolderID, true);
cmd.Parameters.Add(":Owner", OracleDbType.NVarchar2).Value = this.Convert(lib.Owner, true);
cmd.Parameters.Add(":CreateAt", OracleDbType.Date).Value = this.Convert(lib.CreateAt, true);
cmd.Parameters.Add(":ImageFileID", OracleDbType.NVarchar2).Value = this.Convert(lib.ImageFileID, true);
cmd.Parameters.Add(":Deleted", OracleDbType.Int16).Value = this.ConvertBoolToInt16(lib.Deleted);
cmd.Parameters.Add(":DeleteBy", OracleDbType.NVarchar2).Value = this.Convert(lib.DeleteBy, true);
cmd.Parameters.Add(":DeleteAt", OracleDbType.Date).Value = this.Convert(lib.DeleteAt, true);
cmd.Parameters.Add(":LibID", OracleDbType.Int32).Value = lib.LibID;
cmd.ExecuteNonQuery();
}
}
public void Update(IDbConnection cn, YZSoft.Library.Library lib)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn as SqlConnection;
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE YZAppLibrary SET ");
sb.Append("LibType=@LibType,");
sb.Append("Name=@Name,");
sb.Append("[Desc]=@Desc,");
sb.Append("FolderID=@FolderID,");
sb.Append("DocumentFolderID=@DocumentFolderID,");
sb.Append("Owner=@Owner,");
sb.Append("CreateAt=@CreateAt,");
sb.Append("ImageFileID=@ImageFileID,");
sb.Append("Deleted=@Deleted,");
sb.Append("DeleteBy=@DeleteBy,");
sb.Append("DeleteAt=@DeleteAt ");
sb.Append("WHERE LibID=@LibID");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add("@LibType", SqlDbType.NVarChar).Value = this.Convert(lib.LibType, false);
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = this.Convert(lib.Name, false);
cmd.Parameters.Add("@Desc", SqlDbType.NVarChar).Value = this.Convert(lib.Desc, true);
cmd.Parameters.Add("@FolderID", SqlDbType.Int).Value = this.Convert(lib.FolderID, true);
cmd.Parameters.Add("@DocumentFolderID", SqlDbType.Int).Value = this.Convert(lib.DocumentFolderID, true);
cmd.Parameters.Add("@Owner", SqlDbType.NVarChar).Value = this.Convert(lib.Owner, true);
cmd.Parameters.Add("@CreateAt", SqlDbType.DateTime).Value = this.Convert(lib.CreateAt, true);
cmd.Parameters.Add("@ImageFileID", SqlDbType.NVarChar).Value = this.Convert(lib.ImageFileID, true);
cmd.Parameters.Add("@Deleted", SqlDbType.Bit).Value = lib.Deleted;
cmd.Parameters.Add("@DeleteBy", SqlDbType.NVarChar).Value = this.Convert(lib.DeleteBy, true);
cmd.Parameters.Add("@DeleteAt", SqlDbType.DateTime).Value = this.Convert(lib.DeleteAt, true);
cmd.Parameters.Add("@LibID", SqlDbType.Int).Value = lib.LibID;
cmd.ExecuteNonQuery();
}
}
