public string UpdateAliasName()
{
AliasNameManager manager = new AliasNameManager();
AliasNameModel model = new AliasNameModel();
model.BOId = Request["BOID"];
model.Name = Request["NAME"];
model.AppDomain = Request["APPDOMAIN"];
model.CreatUser = Request["CREATUSER"];
model.UploadDate = System.DateTime.Parse(Request["UPLOADDATE"]);
if (manager.Exist(model))
{
return("NO");
}
else
{
try
{
manager.Update(model);
return("OK");
}
catch
{
return("false");
}
}
}
public string AddAliasName()
{
AliasNameManager manager = new AliasNameManager();
AliasNameModel model = new AliasNameModel();
model.BOId = Request["BOID"];
model.Name = Request["NAME"];
model.AppDomain = Request["APPDOMAIN"];
if (manager.Exist(model))
{
return("NO");
}
else
{
try
{
manager.Add(model);
return("OK");
}
catch
{
return("false");
}
}
}
/// <summary>
/// 判断别名是否存在
/// </summary>
/// <param name="Name"></param>
/// <returns></returns>
public bool Exist(AliasNameModel aliasName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ALIASNAME T ");
strSql.Append(" WHERE BOID=@BOID AND APPDOMAIN=@APPDOMAIN AND NAME=@NAME ");
SqlParameter[] parameters = { new SqlParameter("@BOID", SqlDbType.VarChar, 36),
new SqlParameter("@APPDOMAIN", SqlDbType.VarChar, 50),
new SqlParameter("@NAME", SqlDbType.VarChar, 50) };
parameters[0].Value = aliasName.BOId;
parameters[1].Value = aliasName.AppDomain;
parameters[2].Value = aliasName.Name;
return(DBUtility.SqlServerDBHelper.ExecuteQueryText <AliasNameModel>(strSql.ToString(), parameters).Count() >= 1 ? true : false);
}
/// <summary>
/// 判断别名是否存在
/// </summary>
/// <param name="Name"></param>
/// <returns></returns>
public bool Exist(AliasNameModel aliasName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ALIASNAME T ");
strSql.Append(" WHERE BOID=:BOID AND APPDOMAIN=:APPDOMAIN AND NAME=:NAME ");
OracleParameter[] parameters = { new OracleParameter("BOID", OracleDbType.Varchar2, 36),
new OracleParameter("APPDOMAIN", OracleDbType.Varchar2, 50),
new OracleParameter("NAME", OracleDbType.Varchar2, 50) };
parameters[0].Value = aliasName.BOId;
parameters[1].Value = aliasName.AppDomain;
parameters[2].Value = aliasName.Name;
return(DBUtility.OracleDBHelper.OracleHelper.ExecuteQueryText <AliasNameModel>(strSql.ToString(), parameters).Count() >= 1 ? true : false);
}
/// <summary>
/// 删除别名
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Delete(AliasNameModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" DELETE FROM ALIASNAME ");
strSql.Append(" WHERE BOID=@BOID AND APPDOMAIN=@APPDOMAIN");
SqlParameter[] parameters =
{
new SqlParameter("@BOID", SqlDbType.VarChar, 36),
new SqlParameter("@APPDOMAIN", SqlDbType.VarChar, 136)
};
parameters[0].Value = model.BOId;
parameters[1].Value = model.AppDomain;
return(DBUtility.SqlServerDBHelper.ExecuteSql(strSql.ToString(), parameters));
}
/// <summary>
/// 删除别名
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Delete(AliasNameModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" DELETE FROM ALIASNAME ");
strSql.Append(" WHERE BOID=:BOID AND APPDOMAIN=:APPDOMAIN");
OracleParameter[] parameters =
{
new OracleParameter("BOID", OracleDbType.Varchar2, 36),
new OracleParameter("APPDOMAIN", OracleDbType.Varchar2, 136)
};
parameters[0].Value = model.BOId;
parameters[1].Value = model.AppDomain;
return(DBUtility.OracleDBHelper.OracleHelper.ExecuteSql(strSql.ToString(), parameters));
}
public string DelAliasNameByID()
{
AliasNameManager manager = new AliasNameManager();
AliasNameModel model = new AliasNameModel();
try
{
model.BOId = Request["BOID"];
model.AppDomain = Request["AppDomain"];
manager.Delete(model);
return("OK");
}
catch
{
return("false");
}
}
/// <summary>
/// 修改别名
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(AliasNameModel model)
{
StringBuilder strUpdateSql = new StringBuilder();
strUpdateSql.Append(" UPDATE ALIASNAME SET ");
strUpdateSql.Append(" NAME=@NAME");
strUpdateSql.Append(" WHERE BOID=@BOID AND APPDOMAIN=@APPDOMAIN");
SqlParameter[] parameters =
{
new SqlParameter("@NAME", SqlDbType.VarChar, 50),
new SqlParameter("@BOID", SqlDbType.VarChar, 36),
new SqlParameter("@APPDOMAIN", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.BOId;
parameters[2].Value = model.AppDomain;
return(DBUtility.SqlServerDBHelper.ExecuteSql(strUpdateSql.ToString(), parameters));
}
/// <summary>
/// 添加别名
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(AliasNameModel model)
{
StringBuilder strInsertSql = new StringBuilder();
strInsertSql.Append(" INSERT INTO ALIASNAME( ");
strInsertSql.Append(" BOID,NAME,APPDOMAIN)");
strInsertSql.Append(" VALUES (@BOID,@NAME,@APPDOMAIN)");
SqlParameter[] parameters =
{
new SqlParameter("@BOID", SqlDbType.VarChar, 36),
new SqlParameter("@NAME", SqlDbType.VarChar, 50),
new SqlParameter("@APPDOMAIN", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.BOId;
parameters[1].Value = model.Name;
parameters[2].Value = model.AppDomain;
return(DBUtility.SqlServerDBHelper.ExecuteSql(strInsertSql.ToString(), parameters));
}
/// <summary>
/// 修改别名
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(AliasNameModel model)
{
StringBuilder strUpdateSql = new StringBuilder();
strUpdateSql.Append(" UPDATE ALIASNAME SET ");
strUpdateSql.Append(" NAME=:NAME,CREATUSER=:CREATUSER,UPLOADDATE=:UPLOADDATE");
strUpdateSql.Append(" WHERE BOID=:BOID AND APPDOMAIN=:APPDOMAIN");
OracleParameter[] parameters =
{
new OracleParameter("NAME", OracleDbType.Varchar2, 50),
new OracleParameter("CREATUSER", OracleDbType.Varchar2, 50),
new OracleParameter("UPLOADDATE", OracleDbType.Date),
new OracleParameter("BOID", OracleDbType.Varchar2, 36),
new OracleParameter("APPDOMAIN", OracleDbType.Varchar2, 50)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.CreatUser;
parameters[2].Value = model.UploadDate;
parameters[3].Value = model.BOId;
parameters[4].Value = model.AppDomain;
return(DBUtility.OracleDBHelper.OracleHelper.ExecuteSql(strUpdateSql.ToString(), parameters));
}
/// <summary>
/// 添加别名
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(AliasNameModel model)
{
StringBuilder strInsertSql = new StringBuilder();
strInsertSql.Append(" INSERT INTO ALIASNAME( ");
strInsertSql.Append(" BOID,NAME,APPDOMAIN,CREATUSER,UPLOADDATE)");
strInsertSql.Append(" VALUES (:BOID,:NAME,:APPDOMAIN,:CREATUSER,:UPLOADDATE)");
OracleParameter[] parameters =
{
new OracleParameter("BOID", OracleDbType.Varchar2, 36),
new OracleParameter("NAME", OracleDbType.Varchar2, 50),
new OracleParameter("APPDOMAIN", OracleDbType.Varchar2, 50),
new OracleParameter("CREATUSER", OracleDbType.Varchar2, 50),
new OracleParameter("UPLOADDATE", OracleDbType.Date)
};
parameters[0].Value = model.BOId;
parameters[1].Value = model.Name;
parameters[2].Value = model.AppDomain;
parameters[3].Value = model.CreatUser;
parameters[4].Value = model.UploadDate;
return(DBUtility.OracleDBHelper.OracleHelper.ExecuteSql(strInsertSql.ToString(), parameters));
}
public void Update(AliasNameModel model)
{
PrivateObjectCreate <AliasNameModel> .CreatIAlisaName("AliasNameServer").Update(model);
}
public void Add(AliasNameModel model)
{
PrivateObjectCreate <AliasNameModel> .CreatIAlisaName("AliasNameServer").Insert(model);
}
public bool Exist(AliasNameModel model)
{
return(PrivateObjectCreate <AliasNameModel> .CreatIAlisaName("AliasNameServer").Exist(model));
}
//public bool Exist(AliasNameModel model)
//{
// return ObjectCreate<AliasNameModel>.CreatIAlisaName("AliasNameServer").Exist(model);
//}
//public void Add(AliasNameModel model)
//{
// ObjectCreate<AliasNameModel>.CreatIAlisaName("AliasNameServer").Insert(model);
//}
//public void Update(AliasNameModel model)
//{
// ObjectCreate<AliasNameModel>.CreatIAlisaName("AliasNameServer").Update(model);
//}
//public int Delete(AliasNameModel model)
//{
// return ObjectCreate<AliasNameModel>.CreatIAlisaName("AliasNameServer").Delete(model);
//}
//public IList<AliasNameModel> GetListByID(string id)
//{
// return ObjectCreate<AliasNameModel>.CreatIAlisaName("AliasNameServer").GetListByID(id);
//}
//public IList<AliasNameModel> GetListByName(string name)
//{
// return ObjectCreate<AliasNameModel>.CreatIAlisaName("AliasNameServer").GetListByName(name);
//}
//public IList<AliasNameModel> GetList()
//{
// return ObjectCreate<AliasNameModel>.CreatIAlisaName("AliasNameServer").GetList();
//}
///// <summary>
///// 根据对象ID和应用域确定对象别名
///// </summary>
///// <param name="boId"></param>
///// <param name="appDomain"></param>
///// <returns></returns>
//public IList<AliasNameModel> GetAlisaNameByIDAndAppDomain(string boId, string appDomain)
//{
// return ObjectCreate<AliasNameModel>.CreatIAlisaName("AliasNameServer").GetAlisaNameByIDAndAppDomain(boId, appDomain);
//}
public int Delete(AliasNameModel model)
{
return(PrivateObjectCreate <AliasNameModel> .CreatIAlisaName("AliasNameServer").Delete(model));
}
