/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LCSS.Model.Organization model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Organization set ");
strSql.Append("Org_Name=@Org_Name,");
strSql.Append("Org_Parent_Code=@Org_Parent_Code,");
strSql.Append("Org_Status=@Org_Status,");
strSql.Append("Org_Layer=@Org_Layer");
strSql.Append(" where Org_Code=@Org_Code");
SqlParameter[] parameters =
{
new SqlParameter("@Org_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Org_Parent_Code", SqlDbType.VarChar, 20),
new SqlParameter("@Org_Status", SqlDbType.Bit, 1),
new SqlParameter("@Org_Layer", SqlDbType.NVarChar, 20),
new SqlParameter("@Org_Code", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.Org_Name;
parameters[1].Value = model.Org_Parent_Code;
parameters[2].Value = model.Org_Status;
parameters[3].Value = model.Org_Layer;
parameters[4].Value = model.Org_Code;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(LCSS.Model.Organization model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Organization(");
strSql.Append("Org_Code,Org_Name,Org_Parent_Code,Org_Status,Org_Layer)");
strSql.Append(" values (");
strSql.Append("@Org_Code,@Org_Name,@Org_Parent_Code,@Org_Status,@Org_Layer)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Org_Code", SqlDbType.VarChar, 20),
new SqlParameter("@Org_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Org_Parent_Code", SqlDbType.VarChar, 20),
new SqlParameter("@Org_Status", SqlDbType.Bit, 1),
new SqlParameter("@Org_Layer", SqlDbType.NVarChar, 20)
};
parameters[0].Value = model.Org_Code;
parameters[1].Value = model.Org_Name;
parameters[2].Value = model.Org_Parent_Code;
parameters[3].Value = model.Org_Status;
parameters[4].Value = model.Org_Layer;
object obj = DbHelperSQL.ReturnValue(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LCSS.Model.Organization DataRowToModel(DataRow row)
{
LCSS.Model.Organization model = new LCSS.Model.Organization();
if (row != null)
{
if (row["Org_ID"] != null && row["Org_ID"].ToString() != "")
{
model.Org_ID = long.Parse(row["Org_ID"].ToString());
}
if (row["Org_Code"] != null)
{
model.Org_Code = row["Org_Code"].ToString();
}
if (row["Org_Name"] != null)
{
model.Org_Name = row["Org_Name"].ToString();
}
if (row["Org_Parent_Code"] != null)
{
model.Org_Parent_Code = row["Org_Parent_Code"].ToString();
}
if (row["Org_Status"] != null && row["Org_Status"].ToString() != "")
{
if ((row["Org_Status"].ToString() == "1") || (row["Org_Status"].ToString().ToLower() == "true"))
{
model.Org_Status = true;
}
else
{
model.Org_Status = false;
}
}
if (row["Org_Layer"] != null)
{
model.Org_Layer = row["Org_Layer"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LCSS.Model.Organization GetModel(string Org_Code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Org_ID,Org_Code,Org_Name,Org_Parent_Code,Org_Status,Org_Layer from Organization ");
strSql.Append(" where Org_Code=@Org_Code");
SqlParameter[] parameters =
{
new SqlParameter("@Org_Code", SqlDbType.VarChar, 20)
};
parameters[0].Value = Org_Code;
LCSS.Model.Organization model = new LCSS.Model.Organization();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
