public string LoadSQL(string sqlFullPath, string templateID, params object[] obValues) { string sql = string.Empty; // null 값일 경우 공백으로 처리 string[] value = obValues.Select(s => (s == null ? "" : s.ToString())).ToArray(); string file = sqlFullPath;// Path.Combine(Global.ConfigInfo.SqlXmlPath, string.Format(@"{0}" //, FileName)); DBAgentMultiTemplate dbaMulti = null; XmlSerializer serializer = new XmlSerializer(typeof(DBAgentMultiTemplate)); XmlReader xr = XmlReader.Create(file); dbaMulti = serializer.Deserialize(xr) as DBAgentMultiTemplate; xr.Close(); // templateID 검색 var query = from a in dbaMulti.DBAgentTemplate where a.TemplateID == templateID select a; if (query != null) { DBAgentTemplate dt = query.First() as DBAgentTemplate; sql = MakeSQL(dt, value); } if (!sql.ToUpper().Contains("NOCOUNT")) { sql = " SET NOCOUNT ON " + "\n" + sql + "\n" + " SET NOCOUNT OFF "; } if (!sql.ToUpper().Contains("ARITHABORT")) { sql = " SET ARITHABORT ON " + "\n" + sql + "\n" + " SET ARITHABORT OFF "; } return(sql); }
public string LoadCondSQL(string sqlFullPath, string templateID, params object[] obValues) { string sql = string.Empty; // null 값일 경우 공백으로 처리 string[] value = obValues.Select(s => (s == null ? "" : s.ToString())).ToArray(); string file = sqlFullPath; // Path.Combine(Global.ConfigInfo.SqlXmlPath, string.Format(@"{0}" //, FileName)); DBAgentMultiTemplate dbaMulti = null; XmlSerializer serializer = new XmlSerializer(typeof(DBAgentMultiTemplate)); XmlReader xr = XmlReader.Create(file); dbaMulti = serializer.Deserialize(xr) as DBAgentMultiTemplate; xr.Close(); // templateID 검색 var query = from a in dbaMulti.DBAgentTemplate where a.TemplateID == templateID select a; if (query != null) { DBAgentTemplate dt = query.First() as DBAgentTemplate; //for (int i = 0; i < value.Length; i++) //{ // if (!value[i].Contains("''")) // { // value[i] = value[i].Replace("'", "''"); // } //} sql = MakeSQL(dt, value); } return(sql); }
public string LoadSQLXml(string sqlFullPath, string templateID, params string[] value) { string sql = string.Empty; string file = sqlFullPath; //Path.Combine(Global.ConfigInfo.SqlXmlPath, string.Format(@"{0}" //, FileName)); DBAgentMultiTemplate dbaMulti = null; XmlSerializer serializer = new XmlSerializer(typeof(DBAgentMultiTemplate)); XmlReader xr = XmlReader.Create(file); dbaMulti = serializer.Deserialize(xr) as DBAgentMultiTemplate; xr.Close(); // templateID 검색 var query = from a in dbaMulti.DBAgentTemplate where a.TemplateID == templateID select a; if (query != null) { DBAgentTemplate dt = query.First() as DBAgentTemplate; for (int i = 0; i < value.Length; i++) { if (!value[i].Contains("@@@@")) { value[i] = value[i].Replace("'", "''"); } value[i] = value[i].Replace("@@@@", ""); } sql = MakeSQL(dt, value); } return(sql); }