/// <summary> /// 删除 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="entity"></param> /// <returns></returns> public int Delete <T>(T entity) where T : class { return(ExecuteBySql(DatabaseCommon.DeleteSql <T>(entity).ToString(), DatabaseCommon.GetParameter <T>(entity))); }
/// <summary> /// 解析XML字符串格式 /// </summary> /// <param name="Xml"></param> /// <param name="arrSql">返回SQL</param> /// <param name="arrParam">返回参数化</param> /// <param name="Action">操作动作</param> private void AnalysisXml(string Xml, out ArrayList arrSql, out ArrayList arrParam, out string Action) { Xml = GZipHelper.Uncompress(Xml); ArrayList _arrSql = new ArrayList(); ArrayList _arrParam = new ArrayList(); string _Action = "-1"; try { XmlDocument xd = new XmlDocument(); xd.LoadXml(Xml); foreach (XmlNode node in xd.ChildNodes) { if (node.Name.Trim() == "Request") { foreach (XmlNode subnode in node.ChildNodes) { if (subnode.Name.Trim() == "data") { //根据接口代码获取对象 BaseInterfaceManage interfacemanage = Repository().FindEntity("Code", subnode.Attributes["code"].Value); if (interfacemanage.InterfaceId != null) { _Action = interfacemanage.Action; //动作类型 string Constraint = interfacemanage.Constraints; //约束达式 foreach (XmlNode node_data in subnode.ChildNodes) { if (node_data.Name.Trim() == "no") { string pkName; string pkVal; switch (_Action) { case "Insert": //新增 Hashtable ht_add = this.XmlNodeToHashtable(node_data); _arrSql.Add(DatabaseCommon.InsertSql(Constraint.Trim(), ht_add)); _arrParam.Add(DatabaseCommon.GetParameter(ht_add)); break; case "Update": //修改 Hashtable ht_edit = this.XmlNodeToHashtable(node_data, out pkName, out pkVal); _arrSql.Add(new StringBuilder(Constraint.Trim())); _arrParam.Add(DatabaseCommon.GetParameter(ht_edit)); break; case "Delete": //删除 Hashtable ht_Delete = this.XmlNodeToHashtable(node_data, out pkName, out pkVal); _arrSql.Add(DatabaseCommon.DeleteSql(Constraint.Trim(), pkName)); _arrParam.Add(DbFactory.CreateDbParameter("@" + pkName, pkVal)); break; case "Select": //查询 Hashtable ht_Param = this.XmlNodeToHashtable(node_data); _arrSql.Add(Constraint.Trim()); _arrParam.Add(DatabaseCommon.GetParameter(ht_Param)); break; case "Procedure": //存储过程 Hashtable ExecuteByProc = this.XmlNodeToHashtable(node_data); _arrSql.Add(Constraint.Trim()); _arrParam.Add(ExecuteByProc); break; case "DataTableProc": //存储过程-DataTableProc Hashtable DataTableProc = this.XmlNodeToHashtable(node_data); _arrSql.Add(Constraint.Trim()); _arrParam.Add(DataTableProc); break; case "DataSetProc": //存储过程-DataSetProc Hashtable DataSetProc = this.XmlNodeToHashtable(node_data); _arrSql.Add(Constraint.Trim()); _arrParam.Add(DataSetProc); break; case "-1": //异常信息 break; default: break; } } } } else { //log.Error(Xml.ToString() + "\r\n接口不存在\r\n"); } } } break; } } } catch (Exception e) { //log.Error(Xml.ToString() + "\r\n" + e.Message + "\r\n"); } finally { arrSql = _arrSql; arrParam = _arrParam; Action = _Action; } }
/// <summary> /// 删除 /// </summary> /// <typeparam name="T"></typeparam> /// <returns></returns> public int Delete <T>() where T : class { return(ExecuteBySql(DatabaseCommon.DeleteSql(EntityAttributeHelper.GetEntityTable <T>()).ToString())); }