protected override void Initialize()
{
//获取到所拥有这个权限的用户ID
string content = "Advice.Handle";
List <string> accountIDs = AdviceHelper.GetAllReceivers(AdviceTypeID, content);
List <Account> account = new List <Account>();
foreach (string aID in accountIDs)
{
if (aID != "")
{
account.Add(AccountHelper.GetAccount(aID, new string[] { "LoginName", "DepartmentID" }));
}
}
if (SearchTextBox.Text.Trim() != "" && SearchTextBox.Text != null)
{
List <Account> at = new List <Account>();
for (int i = 0; i < account.Count; i++)
{
if (account[i].LoginName == SearchTextBox.Text)
{
at.Add(account[i]);
}
}
DetailGridView.DataSource = at;
}
else
{
DetailGridView.DataSource = account;
}
DetailGridView.DataBind();
UpdateAdviceTag();
}
private void EditingControl_Event(object sender, EventArgs e)
{
if (this.DetailGridView.CurrentCell.ColumnIndex == this.DetailGridView.Columns["centername"].Index && !String.IsNullOrEmpty(((TextBox)sender).Text))
{
this.itemSearch1.SearchType = "Item";
this.itemSearch1.SearchText = ((TextBox)sender).Text;
this.itemSearch1.ControlId = this.DetailGridView.CurrentRow.Index.ToString();//传入行索引
this.itemSearch1.GetSearchData();
if (itemSearch1.Visible == false)
{
int columnIndex = DetailGridView.CurrentCell.ColumnIndex;
int rowIndex = DetailGridView.CurrentCell.RowIndex;
int dgvX = DetailGridView.Location.X;
int dgvY = DetailGridView.Location.Y;
int cellX = DetailGridView.GetCellDisplayRectangle(columnIndex, rowIndex, false).X;
int cellY = DetailGridView.GetCellDisplayRectangle(columnIndex, rowIndex, false).Y;
int cellHeight = DetailGridView.GetCellDisplayRectangle(columnIndex, rowIndex, false).Height;
itemSearch1.Location = new Point(dgvX + cellX, dgvY + cellY + cellHeight);
itemSearch1.Visible = true;
this.itemSearch1.Focus();
}
}
}
protected override void Initialize()
{
TagsGroup ag = TagsHelper.GetTagsGroup();
DetailGridView.DataSource = ag.Items;
DetailGridView.DataBind();
}
void BindListByKeyword()
{
string KeyWord = KeyTextBox.Text;
DateTime BeginDate = DateTime.MinValue;
DateTime EndDate = DateTime.MaxValue;
ArticleQuery q = new ArticleQuery();
q.KeyWord = KeyWord;
q.BeginDate = BeginDate;
q.EndDate = EndDate;
ArticlePager.PageSize = PageSize;
ArticlePager.RecorderCount = ArticleHelper.QueryArtilceCountByAll(q);
if (PageSize > 0)
{
PagerDiv.Visible = (ArticlePager.RecorderCount <= PageSize) ? false : true;
}
List <Article> list = ArticleHelper.QueryArtilcesByAll(q, ArticlePager.Begin, ArticlePager.Count, null);
DetailGridView.DataSource = list;
DetailGridView.DataBind();
MessageLabel.Text = "查询关键字“" + KeyTextBox.Text + "”的结果：";
}
protected override void Initialize()
{
string rawurl = Request.RawUrl;
rawurl = We7Helper.RemoveParamFromUrl(rawurl, "keyword");
string qString = @"<label class=""hidden"" for=""user-search-input"">ËÑË÷{0}:</label>
<input type=""text"" class=""search-input"" id=""KeyWord"" name=""KeyWord"" value="""" onKeyPress=""javascript:KeyPressSearch('{1}',event);"" />
<input type=""button"" value=""ËÑË÷"" class=""button"" id=""SearchButton"" onclick=""javascript:doSearch('{1}');"" />";
qString = string.Format(qString, "À¸Ä¿", rawurl);
SearchSimpleLiteral.Text = qString;
MyChannelList = new ArrayList();
List<Channel> allChannel = null;
if (!string.IsNullOrEmpty(ChannelType) && ChannelType.ToString() == "link")
{
allChannel = ChannelHelper.GetAllLinkChannels();
}
else if (!string.IsNullOrEmpty(ChannelType) && ChannelType.ToString() == "article")
{
allChannel = ChannelHelper.GetChannelByModelName("");
}
else
{
Channel ch = ChannelHelper.GetChannel(ColumnID, null);
string enumState = "";
if (ch != null) enumState = ch.EnumState;
allChannel = ChannelHelper.GetChannelsByType(enumState);
}
if (allChannel != null)
{
GetSubChannels(We7Helper.EmptyGUID, "", allChannel);
}
MyChannelList = FilterByKeyword();
DetailGridView.DataSource = MyChannelList;
DetailGridView.DataBind();
}
public void SortDetailGrid(Object sender, GridViewSortEventArgs e)
{
// Create a DataView from the Credit Detail DataTable.
DataView dv = new DataView((DataTable)Session["CreditDetailTable"]);
dv.Sort = e.SortExpression;
DetailGridView.DataSource = dv;
DetailGridView.DataBind();
}
//Delete Requisition History
protected void detailGridView_Delete(object sender, GridViewDeleteEventArgs e)
{
int reqId = Convert.ToInt32(DetailGridView.DataKeys[e.RowIndex].Values[0]);
Session["sessionID"] = reqId;
EmployeeController.DeleteReqHistory(reqId);
DetailGridView.DataSource = EmployeeController.ViewRequisition(Profile.EmpNo);
DetailGridView.DataBind();
}
protected void DeleteButton_Click(object sender, EventArgs e)
{
Button b = (Button)sender;
int reqId = Convert.ToInt32(b.CommandArgument);
Session["sessionID"] = reqId;
EmployeeController.DeleteReqHistory(reqId);
DetailGridView.DataSource = EmployeeController.ViewRequisition(Profile.EmpNo);
DetailGridView.DataBind();
}
protected void ClearGrids()
{
DateGridView.DataBind();
QuoteGridView.DataBind();
FilterShowingLabel.Text = "";
HeaderUpdatePanel.Update();
DetailGridView.DataBind();
QuoteDetailUpdatePanel.Update();
//UpdateButton.Visible = false;
//UpdateUpdatePanel.Update();
}
protected override void Initialize()
{
ArticleQuery query = new ArticleQuery();
query.ChannelID = ColumnID;
List <Article> data = ArticleHelper.QueryArtilcesByAll(query, 0, 100, null);
DetailGridView.DataSource = data;
DetailGridView.DataBind();
BuildRows();
}
void BindListByFilter()
{
ArticlePager.RecorderCount = ArticleHelper.QueryArticlesCountByTags(Tags);
ArticlePager.PageSize = PageSize;
string[] fields = new string[] { "ID", "Title", "OwnerID", "Description", "Permission" };
List <Article> list = ArticleHelper.QueryArticlesByTags(Tags, ArticlePager.Begin, ArticlePager.Count, fields);
DetailGridView.DataSource = list;
DetailGridView.DataBind();
MessageLabel.Text = "直接匹配标签“" + TagsLabel.Text + "”的结果：";
}
protected override void Initialize()
{
string query = null;
if (SearchTextBox.Text.Length > 0)
{
query = SearchTextBox.Text.Trim();
}
selectLabel.Text = string.Format("选择一个{0}：", InfoKey);
Template[] tps = null;
GeneralConfigInfo si = GeneralConfigs.GetConfig();
if (si.DefaultTemplateGroupFileName != null && si.DefaultTemplateGroupFileName.Length > 0)
{
tps = TemplateHelper.GetTemplates(query, si.DefaultTemplateGroupFileName.Replace(".xml", ""));
}
else
{
tps = TemplateHelper.GetTemplates(query);
}
object dat;
if (Request["list"] == "sub")
{
List <Template> ts = new List <Template>();
foreach (Template tp in tps)
{
if (tp.IsSubTemplate)
{
ts.Add(tp);
}
}
dat = ts;
}
else
{
List <Template> ts = new List <Template>();
foreach (Template tp in tps)
{
if (!tp.IsSubTemplate)
{
ts.Add(tp);
}
}
dat = ts;
}
DetailGridView.DataSource = dat;
DetailGridView.DataBind();
}
protected void QueryButton_Click(object sender, EventArgs e)
{
TagsGroup ag = TagsHelper.GetTagsGroup();
List <TagsGroup.Item> items = new List <TagsGroup.Item>();
foreach (TagsGroup.Item item in ag.Items)
{
if (item.Words.Contains(SearchTextBox.Text.Trim()))
{
items.Add(item);
}
}
DetailGridView.DataSource = items;
DetailGridView.DataBind();
// Initialize();
}
void ShowTempalteGroup()
{
NameTextBox.Text = Data.Name;
DescriptionTextBox.Text = Data.Description;
CreatedLabel.Text = Data.Created.ToString();
FileTextBox.Text = Data.FileName;
DetailGridView.DataSource = Data.Items;
DetailGridView.DataBind();
DetailLabel.Text = String.Format("共有{0}个模板。", Data.Items.Count);
Template[] tps = TemplateHelper.GetTemplates(null, Path.GetFileNameWithoutExtension(FileName));
TempldatesGridView.DataSource = tps;
TempldatesGridView.DataBind();
TempldatesLabel.Text = String.Format("共有{0}个模板文件。", tps.Length);
}
protected void RefreshDetailGrid(DataTable DetailData)
{
DataView lineView = new DataView();
DetailGridView.DataSource = DetailData;
DetailGridView.DataBind();
QuoteDetailUpdatePanel.Update();
Session[DetailTableName.Value] = DetailData;
if (DetailData.Rows.Count > 0)
{
//UpdateButton.Visible = true;
//UpdateUpdatePanel.Update();
}
else
{
ShowPageMessage("No Quote Detail.", 2);
MessageUpdatePanel.Update();
}
}
public void SortDetailGrid(Object sender, GridViewSortEventArgs e)
{
try
{
// Create a DataView from the Quote Detail DataTable.
string LineFilter;
DataView dv = new DataView((DataTable)Session[DetailTableName.Value]);
dv.Sort = e.SortExpression;
DetailSortField.Value = e.SortExpression;
//dv.RowFilter = LineFilter;
DetailGridView.DataSource = dv;
DetailGridView.DataBind();
DetailGridPanel.Height = new Unit(double.Parse(DetailGridHeightHidden.Value), UnitType.Pixel);
DetailGridPanel.Width = new Unit(double.Parse(DetailGridWidthHidden.Value), UnitType.Pixel);
}
catch (Exception e2)
{
ShowPageMessage("Sort Error " + e2.Message + ", " + e2.ToString(), 2);
}
}
protected void Sort(string sortName)
{
string sortText = sortName;
DataControl[] ds = TemplateHelper.SortDataControls(sortText);
DetailGridView.DataSource = ds;
DetailGridView.DataBind();
ModeDataList.DataSource = ds;
ModeDataList.DataBind();
if (ds.Length == 0)
{
ShowMessage("没有符合条件的控件。");
}
else
{
ShowMessage(String.Format("总共 {0} 个控件。", ds.Length));
}
}
protected override void Initialize()
{
string rawurl = Request.RawUrl;
rawurl = We7Helper.RemoveParamFromUrl(rawurl, "keyword");
string qString = @"<label class=""hidden"" for=""user-search-input"">ËÑË÷{0}:</label>
<input type=""text"" class=""search-input"" id=""KeyWord"" name=""KeyWord"" value="""" onKeyPress=""javascript:KeyPressSearch('{1}',event);"" />
<input type=""button"" value=""ËÑË÷"" class=""button"" id=""SearchButton"" onclick=""javascript:doSearch('{1}');"" />";
qString = string.Format(qString, "Àà±ð", rawurl);
SearchSimpleLiteral.Text = qString;
rawurl = We7Helper.GetParamValueFromUrl(rawurl, "type");
CategoryList = new ArrayList();
if (rawurl == "dep")
{
NameLabel.Text = "Ñ¡ÔñÒ»¸ö²¿ÃÅ";
List <Common.PF.Department> allDepartments = null;
allDepartments = AccountHelper.GetDepartments(siteID, We7Helper.EmptyGUID, "", new string[] { "ID", "Title", "Description", "State" });
foreach (Common.PF.Department d in allDepartments)
{
DrawTreeMenu(d, "");
}
CategoryList = FilterByKeyword();
DetailGridView.DataSource = CategoryList;
DetailGridView.Columns[2].Visible = false;
}
else
{
NameLabel.Text = "Ñ¡ÔñÒ»¸öÀà±ð";
List <Category> allCategory = null;
allCategory = CategoryHelper.GetCategoryByParentID(We7Helper.EmptyGUID);
foreach (Category c in allCategory)
{
DrawTreeMenu(c, "");
}
CategoryList = FilterByKeyword();
DetailGridView.DataSource = CategoryList;
}
DetailGridView.DataBind();
}
protected override void Initialize()
{
string root;
if (We7Helper.IsEmptyID(ColumnID))
{
GoParentHyperLink.NavigateUrl = "iChannels.aspx";
root = "";
CurrentUrl = "/";
}
else
{
Channel ch = ChannelHelper.GetChannel(ColumnID, new string[] { "ID", "Name", "Description", "ParentID", "FullPath", "FullUrl" });
CurrentPath = ch.Description;
GoParentHyperLink.NavigateUrl = String.Format("iChannels.aspx?id={0}&oid={1}&type=quote", ch.ParentID, QuoteOwnerID);
root = ch.FullPath;
CurrentUrl = ch.FullUrl;
}
CurrentPath = "根栏目" + root.Replace("/", " / ");
List <Channel> data = ChannelHelper.GetChannels(ColumnID);
if (data == null || data.Count == 0)
{
//ShowMessage("没有数据。");
}
else
{
//ShowMessage(String.Format("总共有 {0}个栏目。", data.Count));
foreach (Channel ch in data)
{
ch.TemplateText = TemplateHelper.GetTemplateName(ch.TemplateName);
ch.FullPath = String.Concat(root, "/", ch.Name);
}
}
DetailGridView.DataSource = data;
DetailGridView.DataBind();
}
public void DetailGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
//DataView dv = new DataView((DataTable)Session[DetailTableName.Value]);
// Create a DataView from the Quote Detail DataTable.
try
{
string LineFilter;
DataView dv = new DataView((DataTable)Session[DetailTableName.Value]);
dv.Sort = DetailSortField.Value;
//dv.RowFilter = LineFilter;
DetailGridView.DataSource = dv;
DetailGridView.PageIndex = e.NewPageIndex;
DetailGridView.DataBind();
DetailGridPanel.Height = Unit.Pixel(int.Parse(DetailGridHeightHidden.Value));
DetailGridPanel.Width = Unit.Pixel(int.Parse(DetailGridWidthHidden.Value));
QuoteDetailUpdatePanel.Update();
}
catch (Exception e2)
{
ShowPageMessage("Paging Error " + DetailGridHeightHidden.Value.ToString() + " : " + e2.ToString(), 2);
}
}
protected override void Initialize()
{
string selectQuery = this.FieldDropDownList.SelectedItem.ToString();
string query = SearchTextBox.Text;
DataControl[] ds = TemplateHelper.GetDataControls(query, selectQuery);
DetailGridView.DataSource = ds;
DetailGridView.DataBind();
ModeDataList.DataSource = ds;
ModeDataList.DataBind();
if (ds.Length == 0)
{
ShowMessage("没有符合条件的控件。");
}
else
{
ShowMessage(String.Format("总共 {0} 个控件。", ds.Length));
}
}
protected void Page_Load(object sender, EventArgs e)
{
int empNo = Profile.EmpNo;
if (!IsPostBack)
{
for (int i = 0; i < DetailGridView.Rows.Count; i++)
{
string check = DetailGridView.Rows[i].Cells[3].Text.ToString();
if (check.Equals("Approved"))
{
DetailGridView.Rows[i].Cells[1].Visible = false;
}
}
string empName = EmployeeController.GetName(empNo);
name.Text = empName;
DetailGridView.Visible = true;
requsition = new List <Requisition>();
reqhistory = new List <ReqHistory>();
DetailGridView.DataSource = EmployeeController.ViewRequisition(empNo);
DetailGridView.DataBind();
}
}
protected void GetDocument(string InvoiceNo, string SONo)
{
try
{
OrderIDHidden.Value = "";
Session["CreditDetailTable"] = null;
ClearPageMessages();
// get the data.
ds = SqlHelper.ExecuteDataset(connectionString, "pSOEGetCreditRGA",
new SqlParameter("@PassedInvoice", InvoiceNo),
new SqlParameter("@PassedOrder", SONo));
if (ds.Tables.Count >= 1)
{
if (ds.Tables.Count == 1)
{
// We only go one table back, something is wrong
dt = ds.Tables[0];
if (dt.Rows[0]["ErrorType"].ToString().Trim() + dt.Rows[0]["ErrorCode"].ToString() == "E0081")
{
ShowPageMessage("Document is on file but is the wrong type", 2);
CreditRGAScriptManager.SetFocus("InvoiceNoTextBox");
return;
}
if (dt.Rows[0]["ErrorType"].ToString().Trim() + dt.Rows[0]["ErrorCode"].ToString() == "E0001")
{
ShowPageMessage("Document not found. " + InvoiceNo + "," + SONo, 2);
CreditRGAScriptManager.SetFocus("InvoiceNoTextBox");
return;
}
if (dt.Rows.Count > 0)
{
ShowPageMessage("GetCreditRGA processing error. " + InvoiceNo + "," + SONo, 2);
return;
}
}
else
{
dt = ds.Tables[1];
if (dt.Rows.Count == 0)
{
HeaderGridView.DataBind();
HeaderUpdatePanel.Update();
DetailGridView.DataBind();
DetailUpdatePanel.Update();
ShowPageMessage("Invoice/Order not found.", 2);
CreditRGAScriptManager.SetFocus("InvoiceNoTextBox");
}
else
{
DetailGridView.DataSource = dt;
DetailGridView.DataBind();
Session["CreditDetailTable"] = dt;
OrderIDHidden.Value = ds.Tables[2].Rows[0]["FoundID"].ToString().Trim();
ShipLocHidden.Value = ds.Tables[2].Rows[0]["ShipLoc"].ToString().Trim();
try
{
RGAReturnToDropDown.SelectedValue = ShipLocHidden.Value.ToString();
}
catch
{
}
ShowMakeButton();
DetailUpdatePanel.Update();
dt = ds.Tables[2];
HeaderGridView.DataSource = dt;
HeaderGridView.DataBind();
HeaderUpdatePanel.Update();
}
}
}
ScriptManager.RegisterClientScriptBlock(InvoiceNoTextBox, InvoiceNoTextBox.GetType(), "SizeUpdate", "SetHeight();", true);
}
catch (Exception e2)
{
ShowPageMessage("GetCreditRGA Error " + e2.Message + ", " + e2.ToString(), 2);
}
}
protected void GetQuotes(string CustNo, string FilterField, string FilterValue, string GridToFill)
{
try
{
// get the quote data.
string FreshQOH = "0";
if (GridToFill == "Detail")
{
FreshQOH = "1";
}
ds = SqlHelper.ExecuteDataset(connectionString, "pSOEGetQuotes",
new SqlParameter("@Organization", CustNo),
new SqlParameter("@QuoteFilterField", FilterField),
new SqlParameter("@QuoteFilterValue", FilterValue),
new SqlParameter("@FreshQOH", FreshQOH));
if (ds.Tables.Count >= 1)
{
dt = ds.Tables[1];
if (dt.Rows.Count == 0)
{
DateGridView.DataBind();
DetailGridView.DataBind();
QuoteGridView.DataBind();
FilterShowingLabel.Text = "";
}
else
{
if (GridToFill == "Header")
{
DataTable dtDates = new DataTable();
dtDates.Columns.Add("QuoteDate", typeof(DateTime));
dtDates.Columns.Add("QuoteCount", typeof(int));
int DateCtr = 0;
string Lastdate = "";
string Newdate = "";
string LastQuote = "";
string NewQuote = "";
DataRow daterow;
CustNameLabel.Text = dt.Rows[0]["CustomerName"].ToString();
Session["MasterTable"] = dt;
Lastdate = string.Format("{0:yyyy-MM-dd}", dt.Rows[0]["QuotationDate"]);
DateToGet = string.Format("{0:MM/dd/yyyy}", dt.Rows[0]["QuotationDate"]);
foreach (DataRow drow in dt.Rows)
{
Newdate = string.Format("{0:yyyy-MM-dd}", drow["QuotationDate"]);
NewQuote = drow["SessionID"].ToString();
if (Newdate != Lastdate)
{
daterow = dtDates.NewRow();
daterow["QuoteDate"] = Lastdate;
daterow["QuoteCount"] = DateCtr;
dtDates.Rows.Add(daterow);
Lastdate = Newdate;
DateCtr = 0;
}
if (NewQuote != LastQuote)
{
DateCtr++;
LastQuote = NewQuote;
}
}
daterow = dtDates.NewRow();
daterow["QuoteDate"] = Newdate;
daterow["QuoteCount"] = DateCtr;
dtDates.Rows.Add(daterow);
DateGridView.DataSource = dtDates;
DateGridView.DataBind();
FillGridView(dt);
DetailGridView.DataBind();
}
if (GridToFill == "Detail")
{
DetailGridView.DataSource = dt;
DetailGridView.DataBind();
}
//QuoteUpdatePanel.Update();
//DataView dv = new DataView(dt, "SubItem = '" + ItemNo + "'", "", DataViewRowState.CurrentRows);
//AltAvailLabel.Text = String.Format("{0:#,##0}", dv[0]["AltQOH"]);
}
}
}
catch (Exception e2)
{
ErrorLabel.Text = e2.Message + ", " + e2.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
DetailGridView.DataSource = GetDepartmentList();
DetailGridView.DataBind();
}
