/// <summary>
/// ����һ������
/// </summary>
public int Add(Hch.iDisk.Model.FileServer model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into FileServer(");
strSql.Append("FSHost,FSDirtory,FSSize,FSValidSize,FSPass)");
strSql.Append(" values (");
strSql.Append("@FSHost,@FSDirtory,@FSSize,@FSValidSize,@FSPass)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@FSHost", SqlDbType.VarChar,100),
new SqlParameter("@FSDirtory", SqlDbType.VarChar,50),
new SqlParameter("@FSSize", SqlDbType.BigInt,8),
new SqlParameter("@FSValidSize", SqlDbType.BigInt,8),
new SqlParameter("@FSPass", SqlDbType.VarChar,130)};
parameters[0].Value = model.FSHost;
parameters[1].Value = model.FSDirtory;
parameters[2].Value = model.FSSize;
parameters[3].Value = model.FSValidSize;
parameters[4].Value = model.FSPass;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(Hch.iDisk.Model.User model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into [User](");
strSql.Append("ULoginName,URealName,UEmail,UPassWord)");
strSql.Append(" values (");
strSql.Append("@ULoginName,@URealName,@UEmail,@UPassWord)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ULoginName", SqlDbType.VarChar,20),
new SqlParameter("@URealName", SqlDbType.VarChar,20),
new SqlParameter("@UEmail", SqlDbType.VarChar,50),
new SqlParameter("@UPassWord", SqlDbType.VarChar,128)};
parameters[0].Value = model.ULoginName;
parameters[1].Value = model.URealName;
parameters[2].Value = model.UEmail;
parameters[3].Value = model.UPassWord;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(Hch.iDisk.Model.ShareInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ShareInfo(");
strSql.Append("SSender,SReceive,SDate,SFileId)");
strSql.Append(" values (");
strSql.Append("@SSender,@SReceive,@SDate,@SFileId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@SSender", SqlDbType.Int,4),
new SqlParameter("@SReceive", SqlDbType.Int,4),
new SqlParameter("@SDate", SqlDbType.DateTime),
new SqlParameter("@SFileId", SqlDbType.Int,4)};
parameters[0].Value = model.SSender;
parameters[1].Value = model.SReceive;
parameters[2].Value = model.SDate;
parameters[3].Value = model.SFileId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public int AddTreeNode(Hch.iDisk.Model.SysNode model)
{
model.NodeID=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into S_Tree(");
strSql.Append("NodeID,Text,ParentID,Location,OrderID,comment,Url,PermissionID,ImageUrl)");
strSql.Append(" values (");
strSql.Append("@NodeID,@Text,@ParentID,@Location,@OrderID,@comment,@Url,@PermissionID,@ImageUrl)");
//
OracleParameter[] parameters = {
new OracleParameter("@NodeID", OracleType.Number,4),
new OracleParameter("@Text", OracleType.VarChar,100),
new OracleParameter("@ParentID", OracleType.Int32,4),
new OracleParameter("@Location", OracleType.VarChar,50),
new OracleParameter("@OrderID", OracleType.Int32,4),
new OracleParameter("@comment", OracleType.VarChar,50),
new OracleParameter("@Url", OracleType.VarChar,100),
new OracleParameter("@PermissionID", OracleType.Int32,4),
new OracleParameter("@ImageUrl", OracleType.VarChar,100)};
parameters[0].Value = model.NodeID;
parameters[1].Value = model.Text;
parameters[2].Value = model.ParentID;
parameters[3].Value = model.Location;
parameters[4].Value = model.OrderID;
parameters[5].Value = model.Comment;
parameters[6].Value = model.Url;
parameters[7].Value = model.PermissionID;
parameters[8].Value = model.ImageUrl;
DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
return model.NodeID;
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(Hch.iDisk.Model.Admin model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Admin(");
strSql.Append("UserId)");
strSql.Append(" values (");
strSql.Append("@UserId)");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.Int,4)};
parameters[0].Value = model.UserId;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(Hch.iDisk.Model.FileList model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into FileList(");
strSql.Append("FileId,ServerId)");
strSql.Append(" values (");
strSql.Append("@FileId,@ServerId)");
SqlParameter[] parameters = {
new SqlParameter("@FileId", SqlDbType.VarChar,130),
new SqlParameter("@ServerId", SqlDbType.Int,4)};
parameters[0].Value = model.FileId;
parameters[1].Value = model.ServerId;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(Hch.iDisk.Model.FriendV model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into FriendV(");
strSql.Append("FrOwnerId,FrFriendId,ULoginName)");
strSql.Append(" values (");
strSql.Append("@FrOwnerId,@FrFriendId,@ULoginName)");
SqlParameter[] parameters = {
new SqlParameter("@FrOwnerId", SqlDbType.Int,4),
new SqlParameter("@FrFriendId", SqlDbType.Int,4),
new SqlParameter("@ULoginName", SqlDbType.VarChar,20)};
parameters[0].Value = model.FrOwnerId;
parameters[1].Value = model.FrFriendId;
parameters[2].Value = model.ULoginName;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(Hch.iDisk.Model.Tag model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Tag(");
strSql.Append("TName,TUserId,TFileId)");
strSql.Append(" values (");
strSql.Append("@TName,@TUserId,@TFileId)");
SqlParameter[] parameters = {
new SqlParameter("@TName", SqlDbType.VarChar,20),
new SqlParameter("@TUserId", SqlDbType.Int,4),
new SqlParameter("@TFileId", SqlDbType.Int,4)};
parameters[0].Value = model.TName;
parameters[1].Value = model.TUserId;
parameters[2].Value = model.TFileId;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(Hch.iDisk.Model.FriendTemp model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into FriendTemp(");
strSql.Append("SenderId,Receiver,Confirmed,Message)");
strSql.Append(" values (");
strSql.Append("@SenderId,@Receiver,@Confirmed,@Message)");
SqlParameter[] parameters = {
new SqlParameter("@SenderId", SqlDbType.Int,4),
new SqlParameter("@Receiver", SqlDbType.Int,4),
new SqlParameter("@Confirmed", SqlDbType.Bit,1),
new SqlParameter("@Message", SqlDbType.VarChar,50)};
parameters[0].Value = model.SenderId;
parameters[1].Value = model.Receiver;
parameters[2].Value = model.Confirmed;
parameters[3].Value = model.Message;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
public JsonResult Edit(Hch model)
{
var apiResult = new APIResult();
try
{
HchBll.AddOrUpdate(model, UserContext.CurrentUser.HotelId);
}
catch (Exception ex)
{
apiResult.Ret = -1;
apiResult.Msg = ex.Message;
if (!(ex is OperationExceptionFacade))
{
LogFactory.GetLogger().Log(LogLevel.Error, ex);
}
}
return(Json(apiResult));
}
public int AddTreeNode(Hch.iDisk.Model.SysNode node)
{
node.NodeID=GetMaxId();
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into S_Tree(");
strSql.Append("NodeID,Text,ParentID,Location,OrderID,comment,Url,PermissionID,ImageUrl)");
strSql.Append(" values (");
strSql.Append("'"+node.NodeID+"',");
strSql.Append("'"+node.Text+"',");
strSql.Append(""+node.ParentID+",");
strSql.Append("'"+node.Location+"',");
strSql.Append(""+node.OrderID+",");
strSql.Append("'"+node.Comment+"',");
strSql.Append("'"+node.Url+"',");
strSql.Append(""+node.PermissionID+",");
strSql.Append("'"+node.ImageUrl+"'");
strSql.Append(")");
DbHelperSQL.ExecuteSql(strSql.ToString());
return node.NodeID;
}
/// <summary>
/// ɾ��һ������
/// </summary>
public bool Delete(Hch.iDisk.Model.FriendTempV model)
{
//�ñ���������Ϣ�����Զ�������/�����ֶ�
StringBuilder strSql=new StringBuilder();
strSql.Append("delete from FriendTempV ");
strSql.Append(" where SenderId=@SenderId and Receiver=@Receiver");
SqlParameter[] parameters = {
new SqlParameter("@SenderId", SqlDbType.Int, 4),
new SqlParameter("@Receiver", SqlDbType.Int, 4)};
parameters[0].Value = model.SenderId;
parameters[1].Value = model.Receiver;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.FileList model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update FileList set ");
#warning ϵͳ����ȱ�ٸ��µ��ֶΣ����ֹ�ȷ����˸����Ƿ���ȷ��
strSql.Append("FileId=@FileId,");
strSql.Append("ServerId=@ServerId");
strSql.Append(" where FileId=@FileId and ServerId=@ServerId ");
SqlParameter[] parameters = {
new SqlParameter("@FileId", SqlDbType.VarChar,130),
new SqlParameter("@ServerId", SqlDbType.Int,4)};
parameters[0].Value = model.FileId;
parameters[1].Value = model.ServerId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.User model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update [User] set ");
strSql.Append("ULoginName=@ULoginName,");
strSql.Append("URealName=@URealName,");
strSql.Append("UEmail=@UEmail,");
strSql.Append("UPassWord=@UPassWord");
strSql.Append(" where UId=@UId");
SqlParameter[] parameters = {
new SqlParameter("@ULoginName", SqlDbType.VarChar,20),
new SqlParameter("@URealName", SqlDbType.VarChar,20),
new SqlParameter("@UEmail", SqlDbType.VarChar,50),
new SqlParameter("@UPassWord", SqlDbType.VarChar,128),
new SqlParameter("@UId", SqlDbType.Int,4)};
parameters[0].Value = model.ULoginName;
parameters[1].Value = model.URealName;
parameters[2].Value = model.UEmail;
parameters[3].Value = model.UPassWord;
parameters[4].Value = model.UId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.ShareInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update ShareInfo set ");
strSql.Append("SSender=@SSender,");
strSql.Append("SReceive=@SReceive,");
strSql.Append("SDate=@SDate,");
strSql.Append("SFileId=@SFileId");
strSql.Append(" where SId=@SId");
SqlParameter[] parameters = {
new SqlParameter("@SSender", SqlDbType.Int,4),
new SqlParameter("@SReceive", SqlDbType.Int,4),
new SqlParameter("@SDate", SqlDbType.DateTime),
new SqlParameter("@SFileId", SqlDbType.Int,4),
new SqlParameter("@SId", SqlDbType.Int,4)};
parameters[0].Value = model.SSender;
parameters[1].Value = model.SReceive;
parameters[2].Value = model.SDate;
parameters[3].Value = model.SFileId;
parameters[4].Value = model.SId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.FriendTempV model)
{
return dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.Tag model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Tag set ");
#warning ϵͳ����ȱ�ٸ��µ��ֶΣ����ֹ�ȷ����˸����Ƿ���ȷ��
strSql.Append("TName=@TName,");
strSql.Append("TUserId=@TUserId,");
strSql.Append("TFileId=@TFileId");
strSql.Append(" where TName=@TName and TUserId=@TUserId and TFileId=@TFileId ");
SqlParameter[] parameters = {
new SqlParameter("@TName", SqlDbType.VarChar,20),
new SqlParameter("@TUserId", SqlDbType.Int,4),
new SqlParameter("@TFileId", SqlDbType.Int,4)};
parameters[0].Value = model.TName;
parameters[1].Value = model.TUserId;
parameters[2].Value = model.TFileId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(Hch.iDisk.Model.File model)
{
dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.File model)
{
return dal.Update(model);
}
public void UpdateNode(Hch.iDisk.Model.SysNode node)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update S_Tree set ");
strSql.Append("Text='"+node.Text+"',");
strSql.Append("ParentID="+node.ParentID.ToString()+",");
strSql.Append("Location='"+node.Location+"',");
strSql.Append("OrderID="+node.OrderID+",");
strSql.Append("comment='"+node.Comment+"',");
strSql.Append("Url='"+node.Url+"',");
strSql.Append("PermissionID="+node.PermissionID+",");
strSql.Append("ImageUrl='"+node.ImageUrl+"'");
strSql.Append(" where NodeID="+node.NodeID);
DbHelperSQL.ExecuteSql(strSql.ToString());
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.FriendTemp model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update FriendTemp set ");
strSql.Append("Confirmed=@Confirmed,");
strSql.Append("Message=@Message");
strSql.Append(" where SenderId=@SenderId and Receiver=@Receiver ");
SqlParameter[] parameters = {
new SqlParameter("@Confirmed", SqlDbType.Bit,1),
new SqlParameter("@Message", SqlDbType.VarChar,50),
new SqlParameter("@SenderId", SqlDbType.Int,4),
new SqlParameter("@Receiver", SqlDbType.Int,4)};
parameters[0].Value = model.Confirmed;
parameters[1].Value = model.Message;
parameters[2].Value = model.SenderId;
parameters[3].Value = model.Receiver;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ɾ��һ������
/// </summary>
public bool Delete(Hch.iDisk.Model.FriendTempV model)
{
//�ñ���������Ϣ�����Զ�������/�����ֶ�
return dal.Delete(model);
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(Hch.iDisk.Model.FriendTempV model)
{
dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.Dirtory model)
{
return dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.Admin model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Admin set ");
#warning ϵͳ����ȱ�ٸ��µ��ֶΣ����ֹ�ȷ����˸����Ƿ���ȷ��
strSql.Append("UserId=@UserId");
strSql.Append(" where UserId=@UserId ");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.Int,4)};
parameters[0].Value = model.UserId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(Hch.iDisk.Model.Dirtory model)
{
return dal.Add(model);
}
public void UpdateNode(Hch.iDisk.Model.SysNode model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update S_Tree set ");
strSql.Append("Text=@Text,");
strSql.Append("ParentID=@ParentID,");
strSql.Append("Location=@Location,");
strSql.Append("OrderID=@OrderID,");
strSql.Append("comment=@comment,");
strSql.Append("Url=@Url,");
strSql.Append("PermissionID=@PermissionID,");
strSql.Append("ImageUrl=@ImageUrl");
strSql.Append(" where NodeID=@NodeID");
OracleParameter[] parameters = {
new OracleParameter("@NodeID", OracleType.Int32,4),
new OracleParameter("@Text", OracleType.VarChar,100),
new OracleParameter("@ParentID", OracleType.Int32,4),
new OracleParameter("@Location", OracleType.VarChar,50),
new OracleParameter("@OrderID", OracleType.Int32,4),
new OracleParameter("@comment", OracleType.VarChar,50),
new OracleParameter("@Url", OracleType.VarChar,100),
new OracleParameter("@PermissionID", OracleType.Int32,4),
new OracleParameter("@ImageUrl", OracleType.VarChar,100)};
parameters[0].Value = model.NodeID;
parameters[1].Value = model.Text;
parameters[2].Value = model.ParentID;
parameters[3].Value = model.Location;
parameters[4].Value = model.OrderID;
parameters[5].Value = model.Comment;
parameters[6].Value = model.Url;
parameters[7].Value = model.PermissionID;
parameters[8].Value = model.ImageUrl;
DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.Admin model)
{
return dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(Hch.iDisk.Model.FileServer model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public void Add(Hch.iDisk.Model.Admin model)
{
dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public bool Update(Hch.iDisk.Model.FileServer model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update FileServer set ");
strSql.Append("FSHost=@FSHost,");
strSql.Append("FSDirtory=@FSDirtory,");
strSql.Append("FSSize=@FSSize,");
strSql.Append("FSValidSize=@FSValidSize,");
strSql.Append("FSPass=@FSPass");
strSql.Append(" where FSId=@FSId");
SqlParameter[] parameters = {
new SqlParameter("@FSHost", SqlDbType.VarChar,100),
new SqlParameter("@FSDirtory", SqlDbType.VarChar,50),
new SqlParameter("@FSSize", SqlDbType.BigInt,8),
new SqlParameter("@FSValidSize", SqlDbType.BigInt,8),
new SqlParameter("@FSPass", SqlDbType.VarChar,130),
new SqlParameter("@FSId", SqlDbType.Int,4)};
parameters[0].Value = model.FSHost;
parameters[1].Value = model.FSDirtory;
parameters[2].Value = model.FSSize;
parameters[3].Value = model.FSValidSize;
parameters[4].Value = model.FSPass;
parameters[5].Value = model.FSId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
