/// <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);
}
