/// <summary>
/// 新增或更新——组织机构信息
/// </summary>
/// <param name="modelFieldValue">业务数据</param>
/// <returns></returns>
//一改原先繁杂的参数模式,现在统统放到dynamic中,不管是什么类型,用户只要按照键值的格式输入进行,输入几个都可以,具有很强的伸缩性。
public string ZZJG_InsertOrUpdateData(dynamic modelFieldValue)
{try
{
List<string> sqllist = new List<string>();
IDictionary<string, object> dicFileValue = new Dictionary<string, object>(StringComparer.OrdinalIgnoreCase);
dicFileValue = (Dictionary<string, object>)modelFieldValue;
bool isadd_ = true;
string id = Guid.NewGuid().ToString("N");
if (dicFileValue.ContainsKey("ID"))
{
if (dicFileValue["ID"] == null || dicFileValue["ID"].ToString() == "")
{
dicFileValue["ID"] = id;
}
else
{
id = dicFileValue["ID"].ToString();
isadd_ = false;
}
}
else
{
dicFileValue.Add("ID", id);
}
bool issucess = true;
if (isadd_)
issucess = Global.dbHelper.insertByParams(DBParameter.tb_DEPARTMENT, dicFileValue);
else
issucess = Global.dbHelper.updateByParams(DBParameter.tb_DEPARTMENT, dicFileValue);
return JsonHelper.SerializeObject(new ResultModel(issucess, id));
}
catch (Exception ex_)
{
SystemLogger.getLogger().Error("异常!", ex_);
return "";
};
}
/// <summary>
/// 删除_组织机构
/// </summary>
/// <param name="_id">主键ID</param>
/// <param name="_yhid">用户ID</param>
/// <returns></returns>
public string ZZJG_DeleteData(string _id)
{
try
{
string sql = "delete from " + DBParameter.tb_DEPARTMENT + " where ID= '" + _id + " '";
int n = Global.dbHelper.execute(sql);
bool issuccess = n > 0 ? true : false;
return JsonHelper.SerializeObject(new ResultModel(issuccess, issuccess));
}
catch (Exception ex_)
{
SystemLogger.getLogger().Error("异常!", ex_);
return "";
}
}
/// <summary>
/// 条件查询_组织机构
/// </summary>
/// <param name="_cols">字段集</param>
/// <param name="_where">过滤条件</param>
/// <param name="_orderby">排序依据</param>
/// <param name="_pageSize">每页最大记录数</param>
/// <param name="_pageIndex">页索引(从0起)</param>
/// <param name="_returnSum">过滤条件</param>
/// <returns></returns>
public string ZZJG_SelectByWhere(List<string> _cols, string _where, string _orderby, int _pageSize, int _pageIndex, bool _returnSum)
{
int i = 0;
string colsSql = "";
if (_cols == null || _cols.Count == 0)
{
colsSql = "*";
}
else
{
for (i = 0; i < _cols.Count; i++)
{
if (i == _cols.Count - 1)
{
colsSql += _cols[i];
}
else
{
colsSql += _cols[i] + ",";
}
}
}
string sql = "select " + _cols + " from " + DBParameter.tb_DEPARTMENT;
if (!string.IsNullOrEmpty(_where))
{
sql += "where " + _where;
}
if (!string.IsNullOrEmpty(_orderby))
{
sql += "order by " + _orderby;
}
if (_pageSize > 0 && _pageIndex > 0)
{
int indexStart_ = (_pageIndex - 1) * _pageSize;
sql += " limit " + indexStart_ + "," + _pageSize;
}
DataTable dt = null;
try
{
dt = Global.dbHelper.getDataTableResult(sql);
}
catch (Exception ex)
{
return JsonHelper.SerializeObject(new ResultModel(false, null, ex.ToString()));
}
if (!_returnSum)
return JsonHelper.SerializeObject(new ResultModel(true, dt));
sql = "select count(*) from " + DBParameter.tb_DEPARTMENT;
if (!string.IsNullOrEmpty(_where))
sql += "where" + _where;
int count = int.Parse(Global.dbHelper.executeScalar(sql).ToString());
Dictionary<string, object> result = new Dictionary<string, object>();
result.Add("data", dt);
result.Add("count", count);
return JsonHelper.SerializeObject(new ResultModel(true, result));
}
/// <summary>
/// 获取详情_组织机构
/// </summary>
/// <param name="_id">主键ID</param>
/// <returns></returns>
public string ZZJG_GetById(string _id)
{
string sql = "select * from " + DBParameter.tb_DEPARTMENT;
if (!string.IsNullOrEmpty(_id))
sql += " where ID='" + _id + "'";
DataTable dt = null;
try
{
dt = Global.dbHelper.getDataTableResult(sql);
}
catch (Exception ex)
{
return JsonHelper.SerializeObject(new ResultModel(false, null, ex.ToString()));
}
return JsonHelper.SerializeObject(new ResultModel(true, dt));
}
/// <summary>
/// 获取_组织机构树
/// </summary
/// <returns></returns>
public string Get_zzjgtree()
{
string sql_ = "select * from " + DBParameter.tb_DEPARTMENT;
DataTable dt_ = db.GetDataTable(sql_);
if (dt_.Rows.Count < 1)
return "";
DataRow[] dataRows_ = dt_.Select("PARENTID IS NULL");
Json result_ = new Json();
JsonArrayItem rows_ = result_.SetArrayValue("children") as JsonArrayItem;
Json json_;
foreach (DataRow row_ in dataRows_)
{
json_ = JsonDataTable.DataRowToJson(row_);
db.InitChildrenData(dt_, "ID", "PARENTID", json_, row_["ID"].ToString());
rows_.AddJsonValue(json_);
}
return result_.ToString();
}