public void Update(IDbConnection cn, YZSoft.FileSystem.Folder folder)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = cn as OracleConnection;
cmd.BindByName = true;
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE YZAPPFOLDERS SET ");
sb.Append("RootID=:RootID,");
sb.Append("ParentID=:ParentID,");
sb.Append("\"NAME\"=:Name1,");
sb.Append("\"DESC\"=:Desc1,");
sb.Append("Owner=:Owner,");
sb.Append("CreateAt=:CreateAt,");
sb.Append("Deleted=:Deleted,");
sb.Append("DeleteBy=:DeleteBy,");
sb.Append("DeleteAt=:DeleteAt ");
sb.Append("WHERE FolderID=:FolderID");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add(":RootID", OracleDbType.Int32).Value = this.Convert(folder.RootID, true);
cmd.Parameters.Add(":ParentID", OracleDbType.Int32).Value = this.Convert(folder.ParentID, true);
cmd.Parameters.Add(":Name1", OracleDbType.NVarchar2).Value = this.Convert(folder.Name, false);
cmd.Parameters.Add(":Desc1", OracleDbType.NVarchar2).Value = this.Convert(folder.Desc, true);
cmd.Parameters.Add(":Owner", OracleDbType.NVarchar2).Value = this.Convert(folder.Owner, true);
cmd.Parameters.Add(":CreateAt", OracleDbType.Date).Value = this.Convert(folder.CreateAt, false);
cmd.Parameters.Add(":Deleted", OracleDbType.Int16).Value = this.ConvertBoolToInt16(folder.Deleted);
cmd.Parameters.Add(":DeleteBy", OracleDbType.NVarchar2).Value = this.Convert(folder.DeleteBy, true);
cmd.Parameters.Add(":DeleteAt", OracleDbType.Date).Value = this.Convert(folder.DeleteAt, true);
cmd.Parameters.Add(":FolderID", OracleDbType.Int32).Value = folder.FolderID;
cmd.ExecuteNonQuery();
}
}
public void Update(IDbConnection cn, YZSoft.FileSystem.Folder folder)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn as SqlConnection;
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE YZAppFolders SET ");
sb.Append("RootID=@RootID,");
sb.Append("ParentID=@ParentID,");
sb.Append("Name=@Name,");
sb.Append("[Desc]=@Desc,");
sb.Append("Owner=@Owner,");
sb.Append("CreateAt=@CreateAt,");
sb.Append("Deleted=@Deleted,");
sb.Append("DeleteBy=@DeleteBy,");
sb.Append("DeleteAt=@DeleteAt ");
sb.Append("WHERE FolderID=@FolderID");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add("@RootID", SqlDbType.Int).Value = this.Convert(folder.RootID, true);
cmd.Parameters.Add("@ParentID", SqlDbType.Int).Value = this.Convert(folder.ParentID, true);
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = this.Convert(folder.Name, false);
cmd.Parameters.Add("@Desc", SqlDbType.NVarChar).Value = this.Convert(folder.Desc, true);
cmd.Parameters.Add("@Owner", SqlDbType.NVarChar).Value = this.Convert(folder.Owner, true);
cmd.Parameters.Add("@CreateAt", SqlDbType.DateTime).Value = this.Convert(folder.CreateAt, false);
cmd.Parameters.Add("@Deleted", SqlDbType.Bit).Value = folder.Deleted;
cmd.Parameters.Add("@DeleteBy", SqlDbType.NVarChar).Value = this.Convert(folder.DeleteBy, true);
cmd.Parameters.Add("@DeleteAt", SqlDbType.DateTime).Value = this.Convert(folder.DeleteAt, true);
cmd.Parameters.Add("@FolderID", SqlDbType.Int).Value = folder.FolderID;
cmd.ExecuteNonQuery();
}
}
public void Insert(IDbConnection cn, YZSoft.FileSystem.Folder folder)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = cn as OracleConnection;
cmd.BindByName = true;
cmd.CommandText = "SELECT BPMSEQ_YZAPPFOLDERS.NEXTVAL FROM DUAL";
folder.FolderID = System.Convert.ToInt32(cmd.ExecuteScalar());
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO YZAPPFOLDERS(");
sb.Append("FOLDERID,");
sb.Append("ROOTID,");
sb.Append("PARENTID,");
sb.Append("FOLDERTYPE,");
sb.Append("\"NAME\",");
sb.Append("\"DESC\",");
sb.Append("OWNER,");
sb.Append("CREATEAT,");
sb.Append("ORDERINDEX) ");
sb.Append("VALUES(");
sb.Append(":FOLDERID,");
sb.Append(":ROOTID,");
sb.Append(":PARENTID,");
sb.Append(":FOLDERTYPE,");
sb.Append(":NAME1,");
sb.Append(":DESC1,");
sb.Append(":OWNER,");
sb.Append(":CREATEAT,");
sb.Append(":ORDERINDEX)");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add(":FOLDERID", OracleDbType.Int32).Value = folder.FolderID;
cmd.Parameters.Add(":ROOTID", OracleDbType.Int32).Value = this.Convert(folder.RootID, true);
cmd.Parameters.Add(":PARENTID", OracleDbType.Int32).Value = this.Convert(folder.ParentID, true);
cmd.Parameters.Add(":FOLDERTYPE", OracleDbType.NVarchar2).Value = this.Convert(folder.FolderType, true);
cmd.Parameters.Add(":NAME1", OracleDbType.NVarchar2).Value = this.Convert(folder.Name, false);
cmd.Parameters.Add(":DESC1", OracleDbType.NVarchar2).Value = this.Convert(folder.Desc, true);
cmd.Parameters.Add(":OWNER", OracleDbType.NVarchar2).Value = this.Convert(folder.Owner, true);
cmd.Parameters.Add(":CREATEAT", OracleDbType.Date).Value = this.Convert(folder.CreateAt, false);
cmd.Parameters.Add(":ORDERINDEX", OracleDbType.Int32).Value = this.Convert(folder.OrderIndex, true);
cmd.ExecuteNonQuery();
}
}
public void UpdateOrderIndex(IDbConnection cn, YZSoft.FileSystem.Folder folder)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn as SqlConnection;
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE YZAppFolders SET ");
sb.Append("OrderIndex=@OrderIndex ");
sb.Append("WHERE FolderID=@FolderID");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add("@OrderIndex", SqlDbType.Int).Value = this.Convert(folder.OrderIndex, true);
cmd.Parameters.Add("@FolderID", SqlDbType.Int).Value = folder.FolderID;
cmd.ExecuteNonQuery();
}
}
public void UpdateOrderIndex(IDbConnection cn, YZSoft.FileSystem.Folder folder)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = cn as OracleConnection;
cmd.BindByName = true;
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE YZAppFolders SET ");
sb.Append("OrderIndex=:OrderIndex ");
sb.Append("WHERE FolderID=:FolderID");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add(":OrderIndex", OracleDbType.Int32).Value = this.Convert(folder.OrderIndex, true);
cmd.Parameters.Add(":FolderID", OracleDbType.Int32).Value = folder.FolderID;
cmd.ExecuteNonQuery();
}
}
public void Insert(IDbConnection cn, YZSoft.FileSystem.Folder folder)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn as SqlConnection;
StringBuilder sb = new StringBuilder();
sb.Append("SET NOCOUNT ON;");
sb.Append("INSERT INTO YZAppFolders(");
sb.Append("RootID,");
sb.Append("ParentID,");
sb.Append("FolderType,");
sb.Append("Name,");
sb.Append("[Desc],");
sb.Append("Owner,");
sb.Append("CreateAt,");
sb.Append("OrderIndex) ");
sb.Append("VALUES(");
sb.Append("@RootID,");
sb.Append("@ParentID,");
sb.Append("@FolderType,");
sb.Append("@Name,");
sb.Append("@Desc,");
sb.Append("@Owner,");
sb.Append("@CreateAt,");
sb.Append("@OrderIndex);");
sb.Append("SELECT SCOPE_IDENTITY()");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add("@RootID", SqlDbType.Int).Value = this.Convert(folder.RootID, true);
cmd.Parameters.Add("@ParentID", SqlDbType.Int).Value = this.Convert(folder.ParentID, true);
cmd.Parameters.Add("@FolderType", SqlDbType.NVarChar).Value = this.Convert(folder.FolderType, true);
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = this.Convert(folder.Name, false);
cmd.Parameters.Add("@Desc", SqlDbType.NVarChar).Value = this.Convert(folder.Desc, true);
cmd.Parameters.Add("@Owner", SqlDbType.NVarChar).Value = this.Convert(folder.Owner, true);
cmd.Parameters.Add("@CreateAt", SqlDbType.DateTime).Value = this.Convert(folder.CreateAt, false);
cmd.Parameters.Add("@OrderIndex", SqlDbType.Int).Value = this.Convert(folder.OrderIndex, true);
folder.FolderID = System.Convert.ToInt32(cmd.ExecuteScalar());
}
}
