//填充列表
private void m_mthShowList()
{
this.m_lsvConcentration.BeginUpdate();//开始更新列表
foreach (clsLisQCConcentrationVO qcConcentration in this.m_objQCContrations)
{
ListViewItem item = new ListViewItem(qcConcentration.m_intConcentrationSeq.ToString());
item.SubItems.Add(qcConcentration.m_strConcentration);
item.SubItems.Add(qcConcentration.m_strDeviceSampleId);
item.SubItems.Add(DBAssist.ToString(qcConcentration.m_dblAVG));
item.SubItems.Add(DBAssist.ToString(qcConcentration.m_dblSD));
item.SubItems.Add(DBAssist.ToString(qcConcentration.m_dblCV));
item.SubItems.Add("");
item.Tag = qcConcentration;
this.m_lsvConcentration.Items.Add(item);
}
foreach (clsLisQCConcentrationVO obj in this.m_objDeletedQCContrations)
{
ListViewItem item = new ListViewItem(obj.m_intConcentrationSeq.ToString());
item.SubItems.Add(obj.m_strConcentration);
item.SubItems.Add(obj.m_strDeviceSampleId);
item.SubItems.Add(DBAssist.ToString(obj.m_dblAVG));
item.SubItems.Add(DBAssist.ToString(obj.m_dblSD));
item.SubItems.Add(DBAssist.ToString(obj.m_dblCV));
item.SubItems.Add("╳");
item.Tag = obj;
item.ForeColor = Color.Red;
this.m_lsvConcentration.Items.Add(item);
}
this.m_lsvConcentration.EndUpdate();//结束更新列表
if (this.m_lsvConcentration.Items.Count > 0)
{
this.m_lsvConcentration.Focus();
this.m_lsvConcentration.Items[0].Selected = true;
}
}
private void cboSampleType_SelectedIndexChanged(object sender, System.EventArgs e)
{
string strSampleTypeID = cboSampleType.SelectedValue.ToString().Trim();
lsvSampleCharacter.Items.Clear();
ResetSampleCharacter();
((clsController_SampleTypeInfo)this.objController).QryAllSampleCharacter(out dtbAllSampleCharacter, strSampleTypeID);
int count = dtbAllSampleCharacter.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
ListViewItem objlsvItem = new ListViewItem();
objlsvItem.Text = dtbAllSampleCharacter.Rows[i]["CHARACTERORD_INT"].ToString().Trim();
objlsvItem.SubItems.Add(dtbAllSampleCharacter.Rows[i]["CHARACTER_DESC_VCHR"].ToString().Trim());
objlsvItem.SubItems.Add(dtbAllSampleCharacter.Rows[i]["PYCODE_CHR"].ToString().Trim());
objlsvItem.SubItems.Add(dtbAllSampleCharacter.Rows[i]["WBCODE_CHR"].ToString().Trim());
int hasBarCode = DBAssist.ToInt32(dtbAllSampleType.Rows[i]["HasBarCode_int"].ToString());
objlsvItem.SubItems.Add(hasBarCode == 1 ? "有" : "无");
lsvSampleCharacter.Items.Add(objlsvItem);
}
}
}
private async void SetupUI()
{
if (File.Exists(path))
{
bookmarksList = await DBAssist.DeserializeDBAsync <List <Idea> >(path);
bookmarksList = bookmarksList ?? new List <Idea>();
allItems = Global.Categories;
if (bookmarksList.Count > 0)
{
adapter = new BookmarkListAdapter(bookmarksList);
adapter.ItemClick -= OnItemClick;
adapter.ItemClick += OnItemClick;
recyclerView.SetLayoutManager(manager);
recyclerView.SetAdapter(adapter);
recyclerView.SetItemAnimator(new DefaultItemAnimator());
manager.ScrollToPosition(Global.BookmarkScrollPosition);
adapter.StateClicked -= StateClicked;
adapter.StateClicked += StateClicked;
ShowProgress();
}
else
{
ShowEmptyState();
}
}
else
{
ShowEmptyState();
}
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisQCBatchVO p_objQCBatch)
{
p_objQCBatch.m_strSortNum = p_dtrSource["sort_num_int"].ToString().Trim();
p_objQCBatch.m_intSeq = DBAssist.ToInt32(p_dtrSource["QCBATCH_SEQ_INT"]);
p_objQCBatch.m_intWorkGroupSeq = DBAssist.ToInt32(p_dtrSource["WORKGROUP_SEQ_INT"]);
p_objQCBatch.m_strDeviceId = p_dtrSource["DEVICEID_CHR"].ToString().Trim();
p_objQCBatch.m_strCheckItemId = p_dtrSource["CHECK_ITEM_ID_CHR"].ToString().Trim();
p_objQCBatch.m_strSampleLotNo = p_dtrSource["QCSAMPLE_LOTNO_VCHR"].ToString().Trim();
p_objQCBatch.m_strSampleSource = p_dtrSource["QCSAMPLE_SOURCE_VCHR"].ToString().Trim();
p_objQCBatch.m_strSampleVendor = p_dtrSource["QCSAMPLE_VENDOR_VCHR"].ToString().Trim();
p_objQCBatch.m_strReagent = p_dtrSource["REAGENT_VCHR"].ToString().Trim();
p_objQCBatch.m_strReagentBatch = p_dtrSource["REAGENT_BATCH_VCHR"].ToString().Trim();
p_objQCBatch.m_strCheckmethodName = p_dtrSource["CHECKMETHOD_NAME_VCHR"].ToString().Trim();
p_objQCBatch.m_dblWaveLength = DBAssist.ToDouble(p_dtrSource["WAVELENGTH_NUM"]);
p_objQCBatch.m_strQCRules = p_dtrSource["QCRULES_VCHR"].ToString().Trim();
p_objQCBatch.m_strResultUnit = p_dtrSource["RESULTUNIT_VCHR"].ToString().Trim();
p_objQCBatch.m_dtBegin = DBAssist.ToDateTime(p_dtrSource["BEGIN_DAT"]);
p_objQCBatch.m_dtEnd = DBAssist.ToDateTime(p_dtrSource["END_DAT"]);
p_objQCBatch.m_strSummary = p_dtrSource["SUMMARY_VCHR"].ToString().Trim();
p_objQCBatch.m_strOperatorId = p_dtrSource["OPERATOR_ID_CHR"].ToString().Trim();
p_objQCBatch.m_dtModify = DBAssist.ToDateTime(p_dtrSource["MODIFY_DAT"]);
try
{
p_objQCBatch.m_enmStatus = (enmQCStatus)DBAssist.ToInt32(p_dtrSource["STATUS_INT"]);
}
catch
{
}
}
private void m_mthDisplayVO()
{
clsLisQCBatchVO objBatch = this.objQCBatch;
m_txtQCBatchSeq.Text = DBAssist.ToString(objBatch.m_intSeq);
m_cboWorkGroup.Value = objBatch.m_intWorkGroupSeq;
if (objQCBatch.m_strDeviceId != string.Empty)
{
try { ctlLISDeviceComboBox1.SelectedValue = objBatch.m_strDeviceId; }
catch { }
this.m_chkIsMachine.Checked = true;
}
else
{
this.m_chkIsMachine.Checked = false;
}
m_txtQCCheckItem.Tag = objBatch.m_strCheckItemId;
m_txtQCCheckItem.Text = objBatch.m_strCheckItemName;
m_txtQCSampleLotNO.Text = objBatch.m_strSampleLotNo;
m_cboQCSampleSource.Text = objBatch.m_strSampleSource;
m_cboQCSqmpleVendor.Text = objBatch.m_strSampleVendor;
m_txtReagentLotNO.Text = objBatch.m_strReagentBatch;
m_cboReagentVendor.Text = objBatch.m_strReagent;
m_cboCheckMethod.Text = objBatch.m_strCheckmethodName;
m_txtWaveLength.Text = DBAssist.ToString(objBatch.m_dblWaveLength);
m_txtResultUnit.Text = objBatch.m_strResultUnit;
m_dtpBeginDate.Value = objBatch.m_dtBegin;
m_dtpEndDate.Value = objBatch.m_dtEnd;
m_txtAppDoct.m_StrEmployeeID = objBatch.m_strOperatorId;
m_txtSummary.Text = objBatch.m_strSummary;
//质控规则
//...
m_dtgQCRules.DataSource = m_dtbGetRulesFromVO();
}
protected async override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
notes = await DBAssist.DeserializeDBAsync <List <Note> >(notesdb);
notes = notes ?? new List <Note>();
bookmarkedItems = await DBAssist.DeserializeDBAsync <List <Idea> >(bookmarksdb);
bookmarkedItems = bookmarkedItems ?? new List <Idea>();
recycler = FindViewById <RecyclerView>(Resource.Id.notesRecyclerView);
emptyState = FindViewById(Resource.Id.empty);
if (notes.Count == 0)
{
ShowEmptyState();
}
else
{
manager = new LinearLayoutManager(this);
adapter = new NotesAdapter(notes);
adapter.EditClicked += Adapter_EditClicked;
adapter.ViewNoteClicked += (position) =>
{
new AlertDialog.Builder(this)
.SetTitle(notes[position].Name)
.SetMessage(notes[position].Content)
.SetPositiveButton("Great", (sender, e) => { return; })
.Create().Show();
};
adapter.DeleteClicked += (position) =>
{
var foundIdea = Global.Categories.FirstOrDefault(x => x.CategoryLbl == notes[position].Category).Items.FirstOrDefault(y => y.Title == notes[position].Title);
if (foundIdea != null)
{
foundIdea.Note = null;
}
var foundBookmark = bookmarkedItems.FirstOrDefault(x => x.Title == notes[position].Title);
if (foundBookmark != null)
{
foundBookmark.Note = null;
}
notes.RemoveAt(position);
adapter.NotifyItemRemoved(position);
if (notes.Count == 0)
{
ShowEmptyState();
}
};
recycler.SetAdapter(adapter);
recycler.SetLayoutManager(manager);
recycler.SetItemAnimator(new DefaultItemAnimator());
}
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisCheckMethodVO p_objCheckMethod)
{
p_objCheckMethod.m_intSeq = DBAssist.ToInt32(p_dtrSource["METHOD_SEQ_INT"]);
p_objCheckMethod.m_strName = p_dtrSource["CHECKMETHOD_NAME_VCHR"].ToString();
p_objCheckMethod.m_strPycode = p_dtrSource["PYCODE_VCHR"].ToString();
p_objCheckMethod.m_strWbcode = p_dtrSource["WBCODE_VCHR"].ToString();
}
protected override void OnPause()
{
if (ideasdb != null)
{
DBAssist.SerializeDBAsync(ideasdb, allItems);
}
base.OnPause();
}
private void ConstructVO(DataRow p_dtrSource, ref clsSysParamVO objReader)
{
objReader.m_intStatus = DBAssist.ToInt32(p_dtrSource["status_int"]);
objReader.m_intSysCode = DBAssist.ToInt32(p_dtrSource["syscode_chr"]);
objReader.m_strParamCode = p_dtrSource["parmcode_chr"].ToString();
objReader.m_strParamDesc = p_dtrSource["parmdesc_vchr"].ToString();
objReader.m_strParamValue = p_dtrSource["parmvalue_vchr"].ToString();
objReader.m_strNote = p_dtrSource["note_vchr"].ToString();
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisQCDataVO p_objQCData)
{
//DATA_SEQ_INT, QCBATCH_SEQ_INT, RESULT_NUM,
// CONCENTRATION_SEQ_INT, QCDATE_DAT
p_objQCData.m_intSeq = DBAssist.ToInt32(p_dtrSource["DATA_SEQ_INT"]);
p_objQCData.m_intQCBatchSeq = DBAssist.ToInt32(p_dtrSource["QCBATCH_SEQ_INT"]);
p_objQCData.m_dlbResult = DBAssist.ToDouble(p_dtrSource["RESULT_NUM"]);
p_objQCData.m_intConcentrationSeq = DBAssist.ToInt32(p_dtrSource["CONCENTRATION_SEQ_INT"]);
p_objQCData.m_datQCDate = DBAssist.ToDateTime(p_dtrSource["QCDATE_DAT"]);
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisConcentrationVO p_objConcentration)
{
// CONCENTRATION_SEQ_INT, CONCENTRATION_VCHR, STATUS_INT
p_objConcentration.m_intSeq = DBAssist.ToInt32(p_dtrSource["CONCENTRATION_SEQ_INT"]);
p_objConcentration.m_strConcentration = p_dtrSource["CONCENTRATION_VCHR"].ToString();
try
{
p_objConcentration.m_enmStatus = (enmQCStatus)DBAssist.ToInt32(p_dtrSource["STATUS_INT"]);
}
catch { }
}
private void StateClicked(string title, string state, int adapterPos)
{
if (bookmarksList != null && bookmarksList.Count != 0)
{
bookmarksList[adapterPos].State = state;
adapter.NotifyItemChanged(adapterPos);
allItems.FirstOrDefault(x => x.CategoryLbl == bookmarksList[adapterPos].Category).Items.FirstOrDefault(x => x.Title == title).State = state;
DBAssist.SerializeDBAsync(path, bookmarksList);
ShowProgress();
}
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisQCSampleLotParaVO objQCSamplePara)
{
// CHECK_ITEM_ID_CHR, QCSMPLOT_SEQ_INT, AVG_NUM, SD_NUM,
// CV_NUM
objQCSamplePara.m_strCheckItemId = p_dtrSource["CHECK_ITEM_ID_CHR"].ToString();
objQCSamplePara.m_intQCSmplotSeq = DBAssist.ToInt32(p_dtrSource["QCSMPLOT_SEQ_INT"]);
objQCSamplePara.m_dblAVG = DBAssist.ToDouble(p_dtrSource["AVG_NUM"]);
objQCSamplePara.m_dblSD = DBAssist.ToDouble(p_dtrSource["SD_NUM"]);
objQCSamplePara.m_dblCV = DBAssist.ToDouble(p_dtrSource["CV_NUM"]);
}
protected override void OnStop()
{
if (notes != null)
{
DBAssist.SerializeDBAsync(notesdb, notes);
}
if (bookmarkedItems != null)
{
DBAssist.SerializeDBAsync(bookmarksdb, bookmarkedItems);
}
base.OnStop();
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisWorkGroupVO p_objWorkGroup)
{
p_objWorkGroup.m_intSeq = p_dtrSource["WORKGROUP_SEQ_INT"] == System.DBNull.Value ? 0 : int.Parse(p_dtrSource["WORKGROUP_SEQ_INT"].ToString().Trim());
p_objWorkGroup.m_strName = p_dtrSource["WORKGROUP_NAME_VCHR"].ToString().Trim();
p_objWorkGroup.m_strSummary = p_dtrSource["SUMMARY_VCHR"].ToString().Trim();
try
{
p_objWorkGroup.m_enmStatus = (enmQCStatus)DBAssist.ToInt32(p_dtrSource["STATUS_INT"]);
}
catch
{
}
}
private System.Data.IDataParameter[] GetUpdateDataParameterArr(clsLisQCConcentrationVO p_objQCConcentration)
{
System.Data.IDataParameter[] objODPArr = null;
objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_objQCConcentration.m_strDeviceSampleId,
(int)p_objQCConcentration.m_enmStatus,
DBAssist.ToObject(p_objQCConcentration.m_dblAVG),
DBAssist.ToObject(p_objQCConcentration.m_dblSD),
DBAssist.ToObject(p_objQCConcentration.m_dblCV),
p_objQCConcentration.m_intQCBatchSeq,
p_objQCConcentration.m_intConcentrationSeq
);
return(objODPArr);
}
/// <summary>
/// 构造VO
/// </summary>
/// <param name="dtRow"></param>
/// <returns></returns>
public clsChargeStatusVO ConstructVO(DataRow dtRow)
{
clsChargeStatusVO obj = new clsChargeStatusVO();
obj.m_strSeq = dtRow["ATTARELAID_CHR"].ToString();
obj.m_strSourceItemId = dtRow["SOURCEITEMID_VCHR"].ToString();
obj.m_strApplicationId = dtRow["ATTACHID_VCHR"].ToString();
obj.m_intType = DBAssist.ToInt32(dtRow["ATTACHTYPE_INT"]);
obj.m_intModuleId = DBAssist.ToInt32(dtRow["SYSFROM_INT"]);
obj.m_blnUrgency = DBAssist.ToInt32(dtRow["URGENCY_INT"]) == 1 ? true : false;
obj.m_intChargeStatus = DBAssist.ToInt32(dtRow["STATUS_INT"]);
return(obj);
}
/// <summary>
/// m_mthControlsDisplayVOValue
/// </summary>
/// <param name="objReport"></param>
private void m_mthControlsDisplayVOValue(clsLisQCReportVO objReport)
{
if (objReport != null)
{
m_lblBatchNO.Text = DBAssist.ToString(objReport.m_intQCBatchSeq);
this.m_chkLost.Checked = objReport.m_enmQCControlStatus == enmQCControlStatus.Control ? false : true;
m_txtAppDoct.m_StrEmployeeID = objReport.m_strReportorId;
m_txtUnmatchedRule.Text = objReport.m_strUnmatchedRule;
m_txtReason.Text = objReport.m_strReason;
m_txtProcess.Text = objReport.m_strProcess;
m_txtSummary.Text = objReport.m_strSummary;
m_dtpReport.Value = objReport.m_dtReport;
}
}
private void m_mthListViewItemInit(clsLisQCBatchVO var, ListViewItem item)
{
if (item == null || var == null)
{
return;
}
item.Text = var.m_strSampleLotNo;
item.SubItems.Add(var.m_strCheckItemName);
item.SubItems.Add(var.m_strDeviceName);
item.SubItems.Add(var.m_strWorkGroupName);
item.SubItems.Add(DBAssist.ToString(var.m_dtBegin, "yyyy-MM-dd"));
item.SubItems.Add(DBAssist.ToString(var.m_dtEnd, "yyyy-MM-dd"));
item.SubItems.Add(DBAssist.ToString(var.m_intSeq));
item.Tag = var.m_intSeq;
}
/// <summary>
/// GetUpdateDataParameterArr
/// </summary>
/// <param name="p_objQCReport"></param>
/// <returns></returns>
private IDataParameter[] GetUpdateDataParameterArr(clsLisQCReportVO p_objQCReport)
{
return(clsPublicSvc.m_objConstructIDataParameterArr(new object[] { p_objQCReport.m_intQCBatchSeq,
(int)p_objQCReport.m_enmQCControlStatus,
p_objQCReport.m_strUnmatchedRule,
p_objQCReport.m_strReason,
p_objQCReport.m_strProcess,
p_objQCReport.m_strSummary,
DBAssist.ToObject(p_objQCReport.m_dtReport),
p_objQCReport.m_strReportorId,
(int)p_objQCReport.m_enmStatus,
p_objQCReport.m_dtModify,
p_objQCReport.m_intReportStats,
p_objQCReport.m_intSeq }));
}
private void m_mthListViewItemInit(clsLisQCReportVO p_objReportVO, ListViewItem item)
{
item.Text = DBAssist.ToString(p_objReportVO.m_dtReport, "yyyy-MM-dd");
if (p_objReportVO.m_enmQCControlStatus == enmQCControlStatus.Control)
{
item.SubItems.Add("");
}
else
{
item.SubItems.Add("¡ø");
}
item.SubItems.Add(p_objReportVO.m_strUnmatchedRule);
item.SubItems.Add(p_objReportVO.m_strReportorName);
item.Tag = p_objReportVO;
}
private void m_mthListViewItemChange(clsLisQCBatchVO var, ListViewItem item)
{
if (item == null || var == null)
{
return;
}
item.Text = var.m_strSampleLotNo;
item.SubItems[1].Text = var.m_strCheckItemName;
item.SubItems[2].Text = var.m_strDeviceName;
item.SubItems[3].Text = var.m_strWorkGroupName;
item.SubItems[4].Text = DBAssist.ToString(var.m_dtBegin, "yyyy-MM-dd");
item.SubItems[5].Text = DBAssist.ToString(var.m_dtEnd, "yyyy-MM-dd");
item.SubItems[6].Text = DBAssist.ToString(var.m_intSeq);
item.Tag = var.m_intSeq;
}
private void m_mthListViewItemChange(clsLisQCReportVO p_objReportVO, ListViewItem item)
{
item.Text = DBAssist.ToString(p_objReportVO.m_dtReport, "yyyy-MM-dd");
if (p_objReportVO.m_enmQCControlStatus == enmQCControlStatus.Control)
{
item.SubItems[1].Text = "";
}
else
{
item.SubItems[1].Text = "¡ø";
}
item.SubItems[2].Text = p_objReportVO.m_strUnmatchedRule;
item.SubItems[3].Text = p_objReportVO.m_strReportorName;
item.Tag = p_objReportVO;
}
//列表选定项变更
private void m_lsvConcentration_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.m_lsvConcentration.SelectedItems.Count <= 0)
{
return;
}
//变更状态标志
this.m_blnNew = false;
clsLisQCConcentrationVO obj = (clsLisQCConcentrationVO)this.m_lsvConcentration.SelectedItems[0].Tag;
this.m_cboConcentration.Value = obj.m_intConcentrationSeq;
this.m_txtDeviceSampleID.Text = obj.m_strDeviceSampleId;
this.m_txtCV.Text = DBAssist.ToString(obj.m_dblCV);
this.m_txtSD.Text = DBAssist.ToString(obj.m_dblSD);
this.m_txtX.Text = DBAssist.ToString(obj.m_dblAVG);
if (obj.m_enmStatus == enmQCStatus.Natrural)
{
this.m_cboConcentration.Enabled = false;
this.m_txtDeviceSampleID.Enabled = true;
this.m_txtCV.Enabled = true;
this.m_txtSD.Enabled = true;
this.m_txtX.Enabled = true;
this.m_cmdNew.Enabled = true;
this.m_cmdDelete.Enabled = true;
this.m_cmdSave.Enabled = true;
this.m_cmdReturn.Enabled = true;
this.m_cmdCancelDelete.Enabled = false;
}
else
{
this.m_cboConcentration.Enabled = false;
this.m_txtDeviceSampleID.Enabled = false;
this.m_txtCV.Enabled = false;
this.m_txtSD.Enabled = false;
this.m_txtX.Enabled = false;
this.m_cmdNew.Enabled = true;
this.m_cmdDelete.Enabled = false;
this.m_cmdSave.Enabled = false;
this.m_cmdReturn.Enabled = true;
this.m_cmdCancelDelete.Enabled = true;
}
}
//This is a funtion that handles generating User Information
static public TimeSheet GetUserData(string overrideUser, Page myPage)
{
TimeSheet myTimesheet = new TimeSheet();
string user = myPage.User.Identity.Name.Replace(@"CCSO\", "").ToUpper();
string oldUser = "";
string overrideSessionContent;
if (!overrideUser.Equals(""))
{
oldUser = user;
user = overrideUser;
}
else if (HttpContext.Current.Session["override"] != null)
{
overrideSessionContent = HttpContext.Current.Session["override"].ToString();
if (!overrideSessionContent.Equals(""))
{
user = HttpContext.Current.Session["override"].ToString();
}
}
myTimesheet.SetTimesheet(DateTime.Now.ToShortDateString(), user);
//if (!myTimesheet.MemberInforamtion.UserActive)
//HttpContext.Current.Response.Redirect("Error_Page.aspx", true);
HttpContext.Current.Session["currentMemberTimesheet"] = myTimesheet;
HttpContext.Current.Session["currentMemberInformation"] = myTimesheet.MemberInforamtion;
HttpContext.Current.Session["currentMemberWorkCode"] = myTimesheet.MemberInforamtion.WorkCodes;
if (!myPage.Request.Url.AbsoluteUri.Contains("Permissions"))
{
HttpContext.Current.Session["currentMemberPosNum"] = myTimesheet.MemberInforamtion.PosNumber.Trim();
}
//myPage fills out user work codes on initial load. make sure to heck if we are overriding a user to get their supervisors
if (Convert.ToString(HttpContext.Current.Session["supDTCheck"]).Equals("") || !user.Equals(oldUser))
{
HttpContext.Current.Session["supDTCheck"] = "TRUE";
}
HttpContext.Current.Session["supervisorDataTable"] = DBAssist.FillSupervisorDropdown(osn: myTimesheet.MemberInforamtion.MemberOSN.ToString());
return(myTimesheet);
}
private System.Data.IDataParameter[] GetInsertDataParameterArr(clsLisQCConcentrationVO p_objQCConcentration)
{
// QCBATCH_SEQ_INT, CONCENTRATION_SEQ_INT,
// DEVICESAMPLE_ID_VCHR, STATUS_INT, AVG_NUM, SD_NUM, CV_NUM
System.Data.IDataParameter[] objODPArr = null;
objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_objQCConcentration.m_intQCBatchSeq,
p_objQCConcentration.m_intConcentrationSeq,
p_objQCConcentration.m_strDeviceSampleId,
(int)p_objQCConcentration.m_enmStatus,
DBAssist.ToObject(p_objQCConcentration.m_dblAVG),
DBAssist.ToObject(p_objQCConcentration.m_dblSD),
DBAssist.ToObject(p_objQCConcentration.m_dblCV)
);
return(objODPArr);
}
//This is for when we are updating the Permissions Table and we want to have the ability to Email people errors and any changes that were made
static public void HandlePermissionsTable(List <Permission> permissionsTable, string user)
{
List <string> sendTo = new List <string>
{
"*****@*****.**"
};
//This is so that we can send the edited update email to the following
List <string> externalSendTo = new List <string>
{
"*****@*****.**" //HR
};
//This is package this way so that we can call it easily anywhere in the code
DBAssist.InsertToPermissions(permissionsTable);
TSMailHandler.CreatePermissionEmail(permissionsTable, user, sendTo);
TSMailHandler.CreatePermissionEmail(permissionsTable, user, externalSendTo);
}
//This is for binding the inforamtion from the DB into a list of TSMaster
static public List <TSMaster> LoadSiteMaster(string osn, bool limit)
{
List <TSMaster> myList = new List <TSMaster>();
DataTable myTable = DBAssist.GetTsMain_SiteMaster(osn, limit);
TSMaster myEntry;
foreach (DataRow row in myTable.Rows)
{
myEntry = new TSMaster();
myEntry.SiteMaster();
myEntry.TimesheetID = Convert.ToString(row["timesheetID"]).Trim();
myEntry.StartDate = Convert.ToDateTime(row["tsStartDate"]);
myList.Add(myEntry);
}
return(myList);
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisQCConcentrationVO p_objQCConcentration)
{
// QCBATCH_SEQ_INT, CONCENTRATION_SEQ_INT,
// DEVICESAMPLE_ID_VCHR, STATUS_INT, AVG_NUM, SD_NUM, CV_NUM
p_objQCConcentration.m_intConcentrationSeq = DBAssist.ToInt32(p_dtrSource["CONCENTRATION_SEQ_INT"]);
p_objQCConcentration.m_intQCBatchSeq = DBAssist.ToInt32(p_dtrSource["QCBATCH_SEQ_INT"]);
p_objQCConcentration.m_strDeviceSampleId = p_dtrSource["DEVICESAMPLE_ID_VCHR"].ToString();
try
{
p_objQCConcentration.m_enmStatus = (enmQCStatus)DBAssist.ToInt32(p_dtrSource["STATUS_INT"]);
}
catch
{
}
p_objQCConcentration.m_dblAVG = DBAssist.ToDouble(p_dtrSource["AVG_NUM"]);
p_objQCConcentration.m_dblSD = DBAssist.ToDouble(p_dtrSource["SD_NUM"]);
p_objQCConcentration.m_dblCV = DBAssist.ToDouble(p_dtrSource["CV_NUM"]);
}
private System.Data.IDataParameter[] GetUpdateDataParameterArr(clsLisQCReportVO p_objQCReport)
{
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr
(
p_objQCReport.m_intQCBatchSeq,
(int)p_objQCReport.m_enmQCControlStatus,
p_objQCReport.m_strUnmatchedRule,
p_objQCReport.m_strReason,
p_objQCReport.m_strProcess,
p_objQCReport.m_strSummary,
DBAssist.ToObject(p_objQCReport.m_dtReport),
p_objQCReport.m_strReportorId,
(int)p_objQCReport.m_enmStatus,
p_objQCReport.m_dtModify,
p_objQCReport.m_intSeq
);
return(objODPArr);
}
