//------------------ Methods ------------------------------- public void Clear() { txtDate.Text = ""; txtDepartment.Text = ""; txtMRNo.Text = ""; txtRemarks.Text = ""; txtReqestBy.Text = ""; txtType.Text = ""; bindItemList.DataSource = null; objMR = null; try { if (rbInitial.Checked) { bindMRList.DataSource = objMRDL.GetMR_ToBatch(CurrentUser.UserID, MR.Status.Initial, MR.Origin.ToBatch); } else if (rbApproved.Checked) { bindMRList.DataSource = objMRDL.GetMR_ToBatch(CurrentUser.UserID, MR.Status.Approved, MR.Origin.ToBatch); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public long Add_M(MR obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRStore", obj.MRStore.StoreID), new SqlParameter("@MREnterdBy", obj.MREnterdBy), new SqlParameter("@MRFromDepId", obj.MRDepartmentFrom.DepID), new SqlParameter("@MRRemarks", obj.MRRemarks), new SqlParameter("@MRStatus", obj.MRStatus), new SqlParameter("@MRType", obj.MRType), new SqlParameter("@OriginType", obj.OriginType), new SqlParameter("@outParam", SqlDbType.Int) { Direction = ParameterDirection.Output } }; return(Execute.RunSP_Output(Connection, "SPADD_MR_M", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
/// <summary> /// To model /// </summary> /// <param name="pObj"></param> /// <returns></returns> public MMRs ToModel(MR pObj) { try { var _model = new MMRs { ACOD = pObj.AssetCode, AGRP = pObj.AssetGroup, AIID = pObj.AssetItemId, ANAM = pObj.AssetName, BUNT = pObj.BusinessUnit, DPRT = pObj.Department, EMID = pObj.EmployeeId, FNAM = pObj.FirstName, LNAM = pObj.LastName, MRID = pObj.MRId, PSTN = pObj.Position, RMRK = pObj.Remarks, SNAM = pObj.SerialNumber, TDAT = pObj.TransDate, ASTA = pObj.AssetStatus }; return(_model); } catch (Exception ex) { throw ex; } }
public ActionResult GenerateGraph() { SqlConnection con = new SqlConnection("Data Source=(localdb)\\mssqllocaldb; Initial Catalog=Map;Integrated Security=true"); con.Open(); SqlCommand da = new SqlCommand(@"SELECT COUNT(Distinct AspNetUsers.Id) AS m FROM AspNetUsers, Mandats where Mandats.Ressource_Id = AspNetUsers.Id", con); MR obj2 = new MR(); int ressmandat = (Int32)da.ExecuteScalar(); SqlCommand di = new SqlCommand(@"SELECT COUNT (AspNetUsers.Id) AS i FROM AspNetUsers WHERE AspNetUsers.Discriminator = 'Ressource'", con); int ress = (Int32)di.ExecuteScalar(); int ressinter = ress - ressmandat; obj2.ressmandat = ressmandat; obj2.ressinter = ressinter; return(Json(obj2, JsonRequestBehavior.AllowGet)); }
//------------------ Methods ------------------------------- public void Clear() { txtDate.Text = ""; txtDepartment.Text = ""; txtMRNo.Text = ""; txtRemarks.Text = ""; txtReqestBy.Text = ""; txtType.Text = ""; bindItemList.DataSource = null; objMR = null; try { Department objDep = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue)); if (rbInitial.Checked) { bindMRList.DataSource = objMRDL.GetMR_ToDep_or_ToStore(objDep.DepID, MR.Status.Initial, MR.Origin.ToBatch); } else if (rbApproved.Checked) { bindMRList.DataSource = objMRDL.GetMR_ToDep_or_ToStore(objDep.DepID, MR.Status.Approved, MR.Origin.ToBatch); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void gvMRList_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex >= 0) { bindItemList.DataSource = null; long MRNO = Convert.ToInt64(gvMRList.Rows[e.RowIndex].Cells[0].Value); MR objMRTemp = objMRDL.Get(MRNO); objMR = new MR(); objMR = objMRTemp; txtDate.Text = objMRTemp.MRDate.ToShortDateString(); txtDepartment.Text = objMRTemp.MRDepartmentFrom.DepName; txtMRNo.Text = objMRTemp.MRNO.ToString(); txtRemarks.Text = objMRTemp.MRRemarks; txtReqestBy.Text = objMRTemp.MREnterdBy; txtType.Text = objMRTemp.MRType.ToString(); if (objMR.MRType == MR.Type.Material) { bindItemList.DataSource = objMRMaterialDL.GetDataView(objMRTemp.MRNO); } else { bindItemList.DataSource = objMRBasicProductDL.GetDataView(objMRTemp.MRNO); } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 根据客户ID查询病历列表 /// </summary> public List <MR> getMRsByClientId(int clientId) { SQLiteCommand cmd = new SQLiteCommand(); cmd.Connection = this.conn; string sql = "select * from t_mr where clientId = " + clientId + " order by date1 desc"; Console.WriteLine(sql); cmd.CommandText = sql; SQLiteDataReader reader = cmd.ExecuteReader(); List <MR> objs = new List <MR>(); while (reader.Read()) { MR obj = new MR(); obj.id = reader.GetInt32(0); obj.clientId = reader.GetInt32(1); obj.mr = reader.GetString(2); obj.addTime = reader.GetString(3); obj.date1 = reader.GetString(4); obj.doctor = reader.GetString(5); objs.Add(obj); } return(objs); }
/// <summary> /// To binding /// </summary> /// <param name="pObj"></param> /// <returns></returns> public MR ToBinding(MMRs pObj) { try { var _binding = new MR { AssetCode = pObj.ACOD, AssetGroup = pObj.AGRP, AssetItemId = pObj.AIID, AssetName = pObj.ANAM, BusinessUnit = pObj.BUNT, Department = pObj.DPRT, EmployeeId = pObj.EMID, FirstName = pObj.FNAM, LastName = pObj.LNAM, MRId = pObj.MRID, Position = pObj.PSTN, Remarks = pObj.RMRK, SerialNumber = pObj.SNAM, TransDate = pObj.TDAT, AssetStatus = pObj.ASTA }; return(_binding); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据id查找病历记录 /// </summary> public MR getMR(string id) { SQLiteCommand cmd = new SQLiteCommand(); cmd.Connection = this.conn; string sql = "select * from t_mr where id = " + id; Console.WriteLine(sql); cmd.CommandText = sql; SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { MR obj = new MR(); obj.id = reader.GetInt32(0); obj.clientId = reader.GetInt32(1); obj.mr = reader.GetString(2); obj.addTime = reader.GetString(3); obj.date1 = reader.GetString(4); obj.doctor = reader.GetString(5); return(obj); } else { return(null); } }
private void FillBOMModelSub(DataGridViewRow pGvr, short pBOMTypeCode) { //string colName=pGvr.Cells[0].OwningColumn.HeaderText; bool isAdd = false; for (int i = 0; i < pGvr.Cells.Count; i++) { //if (pGvr.Cells[i].Value == null || pGvr.Cells[i].Value == DBNull.Value || String.IsNullOrWhiteSpace(pGvr.Cells[i].Value.ToString())) if (pGvr.Cells[i].Value == null) { isAdd = false; } else { isAdd = true; break; } } if (isAdd == true) { MR lObjBom = new MR(); //lObjBom.BOMCode = (string)pGvr.Cells[0].Value; lObjBom.MRVersionId = _maxMRVersionAutoRowId; //lObjBom.ProjectCode = _currentLoadedProject.ProjectCode; var cellObj = pGvr.Cells["Sr" + pBOMTypeCode]; lObjBom.Sr = (cellObj.Value == null) ? string.Empty : cellObj.Value.ToString(); cellObj = pGvr.Cells["PartNo" + pBOMTypeCode]; lObjBom.PartNo = (cellObj.Value == null) ? string.Empty : cellObj.Value.ToString(); cellObj = pGvr.Cells["Description" + pBOMTypeCode]; lObjBom.Description = (cellObj.Value == null) ? string.Empty : cellObj.Value.ToString(); cellObj = pGvr.Cells["Manufacturer" + pBOMTypeCode]; lObjBom.Manufacturer = (cellObj.Value == null) ? string.Empty : cellObj.Value.ToString(); cellObj = pGvr.Cells["Qty" + pBOMTypeCode]; lObjBom.Qty = (cellObj.Value == null) ? string.Empty : cellObj.Value.ToString(); cellObj = pGvr.Cells["UnitCost" + pBOMTypeCode]; lObjBom.UnitCost = (cellObj.Value == null) ? string.Empty : cellObj.Value.ToString(); cellObj = pGvr.Cells["ExtCost" + pBOMTypeCode]; lObjBom.ExtCost = (cellObj.Value == null) ? string.Empty : cellObj.Value.ToString(); cellObj = pGvr.Cells["UnitPrice" + pBOMTypeCode]; lObjBom.UnitPrice = (cellObj.Value == null) ? string.Empty : cellObj.Value.ToString(); cellObj = pGvr.Cells["ExtPrice" + pBOMTypeCode]; lObjBom.ExtPrice = (cellObj.Value == null) ? string.Empty : cellObj.Value.ToString(); _LstObjBoms.Add(lObjBom); //pProjectModel.MRs.Add(lObjBom); } //return null; }
public int Update(MR obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRStore", obj.MRStore.StoreID), new SqlParameter("@MRDate", obj.MRDate), new SqlParameter("@MRApprovedBy", obj.MRApprovedBy), new SqlParameter("@MRApproveDate", obj.MRApprovedDate), new SqlParameter("@MREnterdBy", obj.MREnterdBy), new SqlParameter("@MRFromDepId", obj.MRDepartmentFrom.DepID), new SqlParameter("@MRIssuedBy", obj.MRIssuedBy), new SqlParameter("@MRIssuedDate", obj.MRIssuedDate), new SqlParameter("@MRReceivedBy", obj.MRReceivedBy), new SqlParameter("@MRReceivedDate", obj.MRReceivedDate), new SqlParameter("@MRRemarks", obj.MRRemarks), new SqlParameter("@MRStatus", obj.MRStatus), new SqlParameter("@MRType", obj.MRType), new SqlParameter("@Original_MRNO", obj.MRNO) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MR", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
void Cell_Tapping(object sender, MR.Gestures.TapEventArgs e) { var vm = (ListOfObjectsViewModel)BindingContext; var item = (GestureSample.ViewModels.ListOfObjectsViewModel.TextAndImage)((ImageCell)sender).BindingContext; vm.Item = item; vm.AddText("ImageCellXaml.Cell_Tapping method called on cell '" + item.Text + "' " + e.NumberOfTaps + " times"); }
protected void MakeReport(string message) { this.Invoke((Action)(delegate() { MR.AppendText(message + "\r\n"); })); }
private void Load_MRItem() { if (gvMRList.SelectedRows.Count > 0) { try { //if (e.RowIndex >= 0) { bindItemList.DataSource = null; long MRNO = Convert.ToInt64(gvMRList.SelectedRows[0].Cells["MRNO"].Value); MR objMRTemp = objMRDL.Get(MRNO); objMR = new MR(); objMR = objMRTemp; DataTable dt = new DataTable(); if (objMRTemp.MRType == MR.Type.Material) { dt = objMRMaterialDL.GetDataView(objMRTemp.MRNO); } if (objMRTemp.MRType == MR.Type.BasicProduct) { dt = objMRBasicProduct_DL.GetBasicProductList(objMRTemp.MRNO); } if (objMRTemp.MRType == MR.Type.FinishProduct) { dt = objMRFinishProduct_DL.GetData_View(objMRTemp.MRNO); } if (dt.Rows.Count > 0) { bindItemList.DataSource = dt; gvItemList.AutoGenerateColumns = false; gvItemList.DataSource = bindItemList; bindItemList.ResetBindings(true); } else { bindItemList.DataSource = null; gvItemList.AutoGenerateColumns = false; gvItemList.DataSource = bindItemList; bindItemList.ResetBindings(true); } txtDepartment.Text = objMR.MRDepartmentFrom.DepName; ItemSelect = true; } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void gvMRList_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex >= 0) { bindItemList.DataSource = null; long MRNO = Convert.ToInt64(gvMRList.Rows[e.RowIndex].Cells["MRNO"].Value); MR objMRTemp = objMRDL.Get(MRNO); objMR = new MR(); objMR = objMRTemp; Load_MRItem(); txtDepartment.Text = objMR.MRDepartmentFrom.DepName; ItemSelect = true; Section_DL objSectionDL = new Section_DL(ConnectionStringClass.GetConnection()); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void Awake() { vab = gameObject.AddComponent <VAButton>(); vab.r_downable = MR.SR(TouchArea); vab.doClamp = true; vab.doNormalize = false; vab.label = ""; }
protected override void OnPinching(MR.Gestures.PinchEventArgs e) { base.OnPinching(e); SetAnchor(e.Center); var newScale = Scale * e.DeltaScale; Scale = Math.Min(5, Math.Max(0.1, newScale)); }
void fancyLabel_Panning(object sender, MR.Gestures.PanEventArgs e) { check.Text = "Panning"; Debug.WriteLine ("Panning"); var d = e.DeltaDistance; //info.Text = "x: " + d.X + ", y: " + d.Y; fancyLabel.TranslationX += d.X; fancyLabel.TranslationY += d.Y; }
private void gvMRList_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex >= 0) { bindItemList.DataSource = null; long MRNO = Convert.ToInt64(gvMRList.Rows[e.RowIndex].Cells[0].Value); MR objMRTemp = objMRDL.Get(MRNO); objMR = new MR(); objMR = objMRTemp; // objMRTemp.MRType = MR.Type.Material; if (objMRTemp.MRType == MR.Type.Material) { bindItemList.DataSource = objMRMaterialDL.Get(objMRTemp.MRNO); } if (objMRTemp.MRType == MR.Type.BasicProduct) { bindItemList.DataSource = objMRBasicProduct_DL.Get(objMRTemp.MRNO); } if (objMRTemp.MRType == MR.Type.FinishProduct) { bindItemList.DataSource = objMRFinishProductDL.Get(objMRTemp.MRNO); } txtapprovedBy.Text = objMR.MRApprovedBy; txtApprovedDate.Text = objMR.MRApprovedDate.ToShortDateString(); txtDate.Text = objMR.MRDate.ToShortDateString(); txtDepartment.Text = objMR.MRDepartmentFrom.DepName; txtMRNO.Text = objMR.MRNO.ToString(); txtRemarks.Text = objMR.MRRemarks; txtRequestedBy.Text = objMR.MREnterdBy; txtRequestedDate.Text = objMR.MRDate.ToShortDateString(); ItemSelect = true; if (objMR.Print == true) { btnPrint.Enabled = false; } else { btnPrint.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
protected override void OnTapped(MR.Gestures.TapEventArgs e) { base.OnTapped(e); var sc = e.Sender as MR.Gestures.SwitchCell; if(sc != null) { SwitchValue = !SwitchValue; } }
protected override void OnTapped(MR.Gestures.TapEventArgs e) { base.OnTapped(e); if(progress > 300) { progress = 0; AddText("Starting ProgressBars again."); Xamarin.Forms.Device.StartTimer(TimeSpan.FromMilliseconds(200), onTimer); } }
public void Clear() { txtDate.Text = ""; txtDepartment.Text = ""; txtMRNo.Text = ""; txtRemarks.Text = ""; txtReqestBy.Text = ""; txtType.Text = ""; bindItemList.DataSource = null; objMR = null; Search(); }
/// <summary> /// The get birth place. /// </summary> /// <param name="birthPlace"> /// The birth place. /// </param> /// <returns> /// The <see cref="string"/>. /// </returns> private string GetBirthPlace(MR birthPlace) { var sb = new StringBuilder(); sb.Append(birthPlace.CountryMr) .Append(" ") .Append(birthPlace.RegionMr) .Append(" ") .Append(birthPlace.AreMr) .Append(" ") .Append(birthPlace.CityMr); return(sb.ToString()); }
/// <summary> /// 保存本次病历信息 /// </summary> public void save(object sender, EventArgs e) { if (!checkFormat()) { return; } string msg = ""; if (mr == null) { mr = new MR(); mr.addTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } mr.clientId = client.id; mr.mr = rtbxMR.Text.Trim(); mr.date1 = dtpDate.Text; mr.doctor = tbxDoctor.Text.Trim(); if (mr.id < 0) { if (db.saveMR(mr)) { msg += "病历保存成功"; formMR.lblCRUDStatus.Text = DateTime.Now.ToString("HH:mm:ss") + " " + msg; formMR.getMRs(); this.Close(); } else { msg += "病历保存失败"; } } else { if (db.updateMR(mr)) { msg += "病历更新成功"; formMR.lblCRUDStatus.Text = DateTime.Now.ToString("HH:mm:ss") + " " + msg; formMR.getMRs(); this.Close(); } else { msg += "病历更新失败"; } } lblCRUDStatus.Text = DateTime.Now.ToString("HH:mm:ss") + " " + msg; }
protected override void OnPanning(MR.Gestures.PanEventArgs e) { base.OnPanning(e); if (Scale > 1) { if (Device.OS == TargetPlatform.WinPhone) { TranslationX += e.DeltaDistance.X * Scale; TranslationY += e.DeltaDistance.Y * Scale; } else { TranslationX += e.DeltaDistance.X; TranslationY += e.DeltaDistance.Y; } } }
protected override void OnPanning(MR.Gestures.PanEventArgs e) { base.OnPanning(e); if (Device.OS == TargetPlatform.WinPhone) { TranslationX += e.DeltaDistance.X * Scale; // unfortunately this has to be specified differently on WinPhone TranslationY += e.DeltaDistance.Y * Scale; // another bug in Xamarin Forms IMHO } else { TranslationX += e.DeltaDistance.X; TranslationY += e.DeltaDistance.Y; } }
protected override void OnSwiped(MR.Gestures.SwipeEventArgs e) { base.OnSwiped(e); try { if (this.scale <= 1) { if (e.Direction == MR.Gestures.Direction.Right) { if (_currentPage == 1) return; _currentPage--; if (_currentPage < 0) { _currentPage = 1; } CurrentPickerPage = _currentPage.ToString(); this.ImageSource = null; Task.Run(() => RefreshImage(_currentPage, _folderName, "", false)); } else if (e.Direction == MR.Gestures.Direction.Left) { if (_currentPage == _totalPage) return; _currentPage++; if (_currentPage > _totalPage) { CurrentPage = _totalPage; } CurrentPickerPage = _currentPage.ToString(); this.ImageSource = null; Task.Run(() => RefreshImage(_currentPage, _folderName, "", false)); } } } catch (Exception ex) { Alert (ex.Message); } }
public MRCollec GetByFromDep(decimal FromDep) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRFromDepID", FromDep) }; MRCollec objMRCollec = new MRCollec(); DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRbyDepID", paramList); for (int i = 0; i < dt.Rows.Count; i++) { MR objMR = new MR(); objMR.MRApprovedBy = Convert.ToString(dt.Rows[i]["MRApprovedBy"]); objMR.MRApprovedDate = Convert.ToDateTime(dt.Rows[i]["MRApproveDate"]); objMR.MRDate = Convert.ToDateTime(dt.Rows[i]["MRDate"]); objMR.MRDepartmentFrom = objDepartment_DL.Get(Convert.ToInt64(dt.Rows[i]["MRFromDepID"])); objMR.MREnterdBy = Convert.ToString(dt.Rows[i]["MREnterdBy"]); objMR.MRIssuedBy = Convert.ToString(dt.Rows[i]["MRIssuedBy"]); objMR.MRIssuedDate = Convert.ToDateTime(dt.Rows[i]["MRIssuedDate"]); objMR.MRNO = Convert.ToInt64(dt.Rows[i]["MRNO"]); objMR.MRReceivedBy = Convert.ToString(dt.Rows[i]["MRReceivedBy"]); objMR.MRReceivedDate = Convert.ToDateTime(dt.Rows[i]["MRReceivedDate"]); objMR.MRRemarks = Convert.ToString(dt.Rows[i]["MRNO"]); objMR.MRStatus = (MR.Status)dt.Rows[i]["MRStatus"]; objMR.MRType = (MR.Type)dt.Rows[i]["MRType"]; objMR.MRStore = objStore_DL.Get(Convert.ToString(dt.Rows[i]["MRStore"])); if (dt.Rows[i]["MRSectionID"] != null) { objMR.SectionID = Convert.ToInt64(dt.Rows[i]["MRSectionID"]); } objMRCollec.Add(objMR); } return(objMRCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update_Issue(MR obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@IssuedBy", obj.MRIssuedBy), new SqlParameter("@Status", obj.MRStatus), new SqlParameter("@MRNO", obj.MRNO) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MR_Issue", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public long GenerateMR(PRPDBatch objPRPD) { MR objMR = new MR(); MRMaterialCollec objMRMatCollec = new MRMaterialCollec(); MRFinishProductCollec objMRFinishProductCollec = new MRFinishProductCollec(); MRBasicProductCollec objMRBasicProductCollec = new MRBasicProductCollec(); BatchMR objBatchMR = new BatchMR(); Department_DL objDepDL = new Department_DL(ConnectionStringClass.GetConnection()); MR_DL objMRDL = new MR_DL(ConnectionStringClass.GetConnection()); MRMaterial_DL objMRMaterialDL = new MRMaterial_DL(ConnectionStringClass.GetConnection()); Store_DL objStoreDL = new Store_DL(ConnectionStringClass.GetConnection()); try { objMR.MRDate = DateTime.Now; objMR.MRDepartmentFrom = objDepDL.GetByDepType("PRPD"); objMR.MREnterdBy = CurrentUser.EmployeeID; objMR.MRStatus = MR.Status.Initial; objMR.MRStore = objStore; objMR.MRType = MR.Type.Material; objMR.MRRemarks = "Material Requition(Materials) for PRPD Batch NO " + objPRPD.PRPDBatchID.ToString(); objMR.OriginType = MR.Origin.ToBatch; MRMaterial obj = new MRMaterial(); obj.Description = "PRPD Batch Material Requition"; obj.Material = objPRPD.PRPDBatchMaterial; obj.MRBINNo = ""; obj.ReqdQty = objPRPD.PRPDBatchQty; long MRNO = objMRDL.Add_M(objMR); if (MRNO > 0) { objMR.MRNO = MRNO; obj.MR = objMR; objMRMaterialDL.Add(obj); } return(MRNO); } catch (Exception ex) { return(0); } }
void Update() { if (Input.GetMouseButtonDown(0)) { Rect r = MR.SR(0.00f, 0.00f, 0.30f, 0.20f); Vector3 pos = Input.mousePosition; pos.y = Screen.height - pos.y; if (r.Contains(pos)) { DoEscape(); } } if (Input.GetKeyDown(KeyCode.Escape)) { DoEscape(); } }
public int Update_ReceiveGRN(MR obj, string StoreID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@ReceivedBy", obj.MRReceivedBy), new SqlParameter("@Status", obj.MRStatus), new SqlParameter("@Type", obj.MRType), new SqlParameter("@StoreID", StoreID), new SqlParameter("@MRNO", obj.MRNO) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MR_ReceivedGRN", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
protected override void OnSwiped(MR.Gestures.SwipeEventArgs e) { base.OnSwiped(e); if (e.Direction == MR.Gestures.Direction.Right) { currentImage--; if (currentImage < 0) currentImage = images.Length - 1; NotifyPropertyChanged(() => ImageSource); } else if (e.Direction == MR.Gestures.Direction.Left) { currentImage++; if (currentImage >= images.Length) currentImage = 0; NotifyPropertyChanged(() => ImageSource); } }
/// <summary> /// 弹出编辑病历的对话框(修改) /// </summary> public void editMR(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = dgvMR.SelectedRows[0]; string mrId = row.HeaderCell.Value + ""; MR mr = db.getMR(mrId); Console.WriteLine("mr1:" + mr.mr); if (Application.OpenForms["FormEditMR"] == null) { FormEditMR form = new FormEditMR(); form.formMR = this; form.client = client; form.mr = mr; form.db = db; form.Show(); } }
public static string GetModel_Role(int LogId) { DataTable dt_Acc_Role = Mydb.ExecuteReadertoDataTable("select * from ACCOUNT_ROLE where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LogId) }, CommandType.Text); List <MR> mrs = new List <MR>(); foreach (DataRow item in dt_Acc_Role.Rows) { DataTable dt_M_R = Mydb.ExecuteReadertoDataTable("select * from MODUL_ROLE where MR_ID=@mr", new SqlParameter[] { new SqlParameter("@mr", Convert.ToInt32(item["MR_ID"])) }, CommandType.Text); foreach (DataRow item2 in dt_M_R.Rows) { MR mr = new MR(); mr.sm = item2["MODUL_ID"].ToString(); mr.sr = item2["ROLE_ID"].ToString(); mrs.Add(mr); } } JavaScriptSerializer js_mrs = new JavaScriptSerializer(); return(js_mrs.Serialize(mrs)); }
/// <summary> /// 删除一条病历记录 /// </summary> public bool deleteMR(MR mr) { SQLiteCommand cmd = new SQLiteCommand(); cmd.Connection = this.conn; string sql = "delete from t_mr where id = " + mr.id; Console.WriteLine("sql:" + sql); cmd.CommandText = sql; int effictedNum = cmd.ExecuteNonQuery(); if (effictedNum > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条病历记录 /// </summary> public bool updateMR(MR mr) { SQLiteCommand cmd = new SQLiteCommand(); cmd.Connection = this.conn; string sql = "update t_mr set mr = '" + mr.mr + "', date1 = '" + mr.date1 + "', doctor = '" + mr.doctor + "' where id = " + mr.id; Console.WriteLine("sql:" + sql); cmd.CommandText = sql; int effictedNum = cmd.ExecuteNonQuery(); if (effictedNum > 0) { return(true); } else { return(false); } }
/// <summary> /// 保存一次病历记录 /// </summary> public bool saveMR(MR mr) { SQLiteCommand cmd = new SQLiteCommand(); cmd.Connection = this.conn; string sql = "insert into t_mr (clientId, mr, addTime, date1, doctor) values (" + mr.clientId + ", '" + mr.mr + "', '" + mr.addTime + "', '" + mr.date1 + "','" + mr.doctor + "')"; Console.WriteLine("sql:" + sql); cmd.CommandText = sql; int effictedNum = cmd.ExecuteNonQuery(); if (effictedNum > 0) { return(true); } else { return(false); } }
/// <summary> /// 获取病历列表 /// </summary> public void getMRs() { dgvMR.Rows.Clear(); if (client != null) { mrs = db.getMRsByClientId(client.id); for (int i = 0; i < mrs.Count; i++) { dgvMR.Rows.Add(); MR mr = mrs[i]; DataGridViewRow row = dgvMR.Rows[dgvMR.Rows.Count - 1]; row.HeaderCell.Value = mr.id; row.Cells[0].Value = (i + 1); row.Cells[1].Value = mr.date1; row.Cells[2].Value = mr.mr; row.Cells[3].Value = mr.doctor; } } }
private void UpdateMarks(MR.Gestures.BaseGestureEventArgs e) { if(e.Touches == null || e.Touches.Length == 0) { Finger1 = offScreen; Finger2 = offScreen; Center = offScreen; } else if(e.Touches.Length == 1) { Finger1 = new Rectangle(e.Touches[0].Subtract(halfMarkSize), autoSize); Finger2 = offScreen; Center = offScreen; } else { Finger1 = new Rectangle(e.Touches[0].Subtract(halfMarkSize), autoSize); Finger2 = new Rectangle(e.Touches[1].Subtract(halfMarkSize), autoSize); Center = new Rectangle(e.Center.Subtract(halfMarkSize), autoSize); } }
protected override void OnTapping(MR.Gestures.TapEventArgs e) { base.OnTapping(e); if (e.Touches == null) return; if(signsOnBoard == 9) { InitBoard(); return; } if(e.Touches == null || e.Touches.Length == 0) { AddText("Touch coordinates are missing."); return; } int x = (int)(e.Touches[0].X * 3 / e.ViewPosition.Width); int y = (int)(e.Touches[0].Y * 3 / e.ViewPosition.Height); if(board[y][x] != ' ') { AddText("Field {0}/{1} is already filled.", x, y); return; } board[y][x] = next; NotifyPropertyChanged("ImageCell" + y + x); next = next == 'X' ? 'O' : 'X'; signsOnBoard++; checkGameOver(); }
void Cell_Rotated(object sender, MR.Gestures.RotateEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("TextCellXaml.Cell_Rotated method called on cell '" + ((TextCell)sender).Text + "'"); }
void Cell_Swiped(object sender, MR.Gestures.SwipeEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("TextCellXaml.Cell_Swiped method called on cell '" + ((TextCell)sender).Text + "', swiped " + e.Direction); }
void Cell_LongPressing(object sender, MR.Gestures.LongPressEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("TextCellXaml.Cell_LongPressing method called on cell '" + ((TextCell)sender).Text + "'"); }
void Cell_DoubleTapped(object sender, MR.Gestures.TapEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("TextCellXaml.Cell_DoubleTapped method called on cell '" + ((TextCell)sender).Text + "' " + e.NumberOfTaps + " times"); }
void Cell_Up(object sender, MR.Gestures.DownUpEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("TextCellXaml.Cell_Up method called on cell '" + ((TextCell)sender).Text + "' with " + e.TriggeringTouches.Length + " fingers"); }
protected override void OnRotating(MR.Gestures.RotateEventArgs e) { base.OnRotating(e); SetAnchor(e.Center); Rotation += e.DeltaAngle; }
void Cell_Pinched(object sender, MR.Gestures.PinchEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("ListViewXaml.Cell_Pinched method called"); }
void Cell_Rotating(object sender, MR.Gestures.RotateEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("ListViewXaml.Cell_Rotating method called"); }
protected override void OnDoubleTapped(MR.Gestures.TapEventArgs e) { base.OnDoubleTapped(e); if (this.scale != 1) { Scale = 1; TranslationX = 0; TranslationY = 0; } else { Scale = this.scale + 0.5; } }
protected override void OnUp(MR.Gestures.DownUpEventArgs e) { base.OnUp(e); ((Button)e.Sender).BackgroundColor = Color.FromHex("808080"); }
protected override void OnDown(MR.Gestures.DownUpEventArgs e) { base.OnDown(e); ((Button)e.Sender).BackgroundColor = Color.Yellow; }
protected override void OnSwiped(MR.Gestures.SwipeEventArgs e) { base.OnSwiped(e); if(e.Direction == MR.Gestures.Direction.Right) { Finger1 = offScreen; Finger2 = offScreen; Center = offScreen; } }
void Cell_Up(object sender, MR.Gestures.DownUpEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("ListViewXaml.Cell_Up method called with " + e.TriggeringTouches.Length + " fingers"); }
void Cell_Tapping(object sender, MR.Gestures.TapEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("ListViewXaml.Cell_Tapping method called " + e.NumberOfTaps + " times"); }
void Cell_Swiped(object sender, MR.Gestures.SwipeEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("ListViewXaml.Cell_Swiped method called, swiped " + e.Direction); }
void Cell_LongPressed(object sender, MR.Gestures.LongPressEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("Cell_LongPressed method called"); }
void Cell_DoubleTapped(object sender, MR.Gestures.TapEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("Cell_DoubleTapped method called " + e.NumberOfTaps + " times"); }
void Cell_Pinching(object sender, MR.Gestures.PinchEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("Cell_Pinching method called"); }
void Cell_Pinched(object sender, MR.Gestures.PinchEventArgs e) { ((TextOnlyViewModel)BindingContext).AddText("ImageCellXaml.Cell_Pinched method called on cell '" + ((ImageCell)sender).Text + "'"); }