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