private void DataGridDataBind()
{
string connStr = WebConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
string sqlText = "select ID,Title,Style,Type,IssueDate from tbNews where IssueDate='" + Request["dateValue"] + "'";
//string sqlText = "select ID,Title,Style,Type,IssueDate from tbNews where IssueDate='" + "2006-03-28" + "'";
SqlConnection conn = new SqlConnection();
SqlDataAdapter adapter = new SqlDataAdapter(sqlText, connStr);
DataTable tbl = new DataTable();
adapter.Fill(tbl);
try
{
if (tbl.Rows.Count == 0)
{
Response.Write("您指定的日期没有发布任何新闻");
} // end if
else
{
MyDataView.DataSource = tbl;
MyDataView.DataBind();
} // end else
} // end try
catch (Exception ex)
{
Response.Write(ex.Message);
} // end catch
} // end method DataGridDataBind
private void myEditTreeView1_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e)
{
String id = myEditTreeView1.FieldValue.ToString(); //单品ID
String sql = "select *,(SELECT F_NAME FROM CK_COMPANY WHERE F_ID=F_COMPANYID)as F_COMPANYNAME from [CK_PRODUCT] where F_PROTYPE=" + id; //用于查询这个商品的全部信息
IAdapter iad = (IAdapter)iapplication.GetService(typeof(IAdapter));
DataTable ntable = (DataTable)iad.RunCmdnoCheck("AFunction2", new object[] { sql });
if (ntable.Rows.Count > 0)
{
MyDataView mdv = new MyDataView();
mdv.SetKey("f_id");
foreach (DataRow dr in ntable.Rows)
{
mdv.SelectedRows.Add(dr["f_id"].ToString(), dr);
}
mdv.iapplication = iapplication;
FormProductInfo fpdi = new FormProductInfo(iapplication, mdv, listView1, ntable, MyRealAmount, MyOrderNumber.FieldValue.ToString());
fpdi.ShowForm(FormType.Edit);
}
else
{
MessageBox.Show("商品信息不完整, 请到商品管理进行设置!");
}
}
public MyDataCell(EventListingItem myData, string identKey) : base(UITableViewCellStyle.Default, identKey)
{
_myDataView = new MyDataView(myData);
ContentView.Add(_myDataView);
}
