/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_UserMale model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_UserMale(");
strSql.Append("ParentID,MyLeft,MyRight,UserMaleCode,UserMale001,UserMale002,OrderID,UserID,AddDate,IsOut,OutDate,UserPath,Layer,Location");
strSql.Append(") values (");
strSql.Append("@ParentID,@MyLeft,@MyRight,@UserMaleCode,@UserMale001,@UserMale002,@OrderID,@UserID,@AddDate,@IsOut,@OutDate,@UserPath,@Layer,@Location");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@MyLeft", SqlDbType.Int, 4),
new SqlParameter("@MyRight", SqlDbType.Int, 4),
new SqlParameter("@UserMaleCode", SqlDbType.VarChar, 50),
new SqlParameter("@UserMale001", SqlDbType.VarChar, 50),
new SqlParameter("@UserMale002", SqlDbType.VarChar, 50),
new SqlParameter("@OrderID", SqlDbType.Int, 4),
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@IsOut", SqlDbType.Int, 4),
new SqlParameter("@OutDate", SqlDbType.DateTime),
new SqlParameter("@UserPath", SqlDbType.Text),
new SqlParameter("@Layer", SqlDbType.Int, 4),
new SqlParameter("@Location", SqlDbType.Int, 4)
};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.MyLeft;
parameters[2].Value = model.MyRight;
parameters[3].Value = model.UserMaleCode;
parameters[4].Value = model.UserMale001;
parameters[5].Value = model.UserMale002;
parameters[6].Value = model.OrderID;
parameters[7].Value = model.UserID;
parameters[8].Value = model.AddDate;
parameters[9].Value = model.IsOut;
parameters[10].Value = model.OutDate;
parameters[11].Value = model.UserPath;
parameters[12].Value = model.Layer;
parameters[13].Value = model.Location;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_UserMale model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_UserMale set ");
strSql.Append(" ParentID = @ParentID , ");
strSql.Append(" MyLeft = @MyLeft , ");
strSql.Append(" MyRight = @MyRight , ");
strSql.Append(" UserMaleCode = @UserMaleCode , ");
strSql.Append(" UserMale001 = @UserMale001 , ");
strSql.Append(" UserMale002 = @UserMale002 , ");
strSql.Append(" OrderID = @OrderID , ");
strSql.Append(" UserID = @UserID , ");
strSql.Append(" AddDate = @AddDate , ");
strSql.Append(" IsOut = @IsOut , ");
strSql.Append(" OutDate = @OutDate , ");
strSql.Append(" UserPath = @UserPath , ");
strSql.Append(" Layer = @Layer , ");
strSql.Append(" Location = @Location ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@MyLeft", SqlDbType.Int, 4),
new SqlParameter("@MyRight", SqlDbType.Int, 4),
new SqlParameter("@UserMaleCode", SqlDbType.VarChar, 50),
new SqlParameter("@UserMale001", SqlDbType.VarChar, 50),
new SqlParameter("@UserMale002", SqlDbType.VarChar, 50),
new SqlParameter("@OrderID", SqlDbType.Int, 4),
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@IsOut", SqlDbType.Int, 4),
new SqlParameter("@OutDate", SqlDbType.DateTime),
new SqlParameter("@UserPath", SqlDbType.Text),
new SqlParameter("@Layer", SqlDbType.Int, 4),
new SqlParameter("@Location", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ParentID;
parameters[2].Value = model.MyLeft;
parameters[3].Value = model.MyRight;
parameters[4].Value = model.UserMaleCode;
parameters[5].Value = model.UserMale001;
parameters[6].Value = model.UserMale002;
parameters[7].Value = model.OrderID;
parameters[8].Value = model.UserID;
parameters[9].Value = model.AddDate;
parameters[10].Value = model.IsOut;
parameters[11].Value = model.OutDate;
parameters[12].Value = model.UserPath;
parameters[13].Value = model.Layer;
parameters[14].Value = model.Location;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据ID获取一条数据
/// </summary>
/// <returns></returns>
public lgk.Model.tb_UserMale GetModelByID(int ID)
{
StringBuilder sb = new StringBuilder();
sb.Append("select top 1 ID,OrderID,UserID,AddDate,IsOut,OutDate,UserPath,Layer,Location,ParentID,MyLeft,MyRight,UserMaleCode,UserMale001,UserMale002 from tb_UserMale ");
sb.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
lgk.Model.tb_UserMale model = new lgk.Model.tb_UserMale();
DataSet ds = DbHelperSQL.Query(sb.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderID"] != null && ds.Tables[0].Rows[0]["OrderID"].ToString() != "")
{
model.OrderID = int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["AddDate"] != null && ds.Tables[0].Rows[0]["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString());
}
if (ds.Tables[0].Rows[0]["IsOut"] != null && ds.Tables[0].Rows[0]["IsOut"].ToString() != "")
{
model.IsOut = int.Parse(ds.Tables[0].Rows[0]["IsOut"].ToString());
}
if (ds.Tables[0].Rows[0]["OutDate"] != null && ds.Tables[0].Rows[0]["OutDate"].ToString() != "")
{
model.OutDate = DateTime.Parse(ds.Tables[0].Rows[0]["OutDate"].ToString());
}
if (ds.Tables[0].Rows[0]["UserPath"] != null && ds.Tables[0].Rows[0]["UserPath"].ToString() != "")
{
model.UserPath = ds.Tables[0].Rows[0]["UserPath"].ToString();
}
if (ds.Tables[0].Rows[0]["Layer"] != null && ds.Tables[0].Rows[0]["Layer"].ToString() != "")
{
model.Layer = int.Parse(ds.Tables[0].Rows[0]["Layer"].ToString());
}
if (ds.Tables[0].Rows[0]["Location"] != null && ds.Tables[0].Rows[0]["Location"].ToString() != "")
{
model.Location = int.Parse(ds.Tables[0].Rows[0]["Location"].ToString());
}
if (ds.Tables[0].Rows[0]["ParentID"] != null && ds.Tables[0].Rows[0]["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString());
}
if (ds.Tables[0].Rows[0]["MyLeft"] != null && ds.Tables[0].Rows[0]["MyLeft"].ToString() != "")
{
model.MyLeft = int.Parse(ds.Tables[0].Rows[0]["MyLeft"].ToString());
}
if (ds.Tables[0].Rows[0]["MyRight"] != null && ds.Tables[0].Rows[0]["MyRight"].ToString() != "")
{
model.MyRight = int.Parse(ds.Tables[0].Rows[0]["MyRight"].ToString());
}
if (ds.Tables[0].Rows[0]["UserMaleCode"] != null && ds.Tables[0].Rows[0]["UserMaleCode"].ToString() != "")
{
model.UserMaleCode = ds.Tables[0].Rows[0]["UserMaleCode"].ToString();
}
if (ds.Tables[0].Rows[0]["UserMale001"] != null && ds.Tables[0].Rows[0]["UserMale001"].ToString() != "")
{
model.UserMale001 = ds.Tables[0].Rows[0]["UserMale001"].ToString();
}
if (ds.Tables[0].Rows[0]["UserMale002"] != null && ds.Tables[0].Rows[0]["UserMale002"].ToString() != "")
{
model.UserMale002 = ds.Tables[0].Rows[0]["UserMale002"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 根据条件获取一条数据
/// </summary>
/// <returns></returns>
public lgk.Model.tb_UserMale GetModelByWhere(string whereStr)
{
StringBuilder sb = new StringBuilder();
sb.Append("select top 1 ID,OrderID,UserID,AddDate,IsOut,OutDate,UserPath,Layer,Location,ParentID,MyLeft,MyRight,UserMaleCode,UserMale001,UserMale002 from tb_UserMale ");
if (!string.IsNullOrEmpty(whereStr))
{
sb.Append(" where " + whereStr);
}
lgk.Model.tb_UserMale model = new lgk.Model.tb_UserMale();
DataSet ds = DbHelperSQL.Query(sb.ToString(), null);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderID"] != null && ds.Tables[0].Rows[0]["OrderID"].ToString() != "")
{
model.OrderID = int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["AddDate"] != null && ds.Tables[0].Rows[0]["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString());
}
if (ds.Tables[0].Rows[0]["IsOut"] != null && ds.Tables[0].Rows[0]["IsOut"].ToString() != "")
{
model.IsOut = int.Parse(ds.Tables[0].Rows[0]["IsOut"].ToString());
}
if (ds.Tables[0].Rows[0]["OutDate"] != null && ds.Tables[0].Rows[0]["OutDate"].ToString() != "")
{
model.OutDate = DateTime.Parse(ds.Tables[0].Rows[0]["OutDate"].ToString());
}
if (ds.Tables[0].Rows[0]["UserPath"] != null && ds.Tables[0].Rows[0]["UserPath"].ToString() != "")
{
model.UserPath = ds.Tables[0].Rows[0]["UserPath"].ToString();
}
if (ds.Tables[0].Rows[0]["Layer"] != null && ds.Tables[0].Rows[0]["Layer"].ToString() != "")
{
model.Layer = int.Parse(ds.Tables[0].Rows[0]["Layer"].ToString());
}
if (ds.Tables[0].Rows[0]["Location"] != null && ds.Tables[0].Rows[0]["Location"].ToString() != "")
{
model.Location = int.Parse(ds.Tables[0].Rows[0]["Location"].ToString());
}
if (ds.Tables[0].Rows[0]["ParentID"] != null && ds.Tables[0].Rows[0]["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString());
}
if (ds.Tables[0].Rows[0]["MyLeft"] != null && ds.Tables[0].Rows[0]["MyLeft"].ToString() != "")
{
model.MyLeft = int.Parse(ds.Tables[0].Rows[0]["MyLeft"].ToString());
}
if (ds.Tables[0].Rows[0]["MyRight"] != null && ds.Tables[0].Rows[0]["MyRight"].ToString() != "")
{
model.MyRight = int.Parse(ds.Tables[0].Rows[0]["MyRight"].ToString());
}
if (ds.Tables[0].Rows[0]["UserMaleCode"] != null && ds.Tables[0].Rows[0]["UserMaleCode"].ToString() != "")
{
model.UserMaleCode = ds.Tables[0].Rows[0]["UserMaleCode"].ToString();
}
if (ds.Tables[0].Rows[0]["UserMale001"] != null && ds.Tables[0].Rows[0]["UserMale001"].ToString() != "")
{
model.UserMale001 = ds.Tables[0].Rows[0]["UserMale001"].ToString();
}
if (ds.Tables[0].Rows[0]["UserMale002"] != null && ds.Tables[0].Rows[0]["UserMale002"].ToString() != "")
{
model.UserMale002 = ds.Tables[0].Rows[0]["UserMale002"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 获取没有放满子节点的公排时间最早的节点
/// </summary>
/// <returns></returns>
public lgk.Model.tb_UserMale GetNoFullChildNode()
{
string strSQL = "select top 1 ID,OrderID,UserID,AddDate,IsOut,OutDate,UserPath,Layer,Location,ParentID,MyLeft,MyRight,UserMaleCode,UserMale001,UserMale002 from tb_UserMale WHERE AddDate = (select MIN(AddDate) from tb_UserMale where (MyLeft = 0 OR MyRight = 0) AND IsOut <> 1)";
lgk.Model.tb_UserMale model = new lgk.Model.tb_UserMale();
DataSet ds = DbHelperSQL.Query(strSQL, null);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderID"] != null && ds.Tables[0].Rows[0]["OrderID"].ToString() != "")
{
model.OrderID = int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["AddDate"] != null && ds.Tables[0].Rows[0]["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString());
}
if (ds.Tables[0].Rows[0]["IsOut"] != null && ds.Tables[0].Rows[0]["IsOut"].ToString() != "")
{
model.IsOut = int.Parse(ds.Tables[0].Rows[0]["IsOut"].ToString());
}
if (ds.Tables[0].Rows[0]["OutDate"] != null && ds.Tables[0].Rows[0]["OutDate"].ToString() != "")
{
model.OutDate = DateTime.Parse(ds.Tables[0].Rows[0]["OutDate"].ToString());
}
if (ds.Tables[0].Rows[0]["UserPath"] != null && ds.Tables[0].Rows[0]["UserPath"].ToString() != "")
{
model.UserPath = ds.Tables[0].Rows[0]["UserPath"].ToString();
}
if (ds.Tables[0].Rows[0]["Layer"] != null && ds.Tables[0].Rows[0]["Layer"].ToString() != "")
{
model.Layer = int.Parse(ds.Tables[0].Rows[0]["Layer"].ToString());
}
if (ds.Tables[0].Rows[0]["Location"] != null && ds.Tables[0].Rows[0]["Location"].ToString() != "")
{
model.Location = int.Parse(ds.Tables[0].Rows[0]["Location"].ToString());
}
if (ds.Tables[0].Rows[0]["ParentID"] != null && ds.Tables[0].Rows[0]["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString());
}
if (ds.Tables[0].Rows[0]["MyLeft"] != null && ds.Tables[0].Rows[0]["MyLeft"].ToString() != "")
{
model.MyLeft = int.Parse(ds.Tables[0].Rows[0]["MyLeft"].ToString());
}
if (ds.Tables[0].Rows[0]["MyRight"] != null && ds.Tables[0].Rows[0]["MyRight"].ToString() != "")
{
model.MyRight = int.Parse(ds.Tables[0].Rows[0]["MyRight"].ToString());
}
if (ds.Tables[0].Rows[0]["UserMaleCode"] != null && ds.Tables[0].Rows[0]["UserMaleCode"].ToString() != "")
{
model.UserMaleCode = ds.Tables[0].Rows[0]["UserMaleCode"].ToString();
}
if (ds.Tables[0].Rows[0]["UserMale001"] != null && ds.Tables[0].Rows[0]["UserMale001"].ToString() != "")
{
model.UserMale001 = ds.Tables[0].Rows[0]["UserMale001"].ToString();
}
if (ds.Tables[0].Rows[0]["UserMale002"] != null && ds.Tables[0].Rows[0]["UserMale002"].ToString() != "")
{
model.UserMale002 = ds.Tables[0].Rows[0]["UserMale002"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_UserMale GetModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, ParentID, MyLeft, MyRight, UserMaleCode, UserMale001, UserMale002, OrderID, UserID, AddDate, IsOut, OutDate, UserPath, Layer, Location ");
strSql.Append(" from tb_UserMale ");
strSql.Append(" where " + strWhere);
strSql.Append(" order by ID asc ");
lgk.Model.tb_UserMale model = new lgk.Model.tb_UserMale();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), null);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString());
}
if (ds.Tables[0].Rows[0]["MyLeft"].ToString() != "")
{
model.MyLeft = int.Parse(ds.Tables[0].Rows[0]["MyLeft"].ToString());
}
if (ds.Tables[0].Rows[0]["MyRight"].ToString() != "")
{
model.MyRight = int.Parse(ds.Tables[0].Rows[0]["MyRight"].ToString());
}
model.UserMaleCode = ds.Tables[0].Rows[0]["UserMaleCode"].ToString();
model.UserMale001 = ds.Tables[0].Rows[0]["UserMale001"].ToString();
model.UserMale002 = ds.Tables[0].Rows[0]["UserMale002"].ToString();
if (ds.Tables[0].Rows[0]["OrderID"].ToString() != "")
{
model.OrderID = int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString());
}
if (ds.Tables[0].Rows[0]["IsOut"].ToString() != "")
{
model.IsOut = int.Parse(ds.Tables[0].Rows[0]["IsOut"].ToString());
}
if (ds.Tables[0].Rows[0]["OutDate"].ToString() != "")
{
model.OutDate = DateTime.Parse(ds.Tables[0].Rows[0]["OutDate"].ToString());
}
model.UserPath = ds.Tables[0].Rows[0]["UserPath"].ToString();
if (ds.Tables[0].Rows[0]["Layer"].ToString() != "")
{
model.Layer = int.Parse(ds.Tables[0].Rows[0]["Layer"].ToString());
}
if (ds.Tables[0].Rows[0]["Location"].ToString() != "")
{
model.Location = int.Parse(ds.Tables[0].Rows[0]["Location"].ToString());
}
return(model);
}
else
{
return(null);
}
}
