private async Task HideRemoveQuestionPanel()
{
GridActions.RotationX = -270;
await GridQuestion.RotateXTo(-90);
GridQuestion.IsVisible = false;
GridActions.IsVisible = true;
await GridActions.RotateXTo(-360);
GridActions.RotationX = 0;
}
private void DataSearch()
{
string strSql = @"SELECT SEQ,QUESTION,ENDTIME,f_getusername(CREUSER) CREUSER,CRETIME,
HOWDO,f_getusername(DOUSER) DOUSER,DOTIME,
(SELECT XMMC FROM PRO_PROJECT WHERE XMBH=A.XMBH) XMMC,
F_GETCODEVALUE('QUESTION_TYPE',QTYPE) QTYPENAME,
F_GETCODEVALUE('QUESTION_LEVEL',QLEVEL) QLEVELNAME,
F_GETCODEVALUE('QUESTION_STATUS',STATUS) STATUSNAME
FROM PRO_QUESTION A WHERE 1=1 ";
string strSearch = "";
if (ddlXMBH.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.XMBH='{0}'", ddlXMBH.SelectedItem.Value);
}
if (lstDOUSER.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.DOUSER='******'", lstDOUSER.SelectedItem.Value);
}
if (lstSTATUS.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.STATUS='{0}'", lstSTATUS.SelectedItem.Value);
}
if (lstCRETIME1.Text.Length > 0 && lstCRETIME2.Text.Length > 0)
{
if (lstCRETIME1.SelectedDate > lstCRETIME2.SelectedDate)
{
Alert.Show("开始日期大于结束日期，请重新输入！");
return;
}
strSearch += string.Format(" AND A.CRETIME>=TO_DATE('{0}','YYYY-MM-DD')", lstCRETIME1.Text);
strSearch += string.Format(" AND A.CRETIME <TO_DATE('{0}','YYYY-MM-DD') + 1", lstCRETIME2.Text);
}
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
GridQuestion.DataSource = DbHelperOra.Query(strSql + " order by to_number(seq) asc ").Tables[0];
GridQuestion.DataBind();
}
