/// <summary> /// 开启 /// </summary> private void BtnStart_Click(object sender, EventArgs e) { var selectRows = this.GirdCard.GetSelectedRows(); if (selectRows.Length < 1) { throw new Exception("当前没有选中行!"); } if (MsgBox.ShowYesNoMsg("确定打开所选流转卡?") != DialogResult.Yes) { return; } List <CardMain> cards = new List <CardMain>(); foreach (int i in this.GirdCard.GetSelectedRows()) { var cardm = ConvertToModel.DataRowToModel <CardMain>(GirdCard.GetDataRow(i)); cards.Add(cardm); } dal.SetPauseStatus(false, null, cards.ToArray()); //刷新 this.ExecQuery(); }
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (e.FocusedRowHandle > -1) { CardMain cardm = ConvertToModel.DataRowToModel <CardMain>(GirdCard.GetFocusedDataRow()); gridControl2.DataSource = dal.GetDetailList(cardm.CardNo); gridControl3.DataSource = dal.GetChildList(cardm.CardNo); } else { gridControl2.DataSource = null; gridControl3.DataSource = null; } }
private void BtnDelCard_Click(object sender, EventArgs e) { #region 除流转卡 if (MsgBox.ShowYesNoMsg("确定删除选定的流转卡?") != DialogResult.Yes) { return; } StringBuilder sb = new StringBuilder(); foreach (int handle in this.GirdCard.GetSelectedRows()) { string[] wheres = new string[] { "cardNo = @cardNo" }; var card = ConvertToModel.DataRowToModel <CardMain>(GirdCard.GetDataRow(handle)); //引用校验 dal.ExistRef(card.CardNo); if (card.curOpSeq != "0010") { sb.Append("流转卡" + card.CardNo + "已经报工,不能删除! \r\n"); } else { dal.Delete(card.CardNo); } } if (sb.ToString() == "") { sb.Append("删除成功!"); } MsgBox.ShowInfoMsg(sb.ToString()); this.BtnReflash_Click(null, null); #endregion }
public InvMould Get(string guid) { StringBuilder sb = new StringBuilder(); sb.Append("select *, inv.cInvName, inv.cInvStd, unit.cComUnitName from InvMould t1 "); sb.Append(" join " + ufdb + "..Inventory inv on t1.cInvCode = inv.cInvCode"); sb.Append(" join " + ufdb + "..ComputationUnit unit on unit.cComUnitCode = inv.cComUnitCode"); sb.Append(" where t1.guid = @guid"); SqlParameter p = new SqlParameter("@guid", guid); DataRow row = DbHelperSQL.Query(sb.ToString(), p).Tables[0].Rows[0]; var model = ConvertToModel <InvMould> .DataRowToModel(row); model.dtMouldEq = GetDTBody(guid); return(model); }