protected void GridList_RowDoubleClick(object sender, FineUIPro.GridRowClickEventArgs e)
{
string strBillNo = GridList.Rows[e.RowIndex].Values[1].ToString();
ToolbarBillno.Text = strBillNo;
string strSql = @"SELECT NULL MEMO,A.SEQNO,B.ROWNO,A.GDSEQ,A.GDNAME,B.GDSEQ GDSEQ_EAS,F_GETUNITNAME(A.UNIT) UNIT,B.UNIT UNIT_EAS,A.GDSPEC,B.GDSPEC GDSPEC_EAS,A.DHS,B.DHS DHS_EAS
FROM DAT_DD_COM A LEFT JOIN DAT_DD_COM_COMPARE B ON A.SEQNO=B.SEQNO AND A.GDSEQ=B.GDSEQ
WHERE A.SEQNO='" + strBillNo + "'";
DataTable dt = DbHelperOra.Query(strSql).Tables[0];
string GreenRowsList = "";
string RedRowsList = "";
foreach (DataRow dr in dt.Rows)
{
string strGDSEQ = dr["GDSEQ"].ToString();
string strGDSEQ_EAS = "";
if (dr["GDSEQ_EAS"] != null && !"".Equals(dr["GDSEQ_EAS"].ToString()))
{
strGDSEQ_EAS = dr["GDSEQ_EAS"].ToString();
}
else
{
dr["MEMO"] = "ERP有EAS没有";
continue;//如果GDSEQ_EAS是null，表明表体中少商品，用默认白色标注
}
string strUNIT = dr["UNIT"].ToString();
string strUNIT_EAS = dr["UNIT_EAS"].ToString();
string strGDSPEC = dr["GDSPEC"].ToString();
string strGDSPEC_EAS = dr["GDSPEC_EAS"].ToString();
Decimal DHS = Convert.ToDecimal(dr["DHS"]);
Decimal DHS_EAS = Convert.ToDecimal(dr["DHS_EAS"]);
if (strGDSEQ.Equals(strGDSEQ_EAS) && DHS == DHS_EAS)
{
dr["MEMO"] = "完全匹配";
GreenRowsList += dt.Rows.IndexOf(dr).ToString() + ",";
}
else
{
dr["MEMO"] = "字段不匹配";
RedRowsList += dt.Rows.IndexOf(dr).ToString() + ",";
}
}
GridDetail.DataSource = dt;
GridDetail.DataBind();
PageContext.RegisterStartupScript("onGridDataLoad('" + RedRowsList + "','" + GreenRowsList + "','" + GridDetail.ClientID + "');");
}
public static void HandleEditableGridItemCreated(BasePage page, RadGrid Grid, CodeTorch.Core.Grid GridConfig, List <Section> Sections, string SectionZoneLayout, bool DisplayAddButton, object source, GridItemEventArgs e)
{
if (e.Item is GridCommandItem)
{
if (!DisplayAddButton)
{
GridFunctions.HideAddCommandItem(Grid);
}
}
if (e.Item is GridEditFormItem && e.Item.IsInEditMode)
{
Control c = page.FindControlRecursive(e.Item, GridEditFormItem.EditFormUserControlID);
if (c != null)
{
GridDetail detail = ((GridDetail)c);
detail.Sections = Sections;
detail.SectionZoneLayout = SectionZoneLayout;
if (e.Item.OwnerTableView.IsItemInserted)
{
detail.Mode = SectionMode.Insert;
detail.Render();
detail.SetSaveButtonToInsertMode();
detail.SettingSectionTitle("Add");
}
else
{
detail.Mode = SectionMode.Edit;
detail.Render();
detail.SetSaveButtonToUpdateMode();
detail.SettingSectionTitle("Edit");
}
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【录入日期】！");
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("开始日期大于结束日期，请重新输入！");
return;
}
string strSql = @"SELECT NULL MEMO,BILLNO,XDRQ,NULL XDRQ_EAS,SUBNUM,NULL SUBNUM_EAS,SUBSUM,NULL SUBSUM_EAS,(select VALUE from sys_para where code='USERCODE') CUSTID,SHR,SHRQ
from DAT_DD_DOC WHERE issend='Y' ";
string strSearch = "";
if (!String.IsNullOrEmpty(txtBillNo.Text.Trim()))
{
strSearch += string.Format(" AND BILLNO LIKE '%{0}%'", txtBillNo.Text);
ViewState["dhd_billno"] = txtBillNo.Text;
}
DateTime lrrq1Value = (DateTime)lstLRRQ1.SelectedDate;
DateTime lrrq2Value = (DateTime)lstLRRQ2.SelectedDate;
strSearch += string.Format(" AND XDRQ>=TO_DATE('{0}','YYYY-MM-DD')", lrrq1Value.ToString("yyyy-MM-dd"));
strSearch += string.Format(" AND XDRQ <TO_DATE('{0}','YYYY-MM-DD') + 1", lrrq2Value.ToString("yyyy-MM-dd"));
ViewState["beginDate1"] = lrrq1Value.ToString("yyyy-MM-dd");
ViewState["endDate1"] = lrrq2Value.ToString("yyyy-MM-dd");
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY BILLNO ";
GridList.DataSource = DbHelperOra.Query(strSql).Tables[0];
GridList.DataBind();
GridDetail.DataSource = null;
GridDetail.DataBind();
}
private static void HandleEditableGridDetailPopulation(BasePage page, CodeTorch.Core.Grid GridConfig, bool UseDefaultCommand, string DefaultCommandName, GridItemEventArgs e)
{
if (e.Item is GridEditFormItem && e.Item.IsInEditMode)
{
Control c = page.FindControlRecursive(e.Item, GridEditFormItem.EditFormUserControlID);
if (c != null)
{
GridDetail detail = ((GridDetail)c);
if (e.Item.OwnerTableView.IsItemInserted)
{
if (UseDefaultCommand)
{
if (!String.IsNullOrEmpty(DefaultCommandName))
{
DataCommandService dataCommandDB = DataCommandService.GetInstance();
PageDB pageDB = new PageDB();
List <ScreenDataCommandParameter> parameters = pageDB.GetPopulatedCommandParameters(DefaultCommandName, page);
DataTable data = dataCommandDB.GetDataForDataCommand(GridConfig.SelectDataCommand, parameters);
detail.Default(e.Item, data);
}
}
}
else
{
DataRowView data = ((DataRowView)detail.DataItem);
detail.Populate(e.Item);
}
detail.ExecuteAfterPopulateSections();
}
}
}
