public static ArrayList List(string keywords, int comId, Pager pager)
{
/*
CompanyCertList
@comId int=0,
@keywords varchar(20)='',
@pageIndex int=1,
@pageSize int=20,
@sort int=0
*/
//[Id], CompanyId, Title,Type, Remark, ImageGuid, [Datetime], Checked
ArrayList list = new ArrayList();
SqlParameter[] prams ={
Database.MakeInParam("@comId",SqlDbType.Int,comId),
Database.MakeInParam("@keywords",SqlDbType.VarChar,50,keywords),
Database.MakeInParam("@pageIndex",SqlDbType.Int,pager.PageIndex),
Database.MakeInParam("@pageSize",SqlDbType.Int,pager.PageSize),
Database.MakeInParam("@sort",SqlDbType.Int,pager.SortNum)
};
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "CompanyCertList", prams);
if (reader.Read())
{
pager.RecordCount = reader.GetInt32(0);
if (reader.NextResult())
{
while (reader.Read())
{
CompanyCertificate cert = new CompanyCertificate();
cert.id = reader.GetInt32(0);
cert.companyId = reader.GetInt32(1);
cert.title = reader.GetString(2);
cert.type = ((CertificateType)reader.GetInt16(3));
cert.remark = reader.GetString(4);
cert.imageGuid = reader.GetString(5);
cert.datetime = reader.GetDateTime(6);
cert.isChecked = reader.GetBoolean(7);
list.Add(cert);
}
}
}
reader.Close();
}
catch
{
throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return list;
}
public static CompanyCertificate Get(int id, int comId)
{
/*
CompanyCertGet
@id int,
@comId int=0
*/
//[Id], CompanyId, Title,Type, Remark, ImageGuid, [Datetime], Checked
CompanyCertificate cert = null;
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "CompanyCertGet",
new SqlParameter[] { Database.MakeInParam("@id", SqlDbType.Int, id), Database.MakeInParam("@comId", SqlDbType.Int, comId) });
if (reader.Read())
{
cert = new CompanyCertificate();
cert.id = reader.GetInt32(0);
cert.companyId = reader.GetInt32(1);
cert.title = reader.GetString(2);
cert.type = ((CertificateType)reader.GetInt16(3));
cert.remark = reader.GetString(4);
cert.imageGuid = reader.GetString(5);
cert.datetime = reader.GetDateTime(6);
cert.isChecked = reader.GetBoolean(7);
}
reader.Close();
}
catch
{
//
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return cert;
}
private string GetCertsList(string format, CompanyCertificate[] certs)
{
StringBuilder html = new StringBuilder();
foreach (CompanyCertificate cert in certs)
{
html.AppendFormat(format,
cert.ImageGuid,
cert.Title,
cert.Remark);
}
return html.ToString();
}
/// <summary>
/// ����֤��
/// </summary>
private void SaveCert()
{
Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
if (Request.Form["certId"] != null &&
Request.Form["certType"] != null &&
Request.Form["certName"] != null &&
Request.Form["certDesc"] != null)
{
int certId = Convert.ToInt32(Request.Form["certId"]);
HttpPostedFile file = Request.Files["certFile"];
if (file.ContentLength > 0 && !CompanyCertificate.CheckAttachment(file))
{
Response.Write("parent.setMessage('֤�鸽��������ͼƬ�����Ҳ��ܳ����涨��С��',false);");
}
else
{
short t=9;
try
{
t=Convert.ToInt16(Request.Form["certType"]);
}
catch
{
//
}
CompanyCertificate cert = new CompanyCertificate(SupplierId, t, Request.Form["certName"].Trim(), Request.Form["certDesc"].Trim());
if (certId > 0)
{
cert.ImageGuid = CompanyCertificate.Get(certId).ImageGuid;
}
if (file.ContentLength > 0)
{
file.SaveAs(Server.MapPath("/Suppliers/certs/") + cert.ImageGuid + ".cert");
}
if (cert.Save(certId))
{
//ͬ������Minisite��֤��
MinisiteWriter mw = new MinisiteWriter(SupplierId);
mw.UpdateCerts(true);
Response.Write("parent.refreshCertList('֤���ϴ��ɹ����ȴ���ˣ�');");
}
else
{
Response.Write("parent.setMessage('֤���ϴ�ʧ�ܣ�',false);");
}
}
}
else
{
Response.Write("parent.setMessage('����ʧ�ܣ�',false);");
}
Response.Write("</script>");
}
public CompanyCertificate GetCert(string guid)
{
XmlNode node = configDoc.SelectSingleNode("//Certificates/Cert[@guid='" + guid + "']");
if (node == null)
{
return null;
}
CompanyCertificate c = new CompanyCertificate(supplierId);
c.ImageGuid = guid;
c.Title = node.SelectSingleNode("Title").FirstChild.Value;
c.Remark = node.SelectSingleNode("Remark").FirstChild.Value;
return c;
}
