//------------------ 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 + "'");
}
