//private void proDatable(DataTable dt) //{ // foreach (DataRow dr in dt.Rows) // { // dr["SendName"]=GetFHStatus(dr["FormNo"].ToString(),dr["ItemCode"].ToString(),dr["ColorNum"].ToString(),dr["ColorName"].ToString()); // } //} //private string GetFHStatus(string p_FormNo, string p_ItemCode, string p_ColorNum, string p_ColorName) //{ // string sql = "SELECT * FROM UV1_WH_IOFormDts WHERE DtsSO="+SysString.ToDBString(p_FormNo); // sql += " AND ItemCode="+SysString.ToDBString(p_ItemCode); // sql += " AND ColorNum="+SysString.ToDBString(p_ColorNum); // sql += " AND ColorName="+SysString.ToDBString(p_ColorName); // sql += " AND ISNULL(SubmitFlag,0)=1"; // sql += " AND SubType in (SELECT ID FROM Enum_FormList WHERE ParentID=12)"; // DataTable dt = SysUtils.Fill(sql); // if (dt.Rows.Count > 0) // { // return "已发货"; // } // else // { // return "未发货"; // } //} /// <summary> /// 删除 /// </summary> public override void EntityDelete() { FHFormRule rule = new FHFormRule(); FHForm entity = EntityGet(); rule.RDelete(entity); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { FHFormRule rule = new FHFormRule(); gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag")); gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { FHFormRule rule = new FHFormRule(); DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SendName", "'' SendName")); proDatable(dt); //if (chkStatus.Checked) //{ // proDatable(dt); //} gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }