private void GetMail() { string receiveid = Request.Cookies["id"].Value.ToString(); string mailtype = "开题材料"; Fannie.Mail ml = new Fannie.Mail(); DataTable dt = new DataTable(); DataSet ds = ml.GetMyMail(1, receiveid, mailtype); DataColumn dc = new DataColumn(); dc.ColumnName = "DataNo"; ds.Tables[0].Columns.Add(dc); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ds.Tables[0].Rows[i]["DataNo"] = (i + 1).ToString(); } MailList.DataKeyNames = new string[] { "MailNo" }; MailList.DataSource = ds; MailList.DataBind(); dt = ds.Tables[0]; if (dt.Rows.Count == 0) { Label1.Visible = true; } else { Label1.Visible = false; } }
private void GetMail() { string senderid = Request.Cookies["id"].Value.ToString(); string mailtype = "答疑"; Fannie.Mail ml = new Fannie.Mail(); DataTable dt = new DataTable(); DataSet ds = ml.GetMyMail(2, senderid, mailtype); DataColumn dc = new DataColumn(); dc.ColumnName = "DataNo"; ds.Tables[0].Columns.Add(dc); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ds.Tables[0].Rows[i]["DataNo"] = (i + 1).ToString(); } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ds.Tables[0].Rows[i]["Theme"] = SubStr(Convert.ToString(ds.Tables[0].Rows[i]["Theme"]), 40); ds.Tables[0].Rows[i]["Contents"] = SubStr(Convert.ToString(ds.Tables[0].Rows[i]["Contents"]), 50); } dt = ds.Tables[0]; if (dt.Rows.Count == 0) { Label1.Visible = true; } else { Label1.Visible = false; } MailList.DataKeyNames = new string[] { "MailNo" }; MailList.DataSource = ds; MailList.DataBind(); }
private void RebuildMailList() { MailEditor.Visible = false; TableFields.Visible = false; MailList.PageSize = UC.PagingSize; MailList.sqlDataSource = "SELECT * FROM ML_MAIL"; MailList.DataBind(); MailList.Visible = true; FileName.Text = "-1"; }
private void BtnSearch_Click(object sender, EventArgs e) { StringBuilder query = new StringBuilder(); query.Append("SELECT * FROM ML_MAIL"); if (this.Search.Text.Length > 0) { query.AppendFormat(" AND (DESCRIPTION LIKE '%{0}' OR SUBJECT LIKE '%{0}%')", DatabaseConnection.FilterInjection(this.Search.Text)); } if (this.SearchMailCategory.SelectedIndex > 0) { query.AppendFormat(" AND (CATEGORYID={0})", this.SearchMailCategory.SelectedValue); } MailList.sqlDataSource = query.ToString(); MailList.DataBind(); }
public void scrivi(string s, string nomefile, string id, string decription) { if (nomefile.Length <= 0) { nomefile = decription; } if (nomefile.Length > 0) { using (DigiDapter dg = new DigiDapter()) { dg.Add("CREATEDBYID", UC.UserId, 'I'); dg.Add("GROUPS", "|" + UC.UserGroupId + "|", 'I'); dg.Add("SUBJECT", nomefile); dg.Add("DESCRIPTION", decription); dg.Add("WELCOME", (this.welcometype.Checked)?1:0); if (this.MailCategory.SelectedIndex > 0) { if (this.MailCategory.SelectedValue == "A99") { if (this.NewMailCategory.Text.Length > 0) { using (DigiDapter dgp = new DigiDapter()) { dgp.Add("catdescription", this.NewMailCategory.Text); object newcatid = dgp.Execute("ML_Categories", DigiDapter.Identities.Identity); dg.Add("CATEGORYID", newcatid.ToString()); ReloadCategories(); } } } else { dg.Add("CATEGORYID", Convert.ToInt64(MailCategory.SelectedValue)); } } dg.Add("BODY", s); object newId = dg.Execute("ML_Mail", "id=" + id, DigiDapter.Identities.Identity); string idml = id; if (dg.RecordInserted) { idml = newId.ToString(); } DatabaseConnection.DoCommand(String.Format("DELETE FROM ML_ATTACHMENT WHERE MLID={0};", idml)); if (IDDocument.Text.Length > 0) { DatabaseConnection.DoCommand(String.Format("INSERT INTO ML_ATTACHMENT (FILEID,MLID) VALUES ({0},{1})", int.Parse(IDDocument.Text), idml)); } } MailEditor.Visible = false; TableFields.Visible = false; MailList.PageSize = UC.PagingSize; MailList.sqlDataSource = "SELECT * FROM ML_MAIL"; MailList.DataBind(); MailList.Visible = true; FileName.Text = "-1"; } else { ClientScript.RegisterStartupScript(this.GetType(), "nomail", "<script>alert('" + Root.rm.GetString("MLtxt45") + "')</script>"); } }
private void reloadrepeater() { MailList.PageSize = UC.PagingSize; MailList.sqlDataSource = "SELECT * FROM ML_MAIL ORDER BY ID DESC"; MailList.DataBind(); }