/// <summary>
/// 向数据表DawnAuthFunction修改一条记录
/// </summary>
/// <param name="dawnAuthFunction">DawnAuthFunction实体对象</param>
/// <returns></returns>
public static int Update(DawnAuthFunctionMDL dawnAuthFunction)
{
if (dawnAuthFunction == null)
{
return(0);
}
return(DawnAuthFunctionBLL._dal.Update(dawnAuthFunction));
}
/// <summary>
/// 向数据表DawnAuthFunction中插入一条新记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="dawnAuthFunction">DawnAuthFunction实体对象</param>
/// <returns>ı</returns>
public static int Insert(SqlTransaction sp, DawnAuthFunctionMDL dawnAuthFunction)
{
if (dawnAuthFunction == null)
{
return(0);
}
return(DawnAuthFunctionBLL._dal.Insert(sp, dawnAuthFunction));
}
/// <summary>
/// 向数据表DawnAuthFunction中插入一条新记录
/// </summary>
/// <param name="dawnAuthFunction">DawnAuthFunction实体对象</param>
/// <returns></returns>
public static int Insert(DawnAuthFunctionMDL dawnAuthFunction)
{
if (dawnAuthFunction == null)
{
return(0);
}
return(DawnAuthFunctionBLL._dal.Insert(dawnAuthFunction));
}
/// <summary>
/// 得到DawnAuthFunction实体对象
/// </summary>
/// <param name="row">row</param>
/// <returns>DawnAuthFunction实体对象</returns>
public DawnAuthFunctionMDL Select(DataRow row)
{
DawnAuthFunctionMDL obj = new DawnAuthFunctionMDL();
if (row != null)
{
try
{
obj.FunId = ((row["fun_id"]) == DBNull.Value)?0:Convert.ToInt32(row["fun_id"]);
}
catch { }
try
{
obj.MdlId = ((row["mdl_id"]) == DBNull.Value)?0:Convert.ToInt32(row["mdl_id"]);
}
catch { }
try
{
obj.FunTime = ((row["fun_time"]) == DBNull.Value)?DateTime.MinValue:Convert.ToDateTime(row["fun_time"]);
}
catch { }
try
{
obj.FunName = row["fun_name"].ToString();
}
catch { }
try
{
obj.FunCode = row["fun_code"].ToString();
}
catch { }
try
{
obj.FunIdent = ((row["fun_ident"]) == DBNull.Value)?0:Convert.ToInt32(row["fun_ident"]);
}
catch { }
try
{
obj.FunMark = ((row["fun_mark"]) == DBNull.Value)?0:Convert.ToInt32(row["fun_mark"]);
}
catch { }
try
{
obj.FunParentMark = ((row["fun_parent_mark"]) == DBNull.Value)?0:Convert.ToInt32(row["fun_parent_mark"]);
}
catch { }
try
{
obj.FunDesc = row["fun_desc"].ToString();
}
catch { }
}
else
{
return(null);
}
return(obj);
}
/// <summary>
/// 得到DawnAuthFunction实体对象
/// </summary>
/// <param name="dr">dr</param>
/// <returns>DawnAuthFunctions实体对象</returns>
public DawnAuthFunctionMDL Select(IDataReader dr)
{
DawnAuthFunctionMDL obj = new DawnAuthFunctionMDL();
try
{
obj.FunId = ((dr["fun_id"]) == DBNull.Value)?0:Convert.ToInt32(dr["fun_id"]);
}
catch { }
try
{
obj.MdlId = ((dr["mdl_id"]) == DBNull.Value)?0:Convert.ToInt32(dr["mdl_id"]);
}
catch { }
try
{
obj.FunTime = ((dr["fun_time"]) == DBNull.Value)?DateTime.MinValue:Convert.ToDateTime(dr["fun_time"]);
}
catch { }
try
{
obj.FunName = dr["fun_name"].ToString();
}
catch { }
try
{
obj.FunCode = dr["fun_code"].ToString();
}
catch { }
try
{
obj.FunIdent = ((dr["fun_ident"]) == DBNull.Value)?0:Convert.ToInt32(dr["fun_ident"]);
}
catch { }
try
{
obj.FunMark = ((dr["fun_mark"]) == DBNull.Value)?0:Convert.ToInt32(dr["fun_mark"]);
}
catch { }
try
{
obj.FunParentMark = ((dr["fun_parent_mark"]) == DBNull.Value)?0:Convert.ToInt32(dr["fun_parent_mark"]);
}
catch { }
try
{
obj.FunDesc = dr["fun_desc"].ToString();
}
catch { }
return(obj);
}
/// <summary>
/// 根据ID,返回一个DawnAuthFunction实体对象
/// </summary>
/// <param name="funId">系统编号</param>
/// <returns>DawnAuthFunction实体对象</returns>
public DawnAuthFunctionMDL Select(int funId)
{
DawnAuthFunctionMDL obj = null;
SqlParameter[] param =
{
new SqlParameter("@FunId", SqlDbType.Int)
};
param[0].Value = funId;
string sqlCommand = "DawnAuthFunctionSelect";
using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
{
while (dr.Read())
{
obj = this.Select(dr);
}
}
return(obj);
}
public string Added(FormCollection form)
{
var stateInfo = GeneralHandler.StateSuccess;
if (AddedByCheck(form, out stateInfo))
{
DawnAuthFunctionMDL dataInfo = new DawnAuthFunctionMDL();
dataInfo.MdlId = int.Parse(form["ddlModule"]);
dataInfo.FunTime = DateTime.Now;
dataInfo.FunName = form["txtName"];
dataInfo.FunCode = form["txtCode"];
dataInfo.FunIdent = TypeHelper.TypeToInt32(form["txtIdent"], 0);
dataInfo.FunMark = DawnAuthFunctionBLL.GetMaxFunMark(dataInfo.MdlId);
dataInfo.FunMark += 1;
var mark = TypeHelper.TypeToInt32(form["ddlParentMark"], -1);
dataInfo.FunParentMark = mark != -1 ? DawnAuthFunctionBLL.GetParentMark(dataInfo.MdlId) : mark;
dataInfo.FunDesc = form["txtDesc"];
bool added = false;
if (dataInfo.FunIdent == 0)
{
added = DawnAuthFunctionBLL.Exists(string.Format("mdl_id='{0}' and (fun_name='{1}' or fun_code='{2}')", dataInfo.MdlId, dataInfo.FunName, dataInfo.FunCode));
}
else
{
added = DawnAuthFunctionBLL.Exists(string.Format("(mdl_id='{0}' and (fun_name='{1}' or fun_code='{2}')) or fun_ident='{3}'", dataInfo.MdlId, dataInfo.FunName, dataInfo.FunCode, dataInfo.FunIdent));
}
if (added)
{
stateInfo = GeneralHandler.StateAdded;
}
else
{
DawnAuthFunctionBLL.Insert(dataInfo);
}
}
return(stateInfo);
}
/// <summary>
/// 删除数据表DawnAuthFunction中的一条记录,带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="dawnAuthFunction">DawnAuthFunction实体对象</param>
/// <returns></returns>
public int Delete(SqlTransaction sp, DawnAuthFunctionMDL dawnAuthFunction)
{
return(DawnAuthFunctionBLL._dal.Delete(sp, dawnAuthFunction));
}
/// <summary>
/// 删除数据表DawnAuthFunction中的一条记录
/// </summary>
/// <param name="dawnAuthFunction">DawnAuthFunction实体对象</param>
/// <returns></returns>
public static int Delete(DawnAuthFunctionMDL dawnAuthFunction)
{
return(DawnAuthFunctionBLL._dal.Delete(dawnAuthFunction));
}
