/// <summary>
/// 设置表头定义批量公开
/// </summary>
/// <param name="KeyValue">主键值</param>
/// <param name="MenuId">模块菜单主键</param>
/// <returns></returns>
public int BatchIsPublic(string[] KeyValue, string MenuId)
{
StringBuilder[] sqls = new StringBuilder[KeyValue.Length + 1];
object[] objs = new object[KeyValue.Length + 1];
BPMS_TableColumns entity = new BPMS_TableColumns();
entity.MenuId = MenuId;
entity.IsPublic = 0;
sqls[0] = DbCommon.UpdateSql(entity, "MenuId");
objs[0] = DbCommon.GetParameter(entity);
int index = 1;
foreach (string item in KeyValue)
{
if (item.Length > 0)
{
BPMS_TableColumns entityitem = new BPMS_TableColumns();
entityitem.TableColumnsId = item;
entityitem.IsPublic = 1;
entityitem.SortCode = index;
sqls[index] = DbCommon.UpdateSql(entityitem, "TableColumnsId");
objs[index] = DbCommon.GetParameter(entityitem);
index++;
}
}
return(DataFactory.SqlHelper().BatchExecuteBySql(sqls, objs));
}
/// <summary>
/// 通过实体类修改数据
/// </summary>
/// <param name="entity">实体类</param>
/// <param name="key">主键</param>
/// <returns></returns>
public int Update <T>(T entity, string key)
{
this.GetInstance();
return(db.ExecuteBySql(DbCommon.UpdateSql(entity, key), DbCommon.GetParameter(entity)));
}
/// <summary>
/// 批量新增 接口，接口参数
/// </summary>
/// <param name="InterfaceFrom">接口配置</param>
/// <param name="InterfaceDetailsFrom">接口参数明细</param>
/// <param name="key">主键</param>
/// <returns></returns>
public int AddInterfaceManage(object[] InterfaceFrom, object[] InterfaceDetailsFrom, string key)
{
try
{
StringBuilder[] sqls = new StringBuilder[InterfaceDetailsFrom.Length + 2];
object[] objs = new object[InterfaceDetailsFrom.Length + 2];
Hashtable ht_Interface = new Hashtable();
foreach (string item in InterfaceFrom)
{
if (item.Length > 0)
{
string[] str_item = item.Split('☻');
ht_Interface[str_item[0]] = str_item[1];
}
}
if (!string.IsNullOrEmpty(key))
{
ht_Interface["InterfaceId"] = key;
ht_Interface["ModifyDate"] = DateTime.Now;
ht_Interface["ModifyUserId"] = RequestSession.GetSessionUser().UserId;
ht_Interface["ModifyUserName"] = RequestSession.GetSessionUser().UserName;
}
else
{
ht_Interface["InterfaceId"] = CommonHelper.GetGuid;
ht_Interface["CreateUserId"] = RequestSession.GetSessionUser().UserId;
ht_Interface["CreateUserName"] = RequestSession.GetSessionUser().UserName;
}
sqls[0] = !string.IsNullOrEmpty(key) ? DbCommon.UpdateSql("BASE_InterfaceManage", "InterfaceId", ht_Interface) : DbCommon.InsertSql("BASE_InterfaceManage", ht_Interface);
objs[0] = DbCommon.GetParameter(ht_Interface);
sqls[1] = DbCommon.DeleteSql("BASE_InterfaceManageDetails", "InterfaceId");
objs[1] = new SqlParam[] { new SqlParam("@InterfaceId", key) };
int index = 2;
foreach (string item in InterfaceDetailsFrom)
{
if (item.Length > 0)
{
Hashtable ht_InterfaceDetails = new Hashtable();
foreach (string itemwithin in item.Split('☺'))
{
if (itemwithin.Length > 0)
{
string[] str_item = itemwithin.Split('☻');
ht_InterfaceDetails[str_item[0]] = str_item[1];
if (str_item[0].ToString() == "FieldMinLength")
{
ht_InterfaceDetails[str_item[0]] = str_item[1] == "true" ? 0 : 1;
}
if (str_item[0].ToString() == "Enabled")
{
ht_InterfaceDetails[str_item[0]] = str_item[1] == "true" ? 0 : 1;
}
}
}
ht_InterfaceDetails["InterfaceDetailsId"] = CommonHelper.GetGuid;
ht_InterfaceDetails["InterfaceId"] = ht_Interface["InterfaceId"];
sqls[index] = DbCommon.InsertSql("BASE_InterfaceManageDetails", ht_InterfaceDetails);;
objs[index] = DbCommon.GetParameter(ht_InterfaceDetails);
index++;
}
}
return(DataFactory.SqlHelper().BatchExecuteBySql(sqls, objs));
}
catch
{
return(-1);
}
}
/// <summary>
/// 通过Hashtable修改数据
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="pkName">字段主键</param>
/// <param name="pkValue"></param>
/// <param name="ht">Hashtable</param>
/// <returns>int</returns>
public int Update(string tableName, string pkName, string pkVal, Hashtable ht)
{
ht[pkName] = pkVal;
this.GetInstance();
return(db.ExecuteBySql(DbCommon.UpdateSql(tableName, pkName, ht), DbCommon.GetParameter(ht)));
}