/// <summary> /// 创建协议附件信息XML /// </summary> /// <param name="info"></param> /// <returns></returns> string CreateHeZuoXieYiXML(EyouSoft.Model.ComStructure.MComAttach info) { //<root><info filename="" filepath="" /></root> StringBuilder xml = new StringBuilder(); xml.Append("<root>"); if (info != null && !string.IsNullOrEmpty(info.FilePath)) { xml.AppendFormat("<info filename=\"{0}\" filepath=\"{1}\" />", info.Name, info.FilePath); } xml.Append("</root>"); return(xml.ToString()); }
/// <summary> /// get crm 协议附件 /// </summary> /// <param name="crmId">crmid</param> /// <returns></returns> Model.ComStructure.MComAttach GetCrmXieYiFuJian(string crmId) { Model.ComStructure.MComAttach info = null; DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_GetCrmXieYiFuJian); _db.AddInParameter(cmd, "CrmId", DbType.AnsiStringFixedLength, crmId); _db.AddInParameter(cmd, "AttachType", DbType.Byte, EyouSoft.Model.EnumType.ComStructure.AttachItemType.客户合作协议); using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { info = new EyouSoft.Model.ComStructure.MComAttach(); info.FilePath = rdr["FilePath"].ToString(); info.Name = rdr["Name"].ToString(); } } return(info); }