/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IndustryPlatform.Model.SYS_Organization model)
{
try
{
lock (this)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_Organization(");
strSql.Append("OrgCode,OrgName,OrgLevel,ParentOrgCode,OrgSeq,OrgType,LinkMan,LinkManTel,Email,IsForbid,Remark,SysCode)");
strSql.Append(" values (");
strSql.Append("@OrgCode,@OrgName,@OrgLevel,@ParentOrgCode,@OrgSeq,@OrgType,@LinkMan,@LinkManTel,@Email,@IsForbid,@Remark,@SysCode)");
SqlParameter[] parameters =
{
new SqlParameter("@OrgCode", SqlDbType.VarChar, 10),
new SqlParameter("@OrgName", SqlDbType.NVarChar, 50),
new SqlParameter("@OrgLevel", SqlDbType.VarChar, 1),
new SqlParameter("@ParentOrgCode", SqlDbType.VarChar, 10),
new SqlParameter("@OrgSeq", SqlDbType.NVarChar, 300),
new SqlParameter("@OrgType", SqlDbType.VarChar, 1),
new SqlParameter("@LinkMan", SqlDbType.NVarChar, 20),
new SqlParameter("@LinkManTel", SqlDbType.NVarChar, 20),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@IsForbid", SqlDbType.VarChar, 1),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@SysCode", SqlDbType.VarChar, 4)
};
int iKey = DbHelperSQL.GetMaxID("OrgCode", "SYS_Organization");
string strSEQ = "";
if (model.ParentOrgCode == "0")
{
strSEQ = iKey + ".";
}
else
{
strSEQ = GetModel(model.ParentOrgCode).OrgSeq + iKey + ".";
}
model.OrgSeq = strSEQ;
parameters[0].Value = model.OrgCode;
parameters[1].Value = model.OrgName;
parameters[2].Value = model.OrgLevel;
parameters[3].Value = model.ParentOrgCode;
parameters[4].Value = model.OrgSeq;
parameters[5].Value = model.OrgType;
parameters[6].Value = model.LinkMan;
parameters[7].Value = model.LinkManTel;
parameters[8].Value = model.Email;
parameters[9].Value = model.IsForbid;
parameters[10].Value = model.Remark;
parameters[11].Value = model.SysCode;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return(1);
}
}
catch
{
return(0);
}
}
public void OrgTreeBind(TreeView tv)
{
tv.Nodes.Clear();
if (CookieManager.GetCookieValue("uid") != "0")
{
IndustryPlatform.Model.SYS_Organization m = GetModel(CookieManager.GetCookieValue("orgID"));
TreeNode n = new TreeNode(m.OrgName, m.OrgCode);
tv.Nodes.Add(n);
OrgTreeBind(m.OrgCode, n, tv);
}
else
{
OrgTreeBind("-1", (TreeNode)null, tv);
}
tv.ExpandAll();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IndustryPlatform.Model.SYS_Organization GetModel(string OrgCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OrgCode,OrgName,OrgLevel,ParentOrgCode,OrgSeq,OrgType,LinkMan,LinkManTel,Email,IsForbid,Remark,SysCode from Sys_Organization ");
strSql.Append(" where OrgCode=@OrgCode ");
SqlParameter[] parameters =
{
new SqlParameter("@OrgCode", SqlDbType.VarChar, 50)
};
parameters[0].Value = OrgCode;
IndustryPlatform.Model.SYS_Organization model = new IndustryPlatform.Model.SYS_Organization();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.OrgCode = ds.Tables[0].Rows[0]["OrgCode"].ToString();
model.OrgName = ds.Tables[0].Rows[0]["OrgName"].ToString();
model.OrgLevel = ds.Tables[0].Rows[0]["OrgLevel"].ToString();
model.ParentOrgCode = ds.Tables[0].Rows[0]["ParentOrgCode"].ToString();
model.OrgSeq = ds.Tables[0].Rows[0]["OrgSeq"].ToString();
model.OrgType = ds.Tables[0].Rows[0]["OrgType"].ToString();
model.LinkMan = ds.Tables[0].Rows[0]["LinkMan"].ToString();
model.LinkManTel = ds.Tables[0].Rows[0]["LinkManTel"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
model.IsForbid = ds.Tables[0].Rows[0]["IsForbid"].ToString();
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
model.SysCode = ds.Tables[0].Rows[0]["SysCode"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IndustryPlatform.Model.SYS_Organization GetModel(string OrgCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OrgCode,OrgName,OrgLevel,ParentOrgCode,OrgSeq,OrgType,LinkMan,LinkManTel,Email,IsForbid,Remark,SysCode from Sys_Organization ");
strSql.Append(" where OrgCode=@OrgCode ");
SqlParameter[] parameters = {
new SqlParameter("@OrgCode", SqlDbType.VarChar,50)};
parameters[0].Value = OrgCode;
IndustryPlatform.Model.SYS_Organization model = new IndustryPlatform.Model.SYS_Organization();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.OrgCode = ds.Tables[0].Rows[0]["OrgCode"].ToString();
model.OrgName = ds.Tables[0].Rows[0]["OrgName"].ToString();
model.OrgLevel = ds.Tables[0].Rows[0]["OrgLevel"].ToString();
model.ParentOrgCode = ds.Tables[0].Rows[0]["ParentOrgCode"].ToString();
model.OrgSeq = ds.Tables[0].Rows[0]["OrgSeq"].ToString();
model.OrgType = ds.Tables[0].Rows[0]["OrgType"].ToString();
model.LinkMan = ds.Tables[0].Rows[0]["LinkMan"].ToString();
model.LinkManTel = ds.Tables[0].Rows[0]["LinkManTel"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
model.IsForbid = ds.Tables[0].Rows[0]["IsForbid"].ToString();
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
model.SysCode = ds.Tables[0].Rows[0]["SysCode"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(IndustryPlatform.Model.SYS_Organization model)
{
try
{
List <string> listSql = new List <string>();
List <SqlParameter[]> listParm = new List <SqlParameter[]>();
string strOldSEQ = GetModel(model.OrgCode).OrgSeq;
string strNewSEQ = model.OrgCode + ".";
if (model.ParentOrgCode != "0")
{
IndustryPlatform.Model.SYS_Organization p = GetModel(model.ParentOrgCode);
strNewSEQ = p.OrgSeq + model.OrgCode + ".";
}
//更新序列
string strSqlSeq = "update SYS_Organization set OrgSeq='" + strNewSEQ + "'+ replace(OrgSeq,'" + strOldSEQ + "','') where OrgSeq like '" + strOldSEQ + "%'";
//DbHelperSQL.ExecuteSql(strSqlSeq);
listSql.Add(strSqlSeq);
listParm.Add(null);
//更新Level
string strSqlLevel = "Update SYS_Organization set orgLevel=len(orgSEQ)-len(replace(orgSEQ,'.' , '')) where orgSEQ like '" + strNewSEQ + "%'";
listSql.Add(strSqlLevel);
listParm.Add(null);
//DbHelperSQL.ExecuteSql(strSqlLevel);
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Organization set ");
strSql.Append("OrgName=@OrgName,");
strSql.Append("OrgLevel=@OrgLevel,");
strSql.Append("ParentOrgCode=@ParentOrgCode,");
strSql.Append("OrgSeq=@OrgSeq,");
strSql.Append("OrgType=@OrgType,");
strSql.Append("LinkMan=@LinkMan,");
strSql.Append("LinkManTel=@LinkManTel,");
strSql.Append("Email=@Email,");
strSql.Append("IsForbid=@IsForbid,");
strSql.Append("Remark=@Remark,");
strSql.Append("SysCode=@SysCode");
strSql.Append(" where OrgCode=@OrgCode ");
SqlParameter[] parameters =
{
new SqlParameter("@OrgCode", SqlDbType.VarChar, 10),
new SqlParameter("@OrgName", SqlDbType.NVarChar, 50),
new SqlParameter("@OrgLevel", SqlDbType.VarChar, 1),
new SqlParameter("@ParentOrgCode", SqlDbType.VarChar, 10),
new SqlParameter("@OrgSeq", SqlDbType.NVarChar, 300),
new SqlParameter("@OrgType", SqlDbType.VarChar, 1),
new SqlParameter("@LinkMan", SqlDbType.NVarChar, 20),
new SqlParameter("@LinkManTel", SqlDbType.NVarChar, 20),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@IsForbid", SqlDbType.VarChar, 1),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@SysCode", SqlDbType.VarChar, 4)
};
parameters[0].Value = model.OrgCode;
parameters[1].Value = model.OrgName;
parameters[2].Value = model.OrgLevel;
parameters[3].Value = model.ParentOrgCode;
parameters[4].Value = strNewSEQ;
parameters[5].Value = model.OrgType;
parameters[6].Value = model.LinkMan;
parameters[7].Value = model.LinkManTel;
parameters[8].Value = model.Email;
parameters[9].Value = model.IsForbid;
parameters[10].Value = model.Remark;
parameters[11].Value = model.SysCode;
listSql.Add(strSql.ToString());
listParm.Add(parameters);
//DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
DbHelperSQL.ExecuteSqlCake(listSql, listParm);
return(1);
}
catch
{
return(0);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(IndustryPlatform.Model.SYS_Organization model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IndustryPlatform.Model.SYS_Organization model)
{
return(dal.Add(model));
}
