protected void Page_Load(object sender, EventArgs e)
{
((MasterPage)Page.Master).imp = "class=\"active\"";
var pageNum = 1;
try {
if (!string.IsNullOrEmpty(Request.QueryString["Page"]))
{
pageNum = Convert.ToInt32(Request.QueryString["Page"]);
}
}
catch (Exception ex) {
pageNum = 1;
}
var sql = "select row_number() over(order by PIID DESC) as rownum, * from ProfInfo where Status=1";
Pager11.GetDataBind("Repeater", "rptList", sql, pageNum, 5, " ", "rownum", "Expert.aspx?");
}
protected void Page_Load(object sender, EventArgs e)
{
((MasterPage)Page.Master).org = "class=\"active\"";
//rptCom.DataSource = _comInfoDal.GetList(" Status=1 order by CreateDate desc ", new List<SqlParameter>()).Tables[0];
//rptCom.DataBind();
var pageNum = 1;
try {
if (!string.IsNullOrEmpty(Request.QueryString["Page"]))
{
pageNum = Convert.ToInt32(Request.QueryString["Page"]);
}
}
catch (Exception ex) {
pageNum = 1;
}
var sql = "select row_number() over(order by OID DESC) as rownum, * from ProfOrg where Status=1";
Pager11.GetDataBind("Repeater", "rptList", sql, pageNum, 6, " ", "rownum", "Mechanism.aspx?");
}
protected void Page_Load(object sender, EventArgs e)
{
((MasterPage)Page.Master).imp = "class=\"active\"";
//rptCom.DataSource = _comInfoDal.GetList(" Status=1 order by CreateDate desc ", new List<SqlParameter>()).Tables[0];
//rptCom.DataBind();
var pageNum = 1;
try {
if (!string.IsNullOrEmpty(Request.QueryString["Page"]))
{
pageNum = Convert.ToInt32(Request.QueryString["Page"]);
}
}
catch (Exception ex) {
pageNum = 1;
}
var sql = "select row_number() over(order by CreateDate DESC) as rownum, AdvisoryList.*,OrgEmployees.EmplName from AdvisoryList JOIN OrgUsers ON OrgUsers.UId = AdvisoryList.UId JOIN OrgEmployees ON OrgEmployees.EmplId = OrgUsers.EmplId where AdvisoryList.Status=1 and AdvisoryList.MType=0";
Pager11.GetDataBind("Repeater", "rptList", sql, pageNum, 5, " ", "rownum", "Message.aspx?");
}
protected void Page_Load(object sender, EventArgs e)
{
((MasterPage)Page.Master).index = "class=\"active\"";
var pageNum = 1;
try {
if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断
{
pageNum = Convert.ToInt32(Request.QueryString["Page"]);
}
}
catch (Exception ex) {
pageNum = 1;
}
var sql = "select row_number() over(order by dbo.CMArticle.AddTime DESC) as rownum, dbo.CMArticle.* from dbo.CMArticle join dbo.CMColumn ON CMColumn.ColId = CMArticle.ColId where CMArticle.Status=1 AND CMColumn.ColName='客户评价'";
Database db = DatabaseFactory.CreateDatabase();
var sqlCount = "select count(*) from dbo.CMArticle join dbo.CMColumn ON CMColumn.ColId = CMArticle.ColId where CMArticle.Status=1 AND CMColumn.ColName='客户评价'";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCount);
object obj = db.ExecuteScalar(dbCommand);
Literal1.Text = obj.ToString();
Pager11.GetDataBind("Repeater", "rptList", sql, pageNum, 6, " ", "rownum", "CMessage.aspx?");
}
protected void GridView1NmaeNiHao_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "LinkbtnXinxi")
{
int docTpyeId = Convert.ToInt32(QueryInStorageBLL.GetDocTypeIDEByDocTypeCode("RK")); //入库单
int docTpyeId1 = Convert.ToInt32(QueryInStorageBLL.GetDocTypeIDEByDocTypeCode("BY")); //报溢单
int docTpyeId2 = Convert.ToInt32(QueryInStorageBLL.GetDocTypeIDEByDocTypeCode("TH")); //退货单
int docTypeId3 = Convert.ToInt32(QueryInStorageBLL.GetDocTypeIDEByDocTypeCode("DB")); //调拨单
string sqlSQL_WareHouseID = "";
if (this.ddlWareHouse.SelectedValue != "-1")
{
sqlSQL_WareHouseID = " and M.warehouseID=" + this.ddlWareHouse.SelectedValue + " and M.DepotSeatID=" + this.ddlDepotSeat.SelectedValue;
}
this.Panel1.Visible = false;
this.Panel2.Visible = true;
this.btn.Visible = false;
// this.Button2.Visible = true;
StringBuilder sb = new StringBuilder();
sb.Append("SELECT D.ProductID, P.ProductName, D.ProductQuantity, D.UnitPrice,D.ProductTotal, M.DocAuditTime, M.Provider, M.DocAuditer,M.Note, M.BatchCode,U.ProductUnitName as UnitName, case M.DocTypeID when 1 then '" + GetTran("000579", "入库单") + "' when 4 then '" + GetTran("000584", "报溢单") + "' when 15 then '" + GetTran("000583", "退货单") + "' when 9 then '" + GetTran("000581", "调拨单") + "' else '' end as DocType ");
sb.Append("D.ProductTotal, M.DocAuditTime, M.Provider, M.DocAuditer,");
sb.Append("M.Note, M.BatchCode,U.ProductUnitName as UnitName ");
sb.Append("FROM InventoryDocDetails D INNER JOIN ");
sb.Append("Product P ON D.ProductID = P.ProductID INNER JOIN ");
sb.Append("InventoryDoc M ON D.DocID = M.DocID " + sqlSQL_WareHouseID);
sb.Append(" left outer join ProductUnit U on P.SmallProductunitID = U.ProductUnitID ");
sb.Append(" WHERE P.Countrycode=" + System.Convert.ToInt32(this.DropDownList1.SelectedValue) + " and (M.DocTypeID =" + docTpyeId + " or M.DocTypeID=" + docTpyeId1 + " or M.DocTypeID=" + docTpyeId2 + " or M.DocTypeID=" + docTypeId3 + ") And StateFlag='1' And CloseFlag='0' And DATEADD(day, DATEDIFF(day,0,M.DocAuditTime ), 0) between '" + this.TextBox2.Text + "' and '" + this.TextBox3.Text + "'");
GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
string PrID = ((HtmlInputHidden)row.FindControl("hidPrID")).Value;
ViewState["PrID"] = PrID;
sb.Append(" and D.ProductID=" + PrID);
string table = "InventoryDocDetails as D, Product as P,InventoryDoc as M,ProductUnit as U";
StringBuilder sb3 = new StringBuilder();
sb3.Append("D.ProductID = P.ProductID and P.SmallProductunitID = U.ProductUnitID and D.DocID = M.DocID and M.WareHouseID=" + this.ddlWareHouse.SelectedValue + " and M.DepotSeatID=" + this.ddlDepotSeat.SelectedValue);
sb3.Append(" and P.Countrycode=" + System.Convert.ToInt32(this.DropDownList1.SelectedValue) + " and (M.DocTypeID =" + docTpyeId + " or M.DocTypeID=" + docTpyeId1 + "or M.DocTypeID=" + docTpyeId2 + " or M.DocTypeID=" + docTypeId3 + ") And StateFlag='1' And CloseFlag='0' And DATEADD(day, DATEDIFF(day,0,M.DocAuditTime ), 0) between '" + this.TextBox2.Text + "' and '" + this.TextBox3.Text + "'" + " and D.ProductID=" + PrID);
string key = "D.DocDetailsID";
string cloumns = " D.ProductID, P.ProductName, D.ProductQuantity, D.UnitPrice,D.ProductTotal, M.DocAuditTime, M.Provider, M.DocAuditer,M.Note, M.BatchCode,U.ProductUnitName as UnitName, case M.DocTypeID when 1 then '" + GetTran("000579", "入库单") + "' when 4 then '" + GetTran("000584", "报溢单") + "' when 15 then '" + GetTran("000583", "退货单") + "' when 9 then '" + GetTran("000581", "调拨单") + "' else '' end as DocType";
// Pager pagerT = Page.FindControl("Pager11") as Pager;
Pager11.Pageindex = 0;
Pager11.PageSize = 10;
Pager11.PageTable = table;
Pager11.Condition = sb3.ToString();
Pager11.PageColumn = cloumns;
Pager11.ControlName = "GridView2";
Pager11.key = key;
Pager11.PageCount = 0;
Pager11.PageBind1();
// if (Pager11.PageCount > 0)
// {
this.Button2.Visible = true;
this.img2.Style.Add("display", "block");
this.btn.Visible = false;
this.img1.Style.Add("display", "none");
// }
ViewState["dt1"] = "Select " + cloumns + " From " + table + " Where " + sb3.ToString() + " Order By D.DocDetailsID";
}
Translations2();
}
