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