public CheckForMissingFSROnDischarge() { this.returnOptionObject = new OptionObject(); this.fo = new FormObject(); this.ro = new RowObject(); this.listFields = new List<FieldObject>(); this.ebl = new EvaluationBusinessLayer(); }
public static FormObject isZipCodeAllNines(OptionObject optionobject, string scriptname) { //Find the rows to be changed var formSelected = optionobject.Forms.FirstOrDefault(f => f.FormId == "523"); var row = formSelected.CurrentRow; var ZipField = row.Fields.FirstOrDefault(f => f.FieldNumber == "94"); //var countyField = row.Fields.FirstOrDefault(f => f.FieldNumber == "93"); var formselect2 = optionobject.Forms.FirstOrDefault(f => f.FormId == ""); FormObject fo = new FormObject(); RowObject ro = new RowObject(); FieldObject fio = new FieldObject(); // FieldObject fio2 = new FieldObject(); //FieldObject fio2 = new FieldObject(); if (ZipField.FieldValue == "99999") { //set new form fields rows and display error message //set fio //set ro //set fo } fio.FieldNumber = ZipField.FieldNumber; // fio2.FieldNumber = countyField.FieldNumber; fio.FieldValue = string.Empty; fio.FieldValue = prevZip; // fio2.FieldValue = prevCounty; // fio.Enabled = "1"; // fio2.Enabled = "1"; var fieldList = new List<FieldObject>(); fieldList.Add(fio); // fieldList.Add(fio2); ro.Fields = fieldList.ToArray(); ro.ParentRowId = row.ParentRowId; ro.RowId = row.RowId; ro.RowAction = "EDIT"; fo.CurrentRow = ro; fo.FormId = formSelected.FormId; fo.MultipleIteration = formSelected.MultipleIteration; return fo; }
public static FormObject homelessZip(OptionObject optionobject, string scriptname) { //Find the rows to be changed var formSelected = optionobject.Forms.FirstOrDefault(f => f.FormId == "523"); var row = formSelected.CurrentRow; var ZipField = row.Fields.FirstOrDefault(f => f.FieldNumber == "94"); var countyField = row.Fields.FirstOrDefault(f => f.FieldNumber == "93"); var formselect2 = optionobject.Forms.FirstOrDefault(f => f.FormId == ""); prevZip = ZipField.FieldValue.ToString(); prevCounty = countyField.FieldValue.ToString(); //set the new values //create a new object option FormObject fo = new FormObject(); RowObject ro = new RowObject(); FieldObject fio = new FieldObject(); FieldObject fio2 = new FieldObject(); fio.FieldNumber = ZipField.FieldNumber; fio2.FieldNumber = countyField.FieldNumber; fio.FieldValue = string.Empty; fio.FieldValue = "88888"; fio2.FieldValue = "68"; fio.Enabled = "0"; fio2.Enabled = "0"; var fieldList = new List<FieldObject>(); fieldList.Add(fio); fieldList.Add(fio2); ro.Fields = fieldList.ToArray(); ro.ParentRowId = row.ParentRowId; ro.RowId = row.RowId; ro.RowAction = "EDIT"; fo.CurrentRow = ro; fo.FormId = formSelected.FormId; fo.MultipleIteration = formSelected.MultipleIteration; return fo; }
public FormObject createNewFormObject(RowObject r, FormObject f, string PATID) { FieldObject LGBT = new FieldObject(); r.Fields.FirstOrDefault(i => i.FieldNumber == LGBTField).FieldValue = string.Empty; LGBT.FieldNumber = r.Fields.FirstOrDefault(i => i.FieldNumber == LGBTField).FieldNumber; LGBT.FieldValue = getClientLGBTCodeFromSCSAssessment(PATID); var fieldList = new List<FieldObject>(); fieldList.Add(LGBT); RowObject ro = new RowObject(); ro.Fields = fieldList.ToArray(); ro.ParentRowId = r.ParentRowId; ro.RowId = r.RowId; ro.RowAction = rowAction; FormObject fo = new FormObject(); fo.CurrentRow = ro; fo.FormId = f.FormId; fo.MultipleIteration = f.MultipleIteration; return fo; }
public FormObject createNewFormObject(RowObject r, FormObject f) { FieldObject numOfDaysInCommunity = new FieldObject(); r.Fields.FirstOrDefault(i => i.FieldNumber == numberOfDaysInCommunityFieldNumber).FieldValue = string.Empty; numOfDaysInCommunity.FieldNumber = r.Fields.FirstOrDefault(i => i.FieldNumber == numberOfDaysInCommunityFieldNumber).FieldNumber; numOfDaysInCommunity.Required = "1"; var fieldList = new List<FieldObject>(); fieldList.Add(numOfDaysInCommunity); RowObject ro = new RowObject(); ro.Fields = fieldList.ToArray(); ro.ParentRowId = r.ParentRowId; ro.RowId = r.RowId; ro.RowAction = rowAction; FormObject fo = new FormObject(); fo.CurrentRow = ro; fo.FormId = f.FormId; fo.MultipleIteration = f.MultipleIteration; return fo; }
public FormObject createNewFormObject(RowObject r, FormObject f) { FieldObject apptDate = new FieldObject(); apptDate.FieldNumber = r.Fields.FirstOrDefault(i => i.FieldNumber == APPT_DATE_FIELD_NUMBER).FieldNumber; apptDate.FieldValue = appointmentDate; FieldObject apptStartTime = new FieldObject(); apptStartTime.FieldNumber = r.Fields.FirstOrDefault(i => i.FieldNumber == APPT_START_TIME_FIELD_NUMBER).FieldNumber; apptStartTime.FieldValue = appointmentStartTime; FieldObject apptServiceCode = new FieldObject(); apptServiceCode.FieldNumber = r.Fields.FirstOrDefault(i => i.FieldNumber == APPT_SERVICE_CODE_FIELD_NUMBER).FieldNumber; apptServiceCode.FieldValue = serviceCode; FieldObject apptStaffID = new FieldObject(); apptStaffID.FieldNumber = r.Fields.FirstOrDefault(i => i.FieldNumber == APPT_STAFF_FIELD_NUMBER).FieldNumber; apptStaffID.FieldValue = staffID; var fieldList = new List<FieldObject>(); fieldList.Add(apptDate); fieldList.Add(apptStartTime); fieldList.Add(apptServiceCode); fieldList.Add(apptStaffID); RowObject ro = new RowObject(); ro.Fields = fieldList.ToArray(); ro.ParentRowId = r.ParentRowId; ro.RowId = r.RowId; ro.RowAction = rowAction; FormObject fo = new FormObject(); fo.CurrentRow = ro; fo.FormId = f.FormId; fo.MultipleIteration = f.MultipleIteration; return fo; }
private OptionObject ServiceNeedsIntensityAssessment(OptionObject optionObject) { OptionObject returnOptionObject = new OptionObject(); int highCount = 0; int medCount = 0; int lowCount = 0; FieldObject genSvcNeedsHigh = new FieldObject(); genSvcNeedsHigh.FieldNumber = "140.85"; FieldObject genSvcNeedsMed = new FieldObject(); genSvcNeedsMed.FieldNumber = "140.86"; FieldObject genSvcNeedsLow = new FieldObject(); genSvcNeedsLow.FieldNumber = "140.87"; FieldObject incEduEmpHigh = new FieldObject(); incEduEmpHigh.FieldNumber = "140.88"; FieldObject incEduEmpMed = new FieldObject(); incEduEmpMed.FieldNumber = "140.89"; FieldObject incEduEmpLow = new FieldObject(); incEduEmpLow.FieldNumber = "140.9"; FieldObject[] generalServicesNeeds = new FieldObject[9]; generalServicesNeeds[0] = new FieldObject("138.74"); generalServicesNeeds[1] = new FieldObject("140.64"); generalServicesNeeds[2] = new FieldObject("140.65"); generalServicesNeeds[3] = new FieldObject("140.66"); generalServicesNeeds[4] = new FieldObject("140.63"); generalServicesNeeds[5] = new FieldObject("140.68"); generalServicesNeeds[6] = new FieldObject("140.7"); generalServicesNeeds[7] = new FieldObject("140.72"); generalServicesNeeds[8] = new FieldObject("140.74"); FieldObject[] incEduEmp = new FieldObject[4]; incEduEmp[0] = new FieldObject("140.76"); incEduEmp[1] = new FieldObject("140.78"); incEduEmp[2] = new FieldObject("140.8"); incEduEmp[3] = new FieldObject("140.82"); foreach (var field in optionObject.Forms[0].CurrentRow.Fields) { if (field.FieldNumber.Equals(generalServicesNeeds[0].FieldNumber)) generalServicesNeeds[0].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(generalServicesNeeds[1].FieldNumber)) generalServicesNeeds[1].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(generalServicesNeeds[2].FieldNumber)) generalServicesNeeds[2].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(generalServicesNeeds[3].FieldNumber)) generalServicesNeeds[3].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(generalServicesNeeds[4].FieldNumber)) generalServicesNeeds[4].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(generalServicesNeeds[5].FieldNumber)) generalServicesNeeds[5].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(generalServicesNeeds[6].FieldNumber)) generalServicesNeeds[6].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(generalServicesNeeds[7].FieldNumber)) generalServicesNeeds[7].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(generalServicesNeeds[8].FieldNumber)) generalServicesNeeds[8].FieldValue = field.FieldValue; } foreach (var field in optionObject.Forms[1].CurrentRow.Fields) { if (field.FieldNumber.Equals(incEduEmp[0].FieldNumber)) incEduEmp[0].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(incEduEmp[1].FieldNumber)) incEduEmp[1].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(incEduEmp[2].FieldNumber)) incEduEmp[2].FieldValue = field.FieldValue; if (field.FieldNumber.Equals(incEduEmp[3].FieldNumber)) incEduEmp[3].FieldValue = field.FieldValue; } foreach (var field in generalServicesNeeds) { if (!field.FieldValue.Equals(String.Empty)) { if (field.FieldValue.Equals("1")) lowCount++; else if (field.FieldValue.Equals("2")) medCount++; else highCount++; } } genSvcNeedsLow.FieldValue = lowCount.ToString(); genSvcNeedsMed.FieldValue = medCount.ToString(); genSvcNeedsHigh.FieldValue = highCount.ToString(); lowCount = 0; medCount = 0; highCount = 0; foreach (var field in incEduEmp) { if (!field.FieldValue.Equals(String.Empty)) { if (field.FieldValue.Equals("1")) lowCount++; else if (field.FieldValue.Equals("2")) medCount++; else highCount++; } } incEduEmpLow.FieldValue = lowCount.ToString(); incEduEmpMed.FieldValue = medCount.ToString(); incEduEmpHigh.FieldValue = highCount.ToString(); var fields1 = new FieldObject[3]; fields1[0] = genSvcNeedsLow; fields1[1] = genSvcNeedsMed; fields1[2] = genSvcNeedsHigh; var fields2 = new FieldObject[3]; fields2[0] = incEduEmpLow; fields2[1] = incEduEmpMed; fields2[2] = incEduEmpHigh; var forms = new FormObject[2]; var formObject1 = new FormObject(); var formObject2 = new FormObject(); var currentRow1 = new RowObject(); var currentRow2 = new RowObject(); currentRow1.Fields = fields1; currentRow1.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow1.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow1.RowAction = "EDIT"; formObject1.FormId = "169"; formObject1.CurrentRow = currentRow1; forms[0] = formObject1; currentRow2.Fields = fields2; currentRow2.RowId = optionObject.Forms[1].CurrentRow.RowId; currentRow2.ParentRowId = optionObject.Forms[1].CurrentRow.ParentRowId; currentRow2.RowAction = "EDIT"; formObject2.FormId = "175"; formObject2.CurrentRow = currentRow2; forms[1] = formObject2; returnOptionObject.Forms = forms; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.SystemCode = optionObject.SystemCode; return returnOptionObject; }
private OptionObject SocialSecurityDefault(OptionObject optionObject, Boolean isAdmissionScreen) { OptionObject returnOptionObject = new OptionObject(); String field6Value = null; String field90Value = null; String field171Value = null; foreach (var form in optionObject.Forms) { foreach (var currentField in form.CurrentRow.Fields) { if (currentField.FieldNumber.Equals("6")) field6Value = currentField.FieldValue; if (currentField.FieldNumber.Equals("90")) field90Value = currentField.FieldValue; if (currentField.FieldNumber.Equals("171")) field171Value = currentField.FieldValue; } } var socialSecurityField = new FieldObject(); var addressField = new FieldObject(); var lastNameField = new FieldObject(); var form510Fields = new FieldObject[1]; var form523Fields = new FieldObject[2]; var form14Fields = new FieldObject[3]; var admissionForms = new FormObject[2]; var demoForms = new FormObject[1]; var form510 = new FormObject(); var form523 = new FormObject(); var form14 = new FormObject(); var currentRow1 = new RowObject(); var currentRow2 = new RowObject(); #region Invalid Social Security Number socialSecurityField.FieldNumber = "6"; if (field6Value != "999-99-9999") { socialSecurityField.FieldValue = field6Value; } else { socialSecurityField.FieldValue = "888-88-8888"; returnOptionObject.ErrorCode = 3; returnOptionObject.ErrorMesg = "The Social Security Number entered is not a valid number for Florida State Reporting.\n" + "The number entered will be replaced by 888-88-8888." + "If you know the correct Social Security Number, please go back and enter the appropriate information"; } #endregion #region Invalid Character in Address Field addressField.FieldNumber = "90"; if (field90Value.IndexOf("#") == -1) { addressField.FieldValue = field90Value; } else { addressField.FieldValue = field90Value.Replace("#", ""); returnOptionObject.ErrorCode = 3; returnOptionObject.ErrorMesg = "The address entered contains an invalid character ('#') for billing purposes.\n" + "The character will be removed from the address."; } #endregion #region Invalid Character in Name Field lastNameField.FieldNumber = "171"; if (field171Value.IndexOf("'") == -1 && field171Value.IndexOf("-") == -1) { lastNameField.FieldValue = field171Value; } else { lastNameField.FieldValue = field171Value.Replace("'", ""); lastNameField.FieldValue = lastNameField.FieldValue.Replace("-", ""); returnOptionObject.ErrorCode = 3; returnOptionObject.ErrorMesg = "The Last Name field contains an invalid character for billing purposes.\n" + "The character will be removed from the client's last name."; } #endregion if (isAdmissionScreen) { form510Fields[0] = socialSecurityField; form523Fields[0] = addressField; form523Fields[1] = lastNameField; currentRow1.Fields = form510Fields; currentRow1.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow1.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow1.RowAction = "EDIT"; form510.FormId = "510"; form510.CurrentRow = currentRow1; admissionForms[0] = form510; currentRow2.Fields = form523Fields; currentRow2.RowId = optionObject.Forms[1].CurrentRow.RowId; currentRow2.ParentRowId = optionObject.Forms[1].CurrentRow.ParentRowId; currentRow2.RowAction = "EDIT"; form523.FormId = "523"; form523.CurrentRow = currentRow2; admissionForms[1] = form523; returnOptionObject.Forms = admissionForms; } else { form14Fields[0] = socialSecurityField; form14Fields[1] = addressField; form14Fields[2] = lastNameField; currentRow1.Fields = form14Fields; currentRow1.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow1.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow1.RowAction = "EDIT"; form14.FormId = "14"; form14.CurrentRow = currentRow1; demoForms[0] = form14; returnOptionObject.Forms = demoForms; } returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.SystemCode = optionObject.SystemCode; returnOptionObject.Facility = optionObject.Facility; return returnOptionObject; }
public void SetFieldValue_OptionObject2_AreEqual() { string expected = "Test"; var fieldObject01 = new FieldObject { FieldNumber = "122" }; var fieldObject02 = new FieldObject { FieldNumber = "123" }; var fieldObject03 = new FieldObject { FieldNumber = "123" }; var fieldObject04 = new FieldObject { FieldNumber = "123" }; var rowObject01 = new RowObject { RowId = "1||1" }; rowObject01.Fields.Add(fieldObject01); var rowObject02 = new RowObject { RowId = "2||1" }; rowObject02.Fields.Add(fieldObject02); var rowObject03 = new RowObject { RowId = "2||2" }; rowObject03.Fields.Add(fieldObject03); var rowObject04 = new RowObject { RowId = "2||3" }; rowObject04.Fields.Add(fieldObject04); var formObject01 = new FormObject { FormId = "1", CurrentRow = rowObject01 }; var formObject02 = new FormObject { FormId = "2", CurrentRow = rowObject02 }; formObject02.OtherRows.Add(rowObject03); formObject02.OtherRows.Add(rowObject04); formObject02.MultipleIteration = true; var optionObject = new OptionObject2(); optionObject.Forms.Add(formObject01); optionObject.Forms.Add(formObject02); optionObject = (OptionObject2)OptionObjectHelpers.SetFieldValue(optionObject, "122", "Test"); string actual = OptionObjectHelpers.GetFieldValue(optionObject, "122"); Assert.AreEqual(expected, actual); }
private OptionObject MakeSubscriberPolicyRequired(OptionObject optionObject) { var subsPolicyNumField = new FieldObject { FieldNumber = "263" }; var guarantorID = new FieldObject { FieldNumber = "680" }; var guarantorList = ConfigurationManager.AppSettings["GuarantorsToMakeRequired"].ToString().Split(',').ToList(); var returnOptionObject = new OptionObject(); var currentRow = new RowObject(); var formObject = new FormObject(); var otherRows = new List<RowObject>(); try { if (guarantorList.IndexOf(optionObject.Forms[1].CurrentRow.Fields.First(f => f.FieldNumber == guarantorID.FieldNumber).FieldValue) >= 0) { var returnFieldSubPolicy = new FieldObject { FieldNumber = subsPolicyNumField.FieldNumber, FieldValue = optionObject.Forms[1].CurrentRow.Fields.First(f => f.FieldNumber == subsPolicyNumField.FieldNumber).FieldValue, Required = "1" }; currentRow.ParentRowId = optionObject.Forms[1].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; currentRow.RowId = optionObject.Forms[1].CurrentRow.RowId; var crFields = new FieldObject[1]; crFields[0] = returnFieldSubPolicy; currentRow.Fields = crFields; formObject.FormId = optionObject.Forms[1].FormId; formObject.CurrentRow = currentRow; } if (optionObject.Forms[1].OtherRows != null && optionObject.Forms[1].OtherRows.Length > 0) { formObject.MultipleIteration = optionObject.Forms[1].MultipleIteration; foreach (var otherRow in optionObject.Forms[1].OtherRows) { if (guarantorList.IndexOf(otherRow.Fields.First(f => f.FieldNumber == guarantorID.FieldNumber).FieldValue) >= 0) { var tempField = new FieldObject { FieldNumber = subsPolicyNumField.FieldNumber, FieldValue = otherRow.Fields.First(f => f.FieldNumber == subsPolicyNumField.FieldNumber).FieldValue, Required = "1" }; var orFields = new FieldObject[1]; orFields[0] = tempField; var tempOtherRow = new RowObject { ParentRowId = otherRow.ParentRowId, RowAction = "EDIT", RowId = otherRow.RowId, Fields = orFields }; otherRows.Add(tempOtherRow); } } } formObject.OtherRows = otherRows.ToArray(); var rForms = new FormObject[1]; rForms[0] = formObject; returnOptionObject.Forms = rForms; } catch (Exception e) { } returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.SystemCode = optionObject.SystemCode; returnOptionObject.Facility = optionObject.Facility; return returnOptionObject; }
public void SelectFeaturesFromBaseLyr(IPolygon polygon) { float h = float.Parse(this.textBox2.Text); IFdeCursor cursor = null; try { axRenderControl1.FeatureManager.UnhighlightAll(); IRowBuffer row = null; List <IRowBuffer> list = new List <IRowBuffer>(); foreach (IFeatureClass fc in fcMap.Keys) { if (!fc.Name.Equals("建筑")) { continue; } ISpatialFilter filter = new SpatialFilter(); filter.Geometry = polygon; filter.SpatialRel = gviSpatialRel.gviSpatialRelIntersects; //不相离 filter.GeometryField = "Polygon"; cursor = fc.Search(filter, false); while ((row = cursor.NextRow()) != null) { list.Add(row); } foreach (IRowBuffer r in list) { string fid = ""; string fName = ""; string groupId = ""; IEnvelope env = null; IGeometry ge = null; IModelPoint mp = null; float hhh = 0; int geometryIndex = -1; geometryIndex = r.FieldIndex("Polygon"); if (geometryIndex != -1) { int storeyIndex = r.FieldIndex("storey"); int storey = int.Parse(r.GetValue(storeyIndex).ToString()); int heightIndex = r.FieldIndex("height"); float hh = float.Parse(r.GetValue(heightIndex).ToString()); hhh = hh * storey; if (hhh > h) { for (int i = 0; i < r.FieldCount; i++) { if (r.Fields.Get(i).Name == "oid") { fid = r.GetValue(i).ToString(); } else if (r.Fields.Get(i).Name == "groupid") { groupId = r.GetValue(i).ToString(); } else if (r.Fields.Get(i).Name == "Name") { fName = r.GetValue(i).ToString(); } else if (r.Fields.Get(i).Name == "Geometry") { ge = r.GetValue(i) as IModelPoint; env = ge.Envelope; mp = r.GetValue(i) as IModelPoint; } } RowObject ro = new RowObject() { FID = fid, GroupId = groupId, Name = fName, FeatureClass = fc, Envelop = env, Height = hhh.ToString(), Modelpoint = mp }; if (!rowMap.ContainsKey(ro.FID)) { rowMap.Add(ro.FID, ro); } int hfid = int.Parse(ro.FID); //高亮显示违章建筑 axRenderControl1.FeatureManager.HighlightFeature(fc, hfid, System.Drawing.Color.Yellow); } } } // end of foreach (IRowBuffer r in list) } // end of foreach (IFeatureClass fc in fcMap.Keys) LoadGridView(); } catch (COMException ex) { System.Diagnostics.Trace.WriteLine(ex.Message); } finally { if (cursor != null) { //Marshal.ReleaseComObject(cursor); cursor = null; } } }
private FormObject GetFormContainingRow(RowObject row) { FormObject form = optionObject.Forms.FirstOrDefault(f => f.CurrentRow.Equals(row)); return form; }
private void list2() { // 1. 拼Sql子语句 string select = string.Format("select top {0} * ", Request["limit"]); string from = " from sq8szxlx.zpgl "; string where = " where 合同开始时间< getdate() and 合同结束时间>getdate() "; string order = " order by 所属工业园,房产类型,所属房产 asc "; if (Common.hasValue(Request.Params["mc"])) { where += string.Format(" and 客户名称 like '%{0}%'", Request.Params["mc"]); } if (Common.hasValue(Request.Params["gyy"])) { where += string.Format(" and 所属工业园='{0}'", Request.Params["gyy"]); } if (Common.hasValue(Request.Params["gyy_lx"])) { where += string.Format(" and 房产类型='{0}'", Request.Params["gyy_lx"]); } if (Common.hasValue(Request.Params["hm"])) { where += string.Format(" and 编码 like '%{0}%'", Request.Params["hm"]); } // 2. 获取总数 string count = DBHelper.GetVar("select count(*) " + from + where).ToString(); if (count == null) { return; } // 3. 获取数据 string sql = string.Format(@"{0} {1} {2} and id not in (select top {3} id {1} {2} {4}) {4}", select, from, where, Request.Params["start"], order); // 4. 拼装结果 ResultObject ro = DBHelper.GetResult(sql); foreach (RowObject row in ro) { row["房产类型"] = row["所属房产"]; row["合同结束时间"] = row["合同结束时间"] is DBNull ? "未签订合同" : row["合同结束时间"]; row["录入月份"] = Request.Form["nian"] + "/" + Request.Form["yue"]; sql = string.Format("select * from sq8szxlx.user_sf_zb where 合同编号='{0}' and 日期年='{1}' and 日期月='{2}'", row["编码"], Request.Form["nian"], Request.Form["yue"]); RowObject row2 = DBHelper.GetRow(sql); if (row2 != null) { row["录入状态"] = "已录入"; } else { row["录入状态"] = "未录入"; } if (row2 != null) { row["缴费状态"] = row2["缴费状态"]; } else { row["缴费状态"] = "未缴费"; } } string data = ro.ToJson(); string result = string.Format("success:true,totalProperty:{0},data:", count, sql); result = "{" + result + data + "}"; Response.Write(result); }
private OptionObject cantSelectHomeless(OptionObject optionObject, String scriptName) { var formSelcected = optionObject.Forms.FirstOrDefault(f => f.FormId == "511"); var rowSelected = formSelcected.CurrentRow; var fieldSelected = rowSelected.Fields.FirstOrDefault(f => f.FieldNumber == "153"); OptionObject oo = new OptionObject(); FormObject fo = new FormObject(); RowObject ro = new RowObject(); if (fieldSelected.FieldValue == "99") { oo.ErrorCode = 1; oo.ErrorMesg = "WARNING!!! Can't select this value if selected Homeless above"; } ro.RowId = rowSelected.RowId; ro.ParentRowId = rowSelected.ParentRowId; ro.RowAction = "EDIT"; fo.FormId = formSelcected.FormId; fo.MultipleIteration = formSelcected.MultipleIteration; List<FormObject> listOfForms = new List<FormObject>(); listOfForms.Add(fo); oo.EntityID = optionObject.EntityID; oo.OptionId = optionObject.OptionId; oo.Facility = optionObject.Facility; oo.SystemCode = optionObject.SystemCode; oo.Forms = listOfForms.ToArray(); return oo; }
/** <summary>Adds an object to the current row.</summary> <param name="obj">Object to add.</param> <param name="lineAlignment">Object's line alignment.</param> */ private void AddRowObject( RowObject obj, object lineAlignment ) { currentRow.Objects.Add(obj); currentRow.SpaceCount += obj.SpaceCount; currentRow.Width += obj.Width; if(lineAlignment is double || lineAlignment.Equals(LineAlignmentEnum.BaseLine)) { double gap = (lineAlignment is double ? (Double)lineAlignment : 0); double superGap = obj.BaseLine + gap - currentRow.BaseLine; if(superGap > 0) { currentRow.Height += superGap; currentRow.BaseLine += superGap; } double subGap = currentRow.BaseLine + (obj.Height - obj.BaseLine) - gap - currentRow.Height; if(subGap > 0) {currentRow.Height += subGap;} } else if(obj.Height > currentRow.Height) {currentRow.Height = obj.Height;} }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_id"] == null) { throw new SessionLostException(); } string action = Request.Params["action"]; if (String.IsNullOrEmpty(action)) { return; } Response.ContentType = "application/json"; if (action == "list") { Response.Write(DBHelper.GetResult("select * from sq8szxlx.role").ToJson()); } else if (action == "add") { string sql = SqlBuilder.NameValueToSql(Request.Form, "sq8szxlx.role", "id", true); DBHelper.ExecuteSql(sql); string sql_1 = string.Format("insert into sq8szxlx.role_lb (role_name) values ('{0}')", Request.Form["role_name"]); DBHelper.ExecuteSql(sql_1); Response.Write("{success: true}"); } else if (action == "update") { string sql = SqlBuilder.NameValueToSql(Request.Form, "sq8szxlx.role", "id", false); DBHelper.ExecuteSql(sql); Response.Write("{success: true}"); } else if (action == "delete") { string sql = "delete from sq8szxlx.role where id=" + Request.Form["id"]; DBHelper.ExecuteSql(sql); Response.Write("{success: true}"); } else if (action == "set") { string role_name = Request.Params["role_name"]; string sql = string.Format("select * from sq8szxlx.role_lb where role_name='{0}' ", role_name); RowObject row = DBHelper.GetRow(sql); if (row != null) { Response.Write(string.Format("{{ success:true,data: {0} }}", row.ToJson())); } else { Response.Write("{ success:false,errorMessage: 'data not found' }"); } } else if (action == "updatePermissions") { string sql = "update sq8szxlx.role_lb set "; string[] allFields = new string[] { "数据录入", "缴费管理", "工业园管理", "房产管理", "客户管理", "预定管理", "租凭合同管理", "合同到期提示", "收款分类统计", "收款详细统计", "角色权限", "管理员管理", "修改本身密码", "修改录入" }; foreach (string item in allFields) { string value = "0"; if (Request.Params[item] != null && Request.Params[item] == "on") { value = "1"; } sql += item + "=" + value + ','; } sql = sql.Substring(0, sql.Length - 1); sql += string.Format(" where id='{0}' and role_name='{1}'", Request.Params["id"], Request.Params["role_name"]); DBHelper.ExecuteSql(sql); Response.Write("{success: true}"); } Response.End(); }
private void Populate(object state) { var entries = mEntries; if (entries.Any()) { var unionOfFields = new Dictionary <string, ProtectedString>(); var fieldOrder = new List <string>(new[] { PwDefs.TitleField, PwDefs.UserNameField, PwDefs.PasswordField, PwDefs.UrlField }); // Prepopulate order with fields that should appear first. Other fields will be added in the order in which they are encountered var firstEntry = true; foreach (var entry in entries) { if (!Object.ReferenceEquals(entries, mEntries)) { // Entries has changed, so abort this population return; } foreach (var field in entry.Strings) { if (!IsExcludedField(field.Key)) { var multipleValues = field.Value.IsProtected ? mMultipleProtectedValues : mMultipleValues; ProtectedString existingValue; if (!unionOfFields.TryGetValue(field.Key, out existingValue)) { if (!firstEntry || // If this isn't the first entry, then the fact that previous entries didn't have a value for this field means that it counts as multiple. ShouldHideValue(field.Key, field.Value)) // If it's a hidden value, then always count it as multiple without reading (and therefore unprotecting) the value { unionOfFields.Add(field.Key, multipleValues); } else { unionOfFields.Add(field.Key, field.Value); } if (!PwDefs.IsStandardField(field.Key)) { fieldOrder.Add(field.Key); } } else { if (existingValue != mMultipleProtectedValues && existingValue != mMultipleValues) { if (ShouldHideValue(field.Key, field.Value)) // If it's a hidden value, then always count it as multiple without reading (and therefore unprotecting) the value { unionOfFields[field.Key] = multipleValues; } else { System.Diagnostics.Debug.Assert(!ShouldHideValue(field.Key, field.Value) && !ShouldHideValue(field.Key, existingValue), "Unnecessary reading of in-memory protected strings"); if (!existingValue.ReadString().Equals(field.Value.ReadString(), StringComparison.Ordinal)) // No longer consistent { // Mark it as a field with multiple values. unionOfFields[field.Key] = multipleValues; } } } } } } // Any fields which aren't on this entry now count as multiple var absentFields = new List <KeyValuePair <String, ProtectedString> >(unionOfFields.Count); foreach (var existingField in unionOfFields) { var multipleValues = existingField.Value.IsProtected ? mMultipleProtectedValues : mMultipleValues; // Keep the same protection state, so that the right editor can be used if (existingField.Value != multipleValues && !entry.Strings.Exists(existingField.Key)) { absentFields.Add(new KeyValuePair <String, ProtectedString>(existingField.Key, multipleValues)); } } foreach (var absentField in absentFields) { unionOfFields[absentField.Key] = absentField.Value; } firstEntry = false; } var rows = new List <RowObject>(unionOfFields.Count + 1); // Add all the fields, in the right order foreach (var fieldName in fieldOrder) { ProtectedString value; if (unionOfFields.TryGetValue(fieldName, out value)) { rows.Add(new RowObject(fieldName, value)); } } // Then add an empty "add new" row rows.Add(RowObject.CreateInsertionRow()); BeginInvoke(new Action(delegate { if (Object.ReferenceEquals(entries, mEntries)) // Final guard against repopulation { SetRows(rows); AllowCreateHistoryNow = true; // Whenever the entries are replaced, it counts as not having been edited yet (so the first edit is always given a history backup) } })); } }
public bool IsMultiValuedField(RowObject rowObject) { return(rowObject.Value == mMultipleValues || rowObject.Value == mMultipleProtectedValues); }
private void edit_gdxfx2() { // 1. 查合同信息 string responseError = "{success: false}"; string sql = string.Format("select * from sq8szxlx.zpgl where id='{0}'", Request.Params["id"]); RowObject r1 = DBHelper.GetRow(sql); if (r1 == null) { Response.Write(responseError); Response.End(); return; } string gyy_mc = r1["所属工业园"].ToString(); string fclx = r1["房产类型"].ToString(); string htbh = r1["编码"].ToString(); // 2. 查zpgl_lx_lb看是否有记录 sql = string.Format("select * from sq8szxlx.zpgl_lx_lb where 合同编号='{0}'", htbh); ResultObject zpgl_lx_lb = DBHelper.GetResult(sql); if (zpgl_lx_lb.Count <= 0) // 没有记录则从gyy_lb_fclx_lb_xflx复制一份 { sql = string.Format("select * from sq8szxlx.gyy_lb_fclx_lb_xflx where 工业园名称='{0}' and 房产类型='{1}' order by 序号 asc", gyy_mc, fclx); ResultObject gyy_lb_fclx_lb_xflx = DBHelper.GetResult(sql); foreach (RowObject item in gyy_lb_fclx_lb_xflx) { NameValueCollection nvc = new NameValueCollection(); nvc.Add("合同编号", htbh); nvc.Add("客户编码", r1["客户编码"].ToString()); nvc.Add("所属工业园", gyy_mc); nvc.Add("房产类型", fclx); nvc.Add("所属房产", r1["所属房产"].ToString()); nvc.Add("客户名称", r1["客户名称"].ToString()); nvc.Add("消费项目", item["消费项目"].ToString()); nvc.Add("消费类型", item["消费类型"].ToString()); nvc.Add("值", item["值"].ToString()); nvc.Add("倍率", item["倍率"].ToString()); nvc.Add("损耗", item["损耗"].ToString()); nvc.Add("滞纳金", item["滞纳金"].ToString()); nvc.Add("说明", item["说明"].ToString()); string insertSql = SqlBuilder.NameValueToSql(nvc, "sq8szxlx.zpgl_lx_lb", "id", true); DBHelper.ExecuteSql(insertSql); } zpgl_lx_lb = DBHelper.GetResult(sql);// 重新查询 } // 合成数据 int i = 1; foreach (RowObject item in zpgl_lx_lb) { string xfxm = item["消费项目"].ToString(); string rq = r1["合同开始时间"].ToString(); sql = string.Format("select * from sq8szxlx.user_sf_lb where 合同编号='{0}' and 收费项目='{1}' and 日期='{2}'", htbh, xfxm, rq); RowObject r4 = DBHelper.GetRow(sql); if (r4 == null) { item.Add("编号", i); item.Add("前期读数", item["消费类型"].ToString() == "动态" ? "-" : ""); item.Add("读数导入", "×"); item.Add("项目导入", "×"); i++; } else { item.Add("编号", i); item.Add("前期读数", item["消费类型"].ToString() == "动态" ? r4["读数"] : "-"); item.Add("读数导入", (r4 != null && r4["录入状态"].ToString() == "已录入") ? "√" : "×"); item.Add("项目导入", (r4 != null && r4["值"] != "") ? "√" : "×"); i++; } } Response.Write(string.Format("{{'success': true, 'data':{0}}}", JsonConvert.SerializeObject(zpgl_lx_lb))); }
private OptionObject TreatmentPlan(OptionObject optionObject) { OptionObject returnOptionObject = new OptionObject(); FieldObject planNameDict = new FieldObject(); planNameDict.FieldNumber = "52134"; FieldObject planName = new FieldObject(); planName.FieldNumber = "52002"; foreach (var form in optionObject.Forms) { foreach (var field in form.CurrentRow.Fields) { if (field.FieldNumber.Equals(planNameDict.FieldNumber)) planNameDict.FieldValue = field.FieldValue; if (field.FieldNumber.Equals(planName.FieldNumber)) planName.FieldValue = field.FieldValue; } } planName.Enabled = "0"; planName.FieldValue = getTreatmentPlanName(planNameDict.FieldValue); var fields = new FieldObject[1]; var forms = new FormObject[1]; var formObject = new FormObject(); var currentRow = new RowObject(); fields[0] = planName; currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; formObject.FormId = "52001"; formObject.CurrentRow = currentRow; forms[0] = formObject; returnOptionObject.Forms = forms; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.SystemCode = optionObject.SystemCode; return returnOptionObject; }
/// <summary> /// Adds a <see cref="RowObject"/> to a <see cref="FormObject"/> in this <see cref="OptionObject2015"/>. /// </summary> /// <param name="formId"></param> /// <param name="rowObject"></param> public void AddRowObject(string formId, RowObject rowObject) => this.Forms = OptionObjectHelpers.AddRowObject(this, formId, rowObject).Forms;
private OptionObject AddDurationAndTime(OptionObject optionObject, String ScriptName) { String[] temp = ScriptName.Split(','); var returnOptionObject = new OptionObject(); var formObject = new FormObject(); var startTimeField = new FieldObject(); var endTimeField = new FieldObject(); var durationField = new FieldObject(); try { formObject.FormId = temp[1]; startTimeField.FieldNumber = temp[2]; endTimeField.FieldNumber = temp[3]; durationField.FieldNumber = temp[4]; foreach (var form in optionObject.Forms) { foreach (var field in form.CurrentRow.Fields) { if (field.FieldNumber.Equals(startTimeField.FieldNumber)) startTimeField.FieldValue = field.FieldValue; if (field.FieldNumber.Equals(endTimeField.FieldNumber)) endTimeField.FieldValue = field.FieldValue; if (field.FieldNumber.Equals(durationField.FieldNumber)) durationField.FieldValue = field.FieldValue; } } if (temp[5].Equals("Dur")) { durationField.FieldValue = ChangeDuration(DateTime.Parse(startTimeField.FieldValue), DateTime.Parse(endTimeField.FieldValue)).TotalMinutes.ToString(); } else { endTimeField.FieldValue = ChangeEndTime(DateTime.Parse(startTimeField.FieldValue), Double.Parse(durationField.FieldValue)).ToString("hh:mm tt"); } var fields = new FieldObject[1]; fields[0] = temp[5].Equals("Dur") ? durationField : endTimeField; var currentRow = new RowObject(); currentRow.Fields = fields; foreach (var form in optionObject.Forms) { if (form.FormId.Equals(formObject.FormId)) { currentRow.RowId = form.CurrentRow.RowId; currentRow.ParentRowId = form.CurrentRow.ParentRowId; } } currentRow.RowAction = "EDIT"; formObject.CurrentRow = currentRow; var forms = new FormObject[1]; forms[0] = formObject; returnOptionObject.Forms = forms; } catch (Exception e) { } returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.SystemCode = optionObject.SystemCode; returnOptionObject.Facility = optionObject.Facility; return returnOptionObject; }
/// <summary> /// Marks a <see cref="RowObject"/> for deletion. /// </summary> /// <param name="rowObject"></param> public void DeleteRowObject(RowObject rowObject) => this.Forms = OptionObjectHelpers.DeleteRowObject(this, rowObject).Forms;
private void fltj() { string gyy = Request.Params["gyy"]; string gyy_fclx = Request.Params["gyy_lx"]; string gyy_xfxm = Request.Params["xfxm"]; string nian = Request.Params["nian"]; string yue = Request.Params["yue"]; bool xfxtj = Request.Params["xfxtj"] == "true"?true:false; // 1. 查询工业园 string sql = string.Format("select * from sq8szxlx.gyy_lb "); if (Common.hasValue(gyy)) { sql = string.Format("select * from sq8szxlx.gyy_lb where 工业园名称='{0}'", gyy); } string where_fclx = Common.hasValue(gyy_fclx) ? string.Format(" and z.房产类型='{0}'", gyy_fclx) : ""; string where_xfxm = Common.hasValue(gyy_xfxm) ? string.Format(" and u.收费项目='{0}'", gyy_xfxm) : ""; string where_nian = Common.hasValue(nian) ? string.Format(" and u.日期年='{0}'", nian) : ""; string where_yue = Common.hasValue(yue) ? string.Format(" and u.日期月='{0}'", yue) : ""; ResultObject gyy_lb = DBHelper.GetResult(sql); JSONArray ja = new JSONArray(); int k = 0; for (int i = 0; i < gyy_lb.Count; i++) { RowObject row = gyy_lb[i]; string gyy_mc = row["工业园名称"].ToString(); string fclx = Common.hasValue(gyy_fclx) ?gyy_fclx:"(全部)"; string xfxm = Common.hasValue(gyy_xfxm) ? gyy_xfxm : "(全部)"; string yf = Common.hasValue(yue) ? yue : "(全部)"; if (xfxtj && !Common.hasValue(gyy_xfxm)) { // 查询工业园所有消费项 sql = string.Format(" select distinct 消费项目 as sfxm from sq8szxlx.zpgl_lx_lb where 房产类型='厂房' and 所属工业园='{0}'", gyy_mc); ResultObject zpgl_lx_lb = DBHelper.GetResult(sql); for (int j = 0; j < zpgl_lx_lb.Count; j++) //详细统计 { k++; RowObject row2 = zpgl_lx_lb[j]; where_xfxm = string.Format(" and u.收费项目='{0}'", row2["sfxm"]); string sql_sf = string.Format(@"select sum(u.费用) as total from sq8szxlx.user_sf_lb u left join sq8szxlx.zpgl z on u.合同编号=z.编码 left join sq8szxlx.user_sf_zb zb on zb.合同编号=u.合同编号 and zb.日期年=u.日期年 and zb.日期月=u.日期月 where zb.缴费状态<>'未缴费' and z.所属工业园='{0}' {1} {2} {3} {4}" , gyy_mc, where_fclx, where_xfxm, where_nian, where_yue); object total = DBHelper.GetVar(sql_sf); JSONObject jo = new JSONObject(); jo.Add("序号", k); jo.Add("工业园名称", gyy_mc); jo.Add("房产类型", fclx); jo.Add("消费项目", row2["sfxm"]); jo.Add("月份", yf); jo.Add("费用", Math.Round(Convert.ToDouble(total), 0)); ja.Add(jo); } } else { //分类统计 // 2. 查询合同 string sql_sf = string.Format(@"select sum(u.费用) as total from sq8szxlx.user_sf_lb u left join sq8szxlx.zpgl z on u.合同编号=z.编码 left join sq8szxlx.user_sf_zb zb on zb.合同编号=u.合同编号 and zb.日期年=u.日期年 and zb.日期月=u.日期月 where zb.缴费状态<>'未缴费' and z.所属工业园='{0}' {1} {2} {3} {4}" , gyy_mc, where_fclx, where_xfxm, where_nian, where_yue); object total = DBHelper.GetVar(sql_sf); JSONObject jo = new JSONObject(); jo.Add("序号", i + 1); jo.Add("工业园名称", gyy_mc); jo.Add("房产类型", fclx); jo.Add("消费项目", xfxm); jo.Add("月份", yf); jo.Add("费用", Math.Round(Convert.ToDouble(total), 0)); ja.Add(jo); } } Response.Write(JSONConvert.SerializeArray(ja)); }
/** * <summary>Ends the content row.</summary> * <param name="broken">Indicates whether this is the end of a paragraph.</param> */ private void EndRow( bool broken ) { if (rowEnded) { return; } rowEnded = true; List <RowObject> objects = currentRow.Objects; double[] objectXOffsets = new double[objects.Count]; // Horizontal object displacements. double wordSpace = 0; // Exceeding space among words. double rowXOffset = 0; // Horizontal row offset. // Horizontal alignment. XAlignmentEnum xAlignment = this.xAlignment; switch (xAlignment) { case XAlignmentEnum.Left: break; case XAlignmentEnum.Right: rowXOffset = frame.Width - currentRow.Width; break; case XAlignmentEnum.Center: rowXOffset = (frame.Width - currentRow.Width) / 2; break; case XAlignmentEnum.Justify: if (currentRow.SpaceCount == 0 || broken) // NO spaces. { /* NOTE: This situation equals a simple left alignment. */ xAlignment = XAlignmentEnum.Left; } else // Spaces exist. { // Calculate the exceeding spacing among the words! wordSpace = (frame.Width - currentRow.Width) / currentRow.SpaceCount; // Define the horizontal offsets for justified alignment. for ( int index = 1, count = objects.Count; index < count; index++ ) { /* * NOTE: The offset represents the horizontal justification gap inserted at the left * side of each object. */ objectXOffsets[index] = objectXOffsets[index - 1] + objects[index - 1].SpaceCount * wordSpace; } } currentRow.WordSpaceAdjustment.Value = wordSpace; break; } // Vertical alignment and translation. for ( int index = objects.Count - 1; index >= 0; index-- ) { RowObject obj = objects[index]; // Vertical alignment. double objectYOffset = 0; { LineAlignmentEnum lineAlignment; double lineRise; { object objectLineAlignment = obj.LineAlignment; if (objectLineAlignment is Double) { lineAlignment = LineAlignmentEnum.BaseLine; lineRise = (double)objectLineAlignment; } else { lineAlignment = (LineAlignmentEnum)objectLineAlignment; lineRise = 0; } } switch (lineAlignment) { case LineAlignmentEnum.Top: /* NOOP */ break; case LineAlignmentEnum.Middle: objectYOffset = -(currentRow.Height - obj.Height) / 2; break; case LineAlignmentEnum.BaseLine: objectYOffset = -(currentRow.BaseLine - obj.BaseLine - lineRise); break; case LineAlignmentEnum.Bottom: objectYOffset = -(currentRow.Height - obj.Height); break; default: throw new NotImplementedException("Line alignment " + lineAlignment + " unknown."); } } IList <ContentObject> containedGraphics = obj.Container.Objects; // Translation. containedGraphics.Insert( 0, new ModifyCTM( 1, 0, 0, 1, objectXOffsets[index] + rowXOffset, // Horizontal alignment. objectYOffset // Vertical alignment. ) ); // Word spacing. if (obj.Type == RowObject.TypeEnum.Text) { /* * TODO: This temporary hack adjusts the word spacing in case of composite font. * When DocumentComposer replaces BlockComposer, all the graphical properties of contents * will be declared as styles and their composition will occur as a single pass without such * ugly tweakings. */ ShowText showTextOperation = (ShowText)((Text)((LocalGraphicsState)containedGraphics[1]).Objects[1]).Objects[1]; if (showTextOperation is ShowAdjustedText) { PdfInteger wordSpaceObject = PdfInteger.Get((int)Math.Round(-wordSpace * 1000 * obj.Scale / obj.FontSize)); PdfArray textParams = (PdfArray)showTextOperation.Operands[0]; for (int textParamIndex = 1, textParamsLength = textParams.Count; textParamIndex < textParamsLength; textParamIndex += 2) { textParams[textParamIndex] = wordSpaceObject; } } } } // Update the actual block height! boundBox.Height = (float)(currentRow.Y + currentRow.Height); // Update the actual block vertical location! double yOffset; switch (yAlignment) { case YAlignmentEnum.Bottom: yOffset = frame.Height - boundBox.Height; break; case YAlignmentEnum.Middle: yOffset = (frame.Height - boundBox.Height) / 2; break; case YAlignmentEnum.Top: default: yOffset = 0; break; } boundBox.Y = (float)(frame.Y + yOffset); // Discard the current row! currentRow = null; }
private void lr_tj() { JArray ja1 = JArray.Parse(Request.Form["data"]); string year = Request.Params["year"]; string month = Request.Params["month"]; string responseError = "{success: false}"; string sql1 = string.Format("select * from sq8szxlx.zpgl where id='{0}'", Request.Params["htid"]); RowObject zpgl = DBHelper.GetRow(sql1); if (zpgl == null) { Response.Write(responseError); Response.End(); return; } string gyy_mc = zpgl["所属工业园"].ToString(); string fclx = zpgl["房产类型"].ToString(); string ssfc = zpgl["所属房产"].ToString(); string htbh = zpgl["编码"].ToString(); string khbm = zpgl["客户编码"].ToString(); string khmc = zpgl["客户名称"].ToString(); int xh = Convert.ToInt32(Request.Params["xh"]); double zfy = 0; // 清除数据 sql1 = string.Format("delete from sq8szxlx.user_sf_lb where 单据编号='{0}_{1}'", htbh, xh); DBHelper.ExecuteSql(sql1); sql1 = string.Format("delete from sq8szxlx.user_sf_zb where 单据编号='{0}_{1}'", htbh, xh); DBHelper.ExecuteSql(sql1); // 新增数据 string sql2 = string.Format("select * from sq8szxlx.zpgl_lx_lb where 合同编号='{0}' order by id asc", zpgl["编码"]); ResultObject zpgl_lx_lb = DBHelper.GetResult(sql2); for (int i = 0; i < zpgl_lx_lb.Count; i++) { JToken jo = ja1[i]; // TODO: 要确定ja是否和查出数据一一对应 string xflx = jo["消费类型"].ToString(); RowObject item = zpgl_lx_lb[i]; // user_sf_lb Dictionary <string, object> nv2 = new Dictionary <string, object>(); nv2.Add("合同编号", htbh); nv2.Add("单据编号", htbh + "_" + Request.Params["xh"]); nv2.Add("客户编号", khbm); nv2.Add("日期年", year); nv2.Add("日期月", month); nv2.Add("日期日", DateTime.Now.Day); nv2.Add("日期", DateTime.Now.ToShortDateString()); nv2.Add("收费项目", jo["消费项目"].ToString()); nv2.Add("收费类型", jo["消费类型"].ToString()); nv2.Add("值", jo["值"].ToString()); nv2.Add("录入状态", (xflx == "动态" && jo["读数"].ToString() == "") ? "未录入" : "已录入");// TODO: 正确? nv2.Add("缴费状态", "未缴费"); nv2.Add("损耗", xflx == "动态" ? jo["损耗"] : 0); nv2.Add("读数", (xflx == "动态" || xflx == "单价") ? jo["读数"].ToString() : "0"); nv2.Add("倍率", jo["倍率"]); nv2.Add("滞纳金", jo["滞纳金"]); //// 查询上月收费项目 string pre_sql_lb = string.Format(@"select * from sq8szxlx.user_sf_lb where 单据编号='{0}_{1}' and 收费项目='{2}'", zpgl["编码"], xh - 1, item["消费项目"]); RowObject pre_user_sf_lb = DBHelper.GetRow(pre_sql_lb); if (pre_user_sf_lb == null) // 没有上月读数信息,读取序号为1的单据(前期读数) { pre_sql_lb = string.Format(@"select * from sq8szxlx.user_sf_lb where 单据编号='{0}_{1}' and 收费项目='{2}'", zpgl["编码"], 1, item["消费项目"]); pre_user_sf_lb = DBHelper.GetRow(pre_sql_lb); } double ds_sy = (pre_user_sf_lb != null && pre_user_sf_lb["读数"].ToString() != "-") ? Convert.ToDouble(pre_user_sf_lb["读数"].ToString()) : 0; double ds = hasNumber(jo["读数"]) ? Convert.ToDouble(jo["读数"].ToString()):0; double zi = hasNumber(jo["值"]) ? Convert.ToDouble(jo["值"].ToString()):0; double znj = hasNumber(jo["滞纳金"]) ? Convert.ToDouble(jo["滞纳金"].ToString()):0; double sh = hasNumber(jo["损耗"]) ? Convert.ToDouble(jo["损耗"].ToString()):0; double bl = hasNumber(jo["倍率"]) ? Convert.ToDouble(jo["倍率"].ToString()):0; double fy = -1; if (bl != 0) { if (xflx == "动态") { fy = (ds - ds_sy) * zi * (1 + znj / 100) * (1 + sh / 100) * bl; } else if (xflx == "单价") { fy = ds_sy * zi * (1 + znj / 100) * bl; } else if (xflx == "固定") { fy = zi * (1 + znj / 100) * bl; } else if (xflx == "递增") { fy = (zi * (xh - 1)) * (1 + znj / 100) * bl; } } else { if (xflx == "动态") { fy = (ds - ds_sy) * zi * (1 + znj / 100) * (1 - (-sh) / 100); } else if (xflx == "单价") { fy = ds * zi * (1 + znj / 100); } else if (xflx == "固定") { fy = zi * (1 + znj / 100); } else if (xflx == "递增") { fy = ((zi)) * (xh - 1) * (1 + znj / 100); } } zfy += fy; nv2.Add("费用", fy == -1 ? '-' : fy); nv2.Add("金额", 0); string sql4 = SqlBuilder.NameValueToSql(nv2, "sq8szxlx.user_sf_lb", "id", true); Debug.WriteLine(sql4); DBHelper.ExecuteSql(sql4); } // user_sf_zb Dictionary <string, object> nv3 = new Dictionary <string, object>(); nv3.Add("合同编号", htbh); nv3.Add("单据编号", htbh + "_" + Request.Params["xh"]); nv3.Add("客户编号", khbm); nv3.Add("日期年", year); nv3.Add("日期月", month); nv3.Add("日期日", DateTime.Now.Day); nv3.Add("日期", DateTime.Now.ToShortDateString()); nv3.Add("总费用", zfy); nv3.Add("缴费金额", 0); // 查询上月收费项目 string sql5 = string.Format("select * from sq8szxlx.user_sf_zb where 单据编号='{0}_{1}'", htbh, int.Parse(Request.Params["xh"]) - 1); RowObject user_sf_zb = DBHelper.GetRow(sql5); nv3.Add("余额", user_sf_zb["余额"]); nv3.Add("录入状态", "已录入"); nv3.Add("缴费状态", "未缴费"); string sql6 = SqlBuilder.NameValueToSql(nv3, "sq8szxlx.user_sf_zb", "id", true); Debug.WriteLine(sql6); DBHelper.ExecuteSql(sql6); Response.Write("{success:true}"); }
public void RowObject_HasFieldsObject() { RowObject rowObject = new RowObject(); Assert.IsNotNull(rowObject.Fields); }
/** * <summary>Shows text.</summary> * <param name="text">Text to show.</param> * <param name="lineAlignment">Line alignment. It can be: * <list type="bullet"> * <item><see cref="LineAlignmentEnum"/></item> * <item><see cref="Length">: arbitrary super-/sub-script, depending on whether the value is * positive or not.</item> * </list> * </param> * <returns>Last shown character index.</returns> */ public int ShowText( string text, object lineAlignment ) { if (currentRow == null || text == null) { return(0); } ContentScanner.GraphicsState state = baseComposer.State; fonts::Font font = state.Font; double fontSize = state.FontSize; double lineHeight = font.GetLineHeight(fontSize); double baseLine = font.GetAscent(fontSize); lineAlignment = ResolveLineAlignment(lineAlignment); TextFitter textFitter = new TextFitter( text, 0, font, fontSize, hyphenation, hyphenationCharacter ); int textLength = text.Length; int index = 0; while (true) { if (currentRow.Width == 0) // Current row has just begun. { // Removing leading space... while (true) { if (index == textLength) // Text end reached. { goto endTextShowing; } else if (text[index] != ' ') // No more leading spaces. { break; } index++; } } if (OperationUtils.Compare(currentRow.Y + lineHeight, frame.Height) == 1) // Text's height exceeds block's remaining vertical space. { // Terminate the current row and exit! EndRow(false); goto endTextShowing; } // Does the text fit? if (textFitter.Fit( index, frame.Width - currentRow.Width, // Remaining row width. currentRow.SpaceCount == 0 )) { // Get the fitting text! string textChunk = textFitter.FittedText; double textChunkWidth = textFitter.FittedWidth; PointF textChunkLocation = new PointF( (float)currentRow.Width, (float)currentRow.Y ); // Insert the fitting text! RowObject obj; { obj = new RowObject( RowObject.TypeEnum.Text, baseComposer.BeginLocalState(), // Opens the row object's local state. lineHeight, textChunkWidth, CountOccurrence(' ', textChunk), lineAlignment, baseLine ); baseComposer.ShowText(textChunk, textChunkLocation); baseComposer.End(); // Closes the row object's local state. } AddRowObject(obj, lineAlignment); index = textFitter.EndIndex; } // Evaluating trailing text... while (true) { if (index == textLength) // Text end reached. { goto endTextShowing; } switch (text[index]) { case '\r': break; case '\n': // New paragraph! index++; ShowBreak(); goto endTrailParsing; default: // New row (within the same paragraph)! EndRow(false); BeginRow(); goto endTrailParsing; } index++; } endTrailParsing :; } endTextShowing :; if (index >= 0 && lineAlignment.Equals(LineAlignmentEnum.BaseLine)) { lastFontSize = fontSize; } return(index); }
protected virtual CustomRowObject TransformRow(RowObject row) { return(new RowObjectTransform().TransformToCustomRowObject(row)); }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_id"] == null) { throw new SessionLostException(); } string action = Request.Params["action"]; if (String.IsNullOrEmpty(action)) { return; } Response.ContentType = "application/json"; if (action == "list") { string select = string.Format(@"select top {0} * ", Request["limit"]); string from = " from sq8szxlx.zpgl "; string where = " where 合同结束时间_年 is not null "; string order = " order by 所属工业园,房产类型,所属房产 asc "; if (Common.hasValue(Request.Params["iFieldName"])) { where += string.Format(" and 客户名称 like '%{0}%' ", Request.Params["iFieldName"]); } if (Common.hasValue(Request.Params["iFieldNo"])) { where += string.Format(" and 编码 like '%{0}%' ", Request.Params["iFieldNo"]); } if (Common.hasValue(Request.Params["gyy"])) { where += string.Format(" and 所属工业园='{0}' ", Request.Params["gyy"]); } if (Common.hasValue(Request.Params["leix"])) { where += string.Format(" and 房产类型='{0}' ", Request.Params["leix"]); } // 2. 获取总数 string count = DBHelper.GetVar("select count(*) " + from + where).ToString(); if (count == null) { return; } string sql = string.Format(@"{0} {1} {2} and id not in (select top {3} id {1} {2} {4}) {4}", select, from, where, Request.Params["start"], order); // 4. 拼装结果 ResultObject ro = DBHelper.GetResult(sql); foreach (RowObject row in ro) { row["所属房产"] = row["房产类型"].ToString() + "-" + row["所属房产"].ToString(); } string data = ro.ToJson(); string result = string.Format("success:true,totalProperty:{0},data:", count, sql); result = "{" + result + data + "}"; Response.Write(result); } else if (action == "update" || action == "add") { Dictionary <string, object> dict = Common.CopyFormToDict(Request.Form); if (dict["编码"].ToString() == "自动产生") { string dt = DateTime.Now.ToString("yyyyMMddhhmmssffff"); dict["编码"] = "ht" + dt; } string admin_id = (string)Session["admin_id"]; string fc = dict["所属房产"].ToString(); string[] fcl = fc.Split('-'); dict["房产类型"] = fcl[0]; dict["所属房产"] = fcl[1]; DateTime dt1 = DateTime.Parse(dict["合同开始时间"].ToString()); DateTime dt2 = DateTime.Parse(dict["合同结束时间"].ToString()); dict.Add("合同开始时间_年", dt1.Year); dict.Add("合同开始时间_月", dt1.Month); dict.Add("合同开始时间_日", dt1.Day); dict.Add("合同结束时间_年", dt2.Year); dict.Add("合同结束时间_月", dt2.Month); dict.Add("合同结束时间_日", dt2.Day); dict.Add("客户编码", Common.getKhbh(dict["客户名称"].ToString())); dict.Add("操作人", admin_id); string sql = SqlBuilder.NameValueToSql(dict, "sq8szxlx.zpgl", "id", action == "add"); DBHelper.ExecuteSql(sql); //新增,修改合同时 修改 gyy_fc_lb里的出租状态和业主编号 string khbm = Common.getKhbh(dict["客户名称"].ToString()); string sql1 = string.Format("update sq8szxlx.gyy_fc_lb set 业主='{0}',状态='已租' where 工业园名称='{1}' and 房产类型='{2}' and 房号='{3}' ", khbm, dict["所属工业园"].ToString(), dict["房产类型"].ToString(), dict["所属房产"].ToString()); DBHelper.ExecuteSql(sql1); if (action == "add") //新增合同时添加 导入消费项 { string fclx = dict["房产类型"].ToString(); string ssgyy = dict["所属工业园"].ToString(); string ssfc = dict["所属房产"].ToString(); string kumc = dict["客户名称"].ToString(); string sql2 = string.Format("select * from sq8szxlx.gyy_lb_fclx_lb_xflx where 工业园名称='{0}' and 房产类型='{1}' ", ssgyy, fclx); ResultObject fcxflx = DBHelper.GetResult(sql2); foreach (RowObject item in fcxflx) { NameValueCollection fcxf = new NameValueCollection(); fcxf.Add("所属工业园", item["工业园名称"].ToString()); fcxf.Add("房产类型", item["房产类型"].ToString()); fcxf.Add("所属房产", ssfc); fcxf.Add("消费项目", item["消费项目"].ToString()); fcxf.Add("消费类型", item["消费类型"].ToString()); fcxf.Add("值", item["值"].ToString()); fcxf.Add("倍率", item["倍率"].ToString()); fcxf.Add("损耗", item["损耗"].ToString()); fcxf.Add("滞纳金", item["滞纳金"].ToString()); fcxf.Add("说明", item["说明"].ToString()); fcxf.Add("客户名称", kumc); fcxf.Add("合同编号", dict["编码"].ToString()); fcxf.Add("客户编码", Common.getKhbh(kumc)); string insertSql = SqlBuilder.NameValueToSql(fcxf, "sq8szxlx.zpgl_lx_lb", "id", true); DBHelper.ExecuteSql(insertSql); } } Response.Write("{success: true}"); } else if (action == "delete") { RowObject row = DBHelper.GetRow("select * from sq8szxlx.zpgl where id=" + Request.Form["id"]); // 修改房产状态 Common.updateFCZT(row["所属工业园"].ToString(), row["房产类型"].ToString(), row["所属房产"].ToString(), "无", "未租"); string sql = "delete from sq8szxlx.zpgl where id=" + Request.Form["id"]; DBHelper.ExecuteSql(sql); Response.Write("{success: true}"); } else if (action == "gyy_fc_lb") { string gyy = Request.Params["gyy"]; string sql = string.Format("select 房产类型+'-'+房号 as fc from sq8szxlx.gyy_fc_lb where 工业园名称='{0}' and 状态='未租' ", gyy); ResultObject r = DBHelper.GetResult(sql); Response.Write(r.ToJson()); } else if (action == "fclx_list") { string sql = "select distinct 工业园名称 as gyyName from sq8szxlx.gyy_lb_fclx_lb "; ResultObject r = DBHelper.GetResult(sql); Response.Write(r.ToJson()); } else if (action == "find_gyy_fclx") { string gyy = Request.Params["gyy"]; string sql = string.Format("select 房产类型 as lx from sq8szxlx.gyy_lb_fclx_lb where 工业园名称='{0}'", gyy); Response.Write(DBHelper.GetResult(sql).ToJson()); } else if (action == "edit_gdxfx") // 编辑固定消费项 { edit_gdxfx2(); } else if (action == "import_gdxfx") // 导入固定消费项到合同 { string responseError = "{success: false}"; //JSONArray ja = JSONConvert.DeserializeArray(Request.Form["data"]); JArray ja = JArray.Parse(Request.Form["data"]); string sql1 = string.Format("select * from sq8szxlx.zpgl where id='{0}'", Request.Params["id"]); RowObject r1 = DBHelper.GetRow(sql1); if (r1 == null) { Response.Write(responseError); Response.End(); return; } string gyy_mc = r1["所属工业园"].ToString(); string fclx = r1["房产类型"].ToString(); string ssfc = r1["所属房产"].ToString(); string htbh = r1["编码"].ToString(); string khbm = r1["客户编码"].ToString(); string khmc = r1["客户名称"].ToString(); // 清除数据 sql1 = string.Format("delete from sq8szxlx.zpgl_lx_lb where 合同编号='{0}'", htbh); DBHelper.ExecuteSql(sql1); sql1 = string.Format("delete from sq8szxlx.user_sf_lb where 单据编号='{0}'", htbh + "_1"); DBHelper.ExecuteSql(sql1); sql1 = string.Format("delete from sq8szxlx.user_sf_zb where 单据编号='{0}'", htbh + "_1"); DBHelper.ExecuteSql(sql1); // 新增数据 //string sql2 = string.Format("select * from sq8szxlx.gyy_lb_fclx_lb_xflx where 工业园名称='{0}' and 房产类型='{1}' order by 序号 asc", // gyy_mc, fclx); //ResultObject r2 = DBHelper.GetResult(sql2); //for (int i = 0; i < r2.Count; i++) for (int i = 0; i < ja.Count; i++) { //JSONObject jo = (JSONObject)ja[i]; JToken jo = ja[i]; //RowObject item = r2[i]; // zpgl_lx_lb Dictionary <string, object> nv1 = new Dictionary <string, object>(); nv1.Add("合同编号", htbh); nv1.Add("客户编码", khbm); nv1.Add("所属工业园", gyy_mc); nv1.Add("房产类型", fclx); nv1.Add("所属房产", ssfc); nv1.Add("客户名称", khmc); nv1.Add("消费项目", jo["消费项目"].ToString()); nv1.Add("消费类型", jo["消费类型"].ToString()); nv1.Add("值", jo["值"]); nv1.Add("损耗", jo["消费类型"].ToString() == "动态" ? jo["损耗"] : 0); nv1.Add("倍率", jo["倍率"]); nv1.Add("滞纳金", jo["滞纳金"]); nv1.Add("说明", jo["说明"]); string sql3 = SqlBuilder.NameValueToSql(nv1, "sq8szxlx.zpgl_lx_lb", "id", true); DBHelper.ExecuteSql(sql3); // user_sf_lb Dictionary <string, object> nv2 = new Dictionary <string, object>(); nv2.Add("合同编号", htbh); nv2.Add("单据编号", htbh + "_1"); nv2.Add("客户编号", khbm); nv2.Add("日期年", r1["合同开始时间_年"]); nv2.Add("日期月", r1["合同开始时间_月"]); nv2.Add("日期日", r1["合同开始时间_日"]); nv2.Add("日期", r1["合同开始时间"]); nv2.Add("收费项目", jo["消费项目"]); nv2.Add("收费类型", jo["消费类型"]); nv2.Add("值", jo["值"]); nv2.Add("录入状态", (jo["消费类型"].ToString() == "动态" && (jo["前期读数"] == null || jo["前期读数"].ToString() == "-")) ? "未录入" : "已录入"); nv2.Add("缴费状态", "不要交费"); nv2.Add("损耗", jo["消费类型"].ToString() == "动态" ? jo["损耗"] : 0); if (jo["消费类型"].ToString() == "动态" && (jo["前期读数"] != null && jo["前期读数"].ToString() != "-")) { nv2.Add("读数", jo["前期读数"]); } else { nv2.Add("读数", 0); } nv2.Add("倍率", jo["倍率"]); nv2.Add("滞纳金", jo["滞纳金"]); nv2.Add("费用", 0); nv2.Add("金额", 0); string sql4 = SqlBuilder.NameValueToSql(nv2, "sq8szxlx.user_sf_lb", "id", true); DBHelper.ExecuteSql(sql4); // user_sf_zb Dictionary <string, object> nv3 = new Dictionary <string, object>(); nv3.Add("合同编号", htbh); nv3.Add("单据编号", htbh + "_1"); nv3.Add("客户编号", khbm); nv3.Add("日期年", r1["合同开始时间_年"]); nv3.Add("日期月", r1["合同开始时间_月"]); nv3.Add("日期日", r1["合同开始时间_日"]); nv3.Add("日期", r1["合同开始时间"]); nv3.Add("总费用", 0); nv3.Add("缴费金额", 0); nv3.Add("余额", 0); nv3.Add("录入状态", "已录入"); nv3.Add("缴费状态", "不要交费"); string sql5 = SqlBuilder.NameValueToSql(nv3, "sq8szxlx.user_sf_zb", "id", true); DBHelper.ExecuteSql(sql5); } } else if (action == "delete_xfx") { string sql = "delete from sq8szxlx.zpgl_lx_lb where id=" + Request.Params["id"]; DBHelper.ExecuteSql(sql); } else if (action == "add_fcxf") { Dictionary <string, object> dict = Common.CopyFormToDict(Request.Form); string aa = Request.Form["所属房产"].ToString(); string[] a = aa.Split('-'); dict["所属房产"] = a[1]; string sql = SqlBuilder.NameValueToSql(dict, "sq8szxlx.zpgl_lx_lb", "id", true); DBHelper.ExecuteSql(sql); Response.Write("{success: true}"); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_id"] == null) { throw new SessionLostException(); } string action = Request.Params["action"]; if (String.IsNullOrEmpty(action)) { return; } Response.ContentType = "application/json"; if (action == "list") { string sql = ""; if (Request.Params["start"] != null && Request["limit"] != null) { sql = string.Format("select top {0} * from sq8szxlx.zpgl where id not in(select top {1} id from sq8szxlx.zpgl)", Request["limit"], Request.Params["start"]); } else { sql = "select * from sq8szxlx.zpgl where 1=1"; } string where = " and 合同结束时间_年 is null "; sql += where + " order by 客户名称 asc "; int count = (int)DBHelper.GetVar("select count(*) as total from sq8szxlx.zpgl where 1=1 " + where); ResultObject ro = DBHelper.GetResult(sql); foreach (RowObject row in ro) { row["所属房产"] = row["房产类型"].ToString() + "-" + row["所属房产"].ToString(); } string data = ro.ToJson(); string result = string.Format("\"success\":true,\"totalProperty\":{0},\"data\":", count); result = "{" + result + data + "}"; Response.Write(result); } else if (action == "add" || action == "update") { Dictionary <string, object> dict = Common.CopyFormToDict(Request.Form); if (dict["编码"].ToString() == "自动产生") { string dt = DateTime.Now.ToString("yyyyMMddhhmmssffff"); dict["编码"] = "ht" + dt; } string fc = dict["所属房产"].ToString(); string[] fcl = fc.Split('-'); dict["房产类型"] = fcl[0]; dict["所属房产"] = fcl[1]; DateTime dt1 = DateTime.Parse(dict["合同开始时间"].ToString()); dict.Add("合同开始时间_年", dt1.Year); dict.Add("合同开始时间_月", dt1.Month); dict.Add("合同开始时间_日", dt1.Day); string sql = SqlBuilder.NameValueToSql(dict, "sq8szxlx.zpgl", "id", action == "add"); DBHelper.ExecuteSql(sql); // 修改房产状态 string yezu = Common.getKhbh(dict["客户名称"].ToString()); Common.updateFCZT(dict["所属工业园"].ToString(), dict["房产类型"].ToString(), dict["所属房产"].ToString(), yezu, "预定"); Response.Write("{success: true}"); } else if (action == "change") { string sql = "update sq8szxlx.zpgl set 合同结束时间_年='' where id=" + Request.Form["id"]; DBHelper.ExecuteSql(sql); } else if (action == "delete") { RowObject row = DBHelper.GetRow("select * from sq8szxlx.zpgl where id=" + Request.Form["id"]); // 修改房产状态 Common.updateFCZT(row["所属工业园"].ToString(), row["房产类型"].ToString(), row["所属房产"].ToString(), "无", "未租"); string sql = "delete from sq8szxlx.zpgl where id=" + Request.Form["id"]; DBHelper.ExecuteSql(sql); Response.Write("{success: true}"); } Response.End(); }
private OptionObject MakeTimeRequired(OptionObject optionObject, Boolean isInpatientNote) { OptionObject returnOptionObject = new OptionObject(); String field3003Value = ""; String field3004Value = ""; foreach (var form in optionObject.Forms) { foreach (var currentField in form.CurrentRow.Fields) { if (currentField.FieldNumber.Equals("3003")) field3003Value = currentField.FieldValue; if (currentField.FieldNumber.Equals("3004")) field3004Value = currentField.FieldValue; } } var field1 = new FieldObject(); var field2 = new FieldObject(); var fields = new FieldObject[2]; var forms = new FormObject[1]; var formObject = new FormObject(); var currentRow = new RowObject(); field1.FieldNumber = "3003"; field1.Required = "1"; field1.FieldValue = field3003Value; fields[0] = field1; field2.FieldNumber = "3004"; field2.Required = "1"; field2.FieldValue = field3004Value; field2.Enabled = ConfigurationManager.AppSettings["enableEndTime"].ToString().Equals("true") ? "1" : "0"; fields[1] = field2; currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; if (isInpatientNote) formObject.FormId = "7000"; else formObject.FormId = "7001"; formObject.CurrentRow = currentRow; forms[0] = formObject; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.SystemCode = optionObject.SystemCode; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.Forms = forms; return returnOptionObject; }
/// <summary> /// Align content vertically /// </summary> private void AlignVertically() { ArrayList objectList = new ArrayList(mOwnRowObjects); mOwnRowObjects.Clear(); for (int i = 0; i < objectList.Count; i++) { RowObject oldObj = (RowObject)objectList[i]; double bottom = Math.Round(RowBottom.PosY - CellPadding, 6); XRect bbox = new XRect(); bbox.String = mDoc.GetInfo(oldObj.id, "rect"); bbox.Inset(-CellPadding, -CellPadding); if (bbox.Bottom > bottom && oldObj.pageNr == RowBottom.PageNr) { double alpha = VerticalAlignment; if (VerticalAlignment > 1) { alpha = 1; } double offset = alpha * (bbox.Bottom - bottom); double width = 0; if (oldObj.obj is XImage) { width = Double.Parse(mDoc.GetInfo(oldObj.id, "Width"), new CultureInfo("en-US")); } mDoc.Delete(oldObj.id); XRect newRect = new XRect(); newRect.String = bbox.String; newRect.Move(0, -offset); if (newRect.Bottom > bottom) { newRect.Bottom = bottom; } mDoc.Rect.String = newRect.String; string theTextStyle = mDoc.TextStyle.String; mDoc.TextStyle.String = oldObj.textStyle; int iFont = mDoc.Font; mDoc.Font = oldObj.font; if (oldObj.obj is string) { AddHtml((string)(oldObj.obj)); } else if (oldObj.obj is XImage) { XImage image = (XImage)(oldObj.obj); if (width == image.Width) { AddImage(image, false); } else { AddImage(image, true); } } mDoc.Font = iFont; mDoc.TextStyle.String = theTextStyle; } else { mOwnRowObjects.Add(oldObj); } } }
protected OptionObject emptyZipCodeOnLoad(OptionObject optionObject, string scriptName) { var formSelected = optionObject.Forms.FirstOrDefault(f => f.FormId == "511"); var rowSelected = formSelected.CurrentRow; var fieldSelected = rowSelected.Fields.FirstOrDefault(f => f.FieldNumber == "151"); var formSelcected2 = optionObject.Forms.FirstOrDefault(f => f.FormId == "511"); var rowSelected2 = formSelcected2.CurrentRow; var fieldSelected2 = rowSelected2.Fields.FirstOrDefault(f => f.FieldNumber == "153"); //var valueSet = "<b>Do you want to make the following changes?</b> \n Save client as <u>Homeless</u>. \n" + //"Change Zip Code to <u>88888</u>. \n Change Client'S Living Arrangement to <u>Homeless</u>\nChange County to <u>4-Homeless</u>\n\n " + //"<i><font color='red'>(Note: These are default values for homeless clients and you will not be able to change them as long as client is set to Homeless) </font></i>"; OptionObject myObject = new OptionObject(); FormObject fo = new FormObject(); RowObject ro = new RowObject(); List<FieldObject> listFields = new List<FieldObject>(); ro.RowId = rowSelected.RowId; ro.ParentRowId = rowSelected.ParentRowId; ro.RowAction = "EDIT"; fo.FormId = formSelected.FormId; fo.MultipleIteration = formSelected.MultipleIteration; //test changes to git if (fieldSelected.FieldValue == "1") { //call script that changes zip code // myObject.ErrorCode = 4; // myObject.ErrorMesg = valueSet; myObject.EntityID = optionObject.EntityID; myObject.OptionId = optionObject.OptionId; myObject.SystemCode = optionObject.SystemCode; myObject.Facility = optionObject.Facility; //make homeless indicator required FieldObject homelessIndicator = rowSelected.Fields.FirstOrDefault(f => f.FieldNumber == "152"); FieldObject clientLivingArrangement = rowSelected.Fields.FirstOrDefault(f => f.FieldNumber == "1167"); clientLivingArrangement.Required = "1"; clientLivingArrangement.Enabled = "0"; clientLivingArrangement.FieldValue = "8"; homelessIndicator.Required = "1"; homelessIndicator.Enabled = "1"; homelessIndicator.FieldValue = "1"; listFields.Add(homelessIndicator); listFields.Add(clientLivingArrangement); ro.Fields = listFields.ToArray(); fo.CurrentRow = ro; List<FormObject> listOfForms = new List<FormObject>(); listOfForms.Add(fo); listOfForms.Add(setOtherClientDemo_ForHomelessForm.homelessZip(optionObject, scriptName)); myObject.Forms = listOfForms.ToArray(); return myObject; } else { // myObject.ErrorCode =3; //myObject.ErrorMesg = "Not Homeless"; myObject.EntityID = optionObject.EntityID; myObject.OptionId = optionObject.OptionId; myObject.SystemCode = optionObject.SystemCode; myObject.Facility = optionObject.Facility; FieldObject homelessIndicator = rowSelected.Fields.FirstOrDefault(f => f.FieldNumber == "152"); FieldObject clientLivingArrangement = rowSelected.Fields.FirstOrDefault(f => f.FieldNumber == "1167"); clientLivingArrangement.Required = "1"; clientLivingArrangement.Enabled = "1"; clientLivingArrangement.FieldValue = "6"; homelessIndicator.Required = "0"; homelessIndicator.Enabled = "0"; homelessIndicator.FieldValue = "99"; listFields.Add(homelessIndicator); listFields.Add(clientLivingArrangement); ro.Fields = listFields.ToArray(); fo.CurrentRow = ro; List<FormObject> listOfForms = new List<FormObject>(); listOfForms.Add(fo); listOfForms.Add(setOtherClientDemo_ForHomelessForm.noHomelessZip(optionObject, scriptName)); myObject.Forms = listOfForms.ToArray(); return myObject; } }
public void GetReturnOptionObject_NoCurrentRowModifiedReturnsWithoutException() { OptionObject2015 expected = new OptionObject2015("USER37", "unittestuser", "", "1", "", 0, "UAT", "AVPM", "AVPM", "SERVER", "TOKEN"); FieldObject fieldObject01 = new FieldObject("214.74", "2"); FieldObject fieldObject02 = new FieldObject("214.98", "12/07/2020"); RowObject rowObject01 = new RowObject("33||1"); rowObject01.AddFieldObject(fieldObject01); rowObject01.AddFieldObject(fieldObject02); FormObject form33 = new FormObject("33", rowObject01, false); expected.AddFormObject(form33); FieldObject fieldObject03 = new FieldObject("214.75", ""); FieldObject fieldObject04 = new FieldObject("214.76", ""); FieldObject fieldObject05 = new FieldObject("214.77", ""); FieldObject fieldObject06 = new FieldObject("214.78", ""); FieldObject fieldObject07 = new FieldObject("214.79", ""); FieldObject fieldObject08 = new FieldObject("214.8", ""); FieldObject fieldObject09 = new FieldObject("214.81", ""); FieldObject fieldObject10 = new FieldObject("214.82", ""); FieldObject fieldObject11 = new FieldObject("214.83", ""); FieldObject fieldObject12 = new FieldObject("214.85", ""); FieldObject fieldObject13 = new FieldObject("214.86", "30"); FieldObject fieldObject14 = new FieldObject("214.91", ""); FieldObject fieldObject15 = new FieldObject("214.93", ""); FieldObject fieldObject16 = new FieldObject("214.94", ""); FieldObject fieldObject17 = new FieldObject("214.96", "12/3/2020"); FieldObject fieldObject18 = new FieldObject("214.97", "12/4/2020"); RowObject rowObject02 = new RowObject("34||1", "33||1"); rowObject02.AddFieldObject(fieldObject03); rowObject02.AddFieldObject(fieldObject04); rowObject02.AddFieldObject(fieldObject05); rowObject02.AddFieldObject(fieldObject06); rowObject02.AddFieldObject(fieldObject07); rowObject02.AddFieldObject(fieldObject08); rowObject02.AddFieldObject(fieldObject09); rowObject02.AddFieldObject(fieldObject10); rowObject02.AddFieldObject(fieldObject11); rowObject02.AddFieldObject(fieldObject12); rowObject02.AddFieldObject(fieldObject13); rowObject02.AddFieldObject(fieldObject14); rowObject02.AddFieldObject(fieldObject15); rowObject02.AddFieldObject(fieldObject16); rowObject02.AddFieldObject(fieldObject17); rowObject02.AddFieldObject(fieldObject18); FieldObject fieldObject19 = new FieldObject("214.75", ""); FieldObject fieldObject20 = new FieldObject("214.76", ""); FieldObject fieldObject21 = new FieldObject("214.77", ""); FieldObject fieldObject22 = new FieldObject("214.78", ""); FieldObject fieldObject23 = new FieldObject("214.79", ""); FieldObject fieldObject24 = new FieldObject("214.8", ""); FieldObject fieldObject25 = new FieldObject("214.81", ""); FieldObject fieldObject26 = new FieldObject("214.82", ""); FieldObject fieldObject27 = new FieldObject("214.83", ""); FieldObject fieldObject28 = new FieldObject("214.85", ""); FieldObject fieldObject29 = new FieldObject("214.86", "110"); FieldObject fieldObject30 = new FieldObject("214.91", ""); FieldObject fieldObject31 = new FieldObject("214.93", ""); FieldObject fieldObject32 = new FieldObject("214.94", ""); FieldObject fieldObject33 = new FieldObject("214.96", "12/4/2020"); FieldObject fieldObject34 = new FieldObject("214.97", ""); RowObject rowObject03 = new RowObject("34||2", "33||1"); rowObject03.AddFieldObject(fieldObject19); rowObject03.AddFieldObject(fieldObject20); rowObject03.AddFieldObject(fieldObject21); rowObject03.AddFieldObject(fieldObject22); rowObject03.AddFieldObject(fieldObject23); rowObject03.AddFieldObject(fieldObject24); rowObject03.AddFieldObject(fieldObject25); rowObject03.AddFieldObject(fieldObject26); rowObject03.AddFieldObject(fieldObject27); rowObject03.AddFieldObject(fieldObject28); rowObject03.AddFieldObject(fieldObject29); rowObject03.AddFieldObject(fieldObject30); rowObject03.AddFieldObject(fieldObject31); rowObject03.AddFieldObject(fieldObject32); rowObject03.AddFieldObject(fieldObject33); rowObject03.AddFieldObject(fieldObject34); rowObject03.SetFieldValue("214.96", "12/5/2020"); FormObject form34 = new FormObject("34") { MultipleIteration = true }; form34.OtherRows.Add(rowObject02); form34.OtherRows.Add(rowObject03); expected.AddFormObject(form34); OptionObject2015 actual = (OptionObject2015)expected.ToReturnOptionObject(); Assert.AreEqual(expected.OptionId, actual.OptionId); }
private OptionObject SourceOfAdmission(OptionObject optionObject) { OptionObject returnOptionObject = new OptionObject(); String field158Value = null; foreach (var form in optionObject.Forms) { foreach (var currentField in form.CurrentRow.Fields) { if (currentField.FieldNumber.Equals("158")) field158Value = currentField.FieldValue; } } var field1 = new FieldObject(); var fields = new FieldObject[1]; var forms = new FormObject[1]; var formObject = new FormObject(); var currentRow = new RowObject(); field1.FieldNumber = "158"; field1.FieldValue = field158Value; field1.Required = "1"; fields[0] = field1; currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; formObject.FormId = "510"; formObject.CurrentRow = currentRow; forms[0] = formObject; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.SystemCode = optionObject.SystemCode; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.Forms = forms; return returnOptionObject; }
private OptionObject CheckNoteType(OptionObject optionObject) { OptionObject returnOptionObject = new OptionObject(); FieldObject homeVisit = new FieldObject(); homeVisit.FieldNumber = "7003.3"; FieldObject noteType = new FieldObject(); noteType.FieldNumber = "10751"; foreach (var form in optionObject.Forms) { foreach (var currentField in form.CurrentRow.Fields) { if (currentField.FieldNumber.Equals(noteType.FieldNumber)) noteType.FieldValue = currentField.FieldValue; } } if (!noteType.FieldValue.Equals("15")) { homeVisit.Required = "0"; homeVisit.Enabled = "0"; var fields = new FieldObject[1]; var forms = new FormObject[1]; var formObject = new FormObject(); var currentRow = new RowObject(); fields[0] = homeVisit; currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[1].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[1].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; formObject.FormId = "21005"; formObject.CurrentRow = currentRow; forms[0] = formObject; returnOptionObject.Forms = forms; } else { homeVisit.Required = "1"; homeVisit.Enabled = "1"; var fields = new FieldObject[1]; var forms = new FormObject[1]; var formObject = new FormObject(); var currentRow = new RowObject(); fields[0] = homeVisit; currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[1].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[1].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; formObject.FormId = "21005"; formObject.CurrentRow = currentRow; forms[0] = formObject; returnOptionObject.Forms = forms; } returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.SystemCode = optionObject.SystemCode; return returnOptionObject; }
private OptionObject AddDuration(OptionObject optionObject, Boolean isInpatientNote) { var returnOptionObject = new OptionObject(); var duration = new FieldObject { FieldNumber = "51003" }; var startTime = new FieldObject { FieldNumber = "3003" }; var endTime = new FieldObject { FieldNumber = "3004" }; var serviceCode = new FieldObject { FieldNumber = "51001" }; try { foreach (var field in optionObject.Forms[0].CurrentRow.Fields) { if (field.FieldNumber.Equals(duration.FieldNumber)) duration.FieldValue = field.FieldValue; if (field.FieldNumber.Equals(endTime.FieldNumber)) endTime.FieldValue = field.FieldValue; if (field.FieldNumber.Equals(startTime.FieldNumber)) startTime.FieldValue = field.FieldValue; if (field.FieldNumber.Equals(serviceCode.FieldNumber)) serviceCode.FieldValue = field.FieldValue; } if (!duration.FieldValue.Equals(String.Empty)) { if (duration.FieldValue.Equals("0")) { returnOptionObject.ErrorCode = 1; returnOptionObject.ErrorMesg = "The note duration cannot be equal to zero.\r\nPlease check and enter the correct duration."; } else if (Convert.ToInt32(duration.FieldValue) > 0) { if (Convert.ToInt32(duration.FieldValue) > 120) { returnOptionObject.ErrorCode = 3; returnOptionObject.ErrorMesg = "The service duration is more than 120 minutes, please make sure this is correct before proceeding."; } if (!startTime.FieldValue.Equals(String.Empty)) { endTime.FieldValue = DateTime.Parse(startTime.FieldValue).AddMinutes(Convert.ToDouble(duration.FieldValue)).ToString("hh:mm tt"); var fields = new FieldObject[1]; fields[0] = endTime; var currentRow = new RowObject(); currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; var formObject = new FormObject(); if (isInpatientNote) formObject.FormId = "7000"; else formObject.FormId = "7001"; formObject.CurrentRow = currentRow; var forms = new FormObject[1]; forms[0] = formObject; returnOptionObject.Forms = forms; } } } } catch (Exception e) { } returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.SystemCode = optionObject.SystemCode; returnOptionObject.Facility = optionObject.Facility; return returnOptionObject; }
private OptionObject CheckSubscriberMedicare(OptionObject optionObject) { OptionObject returnOptionObject = new OptionObject(); FieldObject policyNumField = new FieldObject(); policyNumField.FieldNumber = "263"; FieldObject medicareField = new FieldObject(); medicareField.FieldNumber = "818"; FieldObject guarantorID = new FieldObject(); guarantorID.FieldNumber = "680"; foreach (var form in optionObject.Forms) { foreach (var currentField in form.CurrentRow.Fields) { if (currentField.FieldNumber.Equals(policyNumField.FieldNumber)) policyNumField.FieldValue = currentField.FieldValue; if (currentField.FieldNumber.Equals(medicareField.FieldNumber)) medicareField.FieldValue = currentField.FieldValue; if (currentField.FieldNumber.Equals(guarantorID.FieldNumber)) guarantorID.FieldValue = currentField.FieldValue; } } if (checkUserRole(optionObject.OptionUserId)) { checkFieldFormat(medicareField, returnOptionObject, "Subscriber Medicare Number"); if (returnOptionObject.ErrorCode != 1) { String financialClassCode = checkFinancialCLass(guarantorID); if (financialClassCode.Equals("8"))//medicaid class { policyNumField.FieldValue = medicareField.FieldValue; var fields = new FieldObject[1]; var forms = new FormObject[1]; var formObject = new FormObject(); var currentRow = new RowObject(); fields[0] = policyNumField; currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[1].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[1].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; formObject.FormId = "3001"; formObject.CurrentRow = currentRow; formObject.MultipleIteration = true; forms[0] = formObject; returnOptionObject.Forms = forms; } } } returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.SystemCode = optionObject.SystemCode; return returnOptionObject; }
private OptionObject AppointmentStatus(OptionObject optionObject, Boolean isClientSchedulingScreen) { String appointmentStatusList = "2&4&5&6&7&8&9&20&&21"; OptionObject returnOptionObject = new OptionObject(); FieldObject AppointmentStatus = new FieldObject(); AppointmentStatus.FieldNumber = "10005";//same FieldObject MissedVisit = new FieldObject(); MissedVisit.FieldNumber = "10101";//same FieldObject MissedVisitCode = new FieldObject(); MissedVisitCode.FieldNumber = "10102";//same FieldObject CoPractitioner = new FieldObject(); CoPractitioner.FieldNumber = "10007"; foreach (var form in optionObject.Forms) { foreach (var field in form.CurrentRow.Fields) { if (AppointmentStatus.FieldNumber.Equals(field.FieldNumber)) AppointmentStatus.FieldValue = field.FieldValue; if (CoPractitioner.FieldNumber.Equals(field.FieldNumber)) CoPractitioner.FieldValue = field.FieldValue; //if (MissedVisit.FieldNumber.Equals(field.FieldNumber)) // MissedVisit.FieldValue = field.FieldValue; } } string[] appt_status_array = appointmentStatusList.Split('&'); if (appt_status_array.Contains(AppointmentStatus.FieldValue)) { MissedVisitCode.FieldValue = getMissedVisitCode(AppointmentStatus.FieldValue); MissedVisitCode.Required = "0"; MissedVisitCode.Enabled = "0"; MissedVisit.Required = "0"; MissedVisit.Enabled = "0"; MissedVisit.FieldValue = "X"; } else { MissedVisitCode.FieldValue = String.Empty; MissedVisitCode.Required = "0"; MissedVisitCode.Enabled = "0"; MissedVisit.Required = "0"; MissedVisit.Enabled = "0"; MissedVisit.FieldValue = String.Empty; } var fields = new FieldObject[2]; var forms = new FormObject[1]; var formObject = new FormObject(); var currentRow = new RowObject(); fields[0] = MissedVisit; fields[1] = MissedVisitCode; currentRow.Fields = fields; currentRow.RowId = isClientSchedulingScreen ? optionObject.Forms[0].CurrentRow.RowId : optionObject.Forms[0].CurrentRow.RowId; currentRow.ParentRowId = isClientSchedulingScreen ? optionObject.Forms[0].CurrentRow.ParentRowId : optionObject.Forms[0].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; formObject.FormId = isClientSchedulingScreen ? "610" : "610"; formObject.CurrentRow = currentRow; forms[0] = formObject; //var fields2 = new FieldObject[1]; //var formObject2 = new FormObject(); //var currentRow2 = new RowObject(); //CoPractitioner.FieldValue = "000082"; //fields2[0] = CoPractitioner; //currentRow2.Fields = fields2; //currentRow2.RowId = optionObject.Forms[0].CurrentRow.RowId; //currentRow2.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; //currentRow2.RowAction = "EDIT"; //formObject2.FormId = "600"; //formObject2.CurrentRow = currentRow2; //forms[1] = formObject2; returnOptionObject.Forms = forms; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.SystemCode = optionObject.SystemCode; return returnOptionObject; }
private OptionObject DefaultMGAFScore(OptionObject optionObject) { OptionObject returnOptionObject = new OptionObject(); FieldObject MGAF = new FieldObject(); MGAF.FieldNumber = "7051.4"; foreach (var form in optionObject.Forms) { foreach (var field in form.CurrentRow.Fields) { if (field.FieldNumber.Equals(MGAF.FieldNumber)) MGAF.FieldValue = field.FieldValue; } } if (MGAF.FieldValue.Equals(String.Empty)) MGAF.FieldValue = getMGAFSCore(optionObject.EntityID, optionObject.EpisodeNumber.ToString()); var fields = new FieldObject[1]; var forms = new FormObject[1]; var formObject = new FormObject(); var currentRow = new RowObject(); fields[0] = MGAF; currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[1].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[1].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; formObject.FormId = "21008"; formObject.CurrentRow = currentRow; forms[0] = formObject; returnOptionObject.Forms = forms; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.SystemCode = optionObject.SystemCode; return returnOptionObject; }
private OptionObject ChartLocation(OptionObject optionObject, Boolean isCallFromOptionLoad) { OptionObject returnOptionObject = new OptionObject(); FieldObject ChartDropdown = new FieldObject(); ChartDropdown.FieldNumber = "626.1"; FieldObject ChartTextField = new FieldObject(); ChartTextField.FieldNumber = "148"; foreach (var form in optionObject.Forms) { foreach (var field in form.CurrentRow.Fields) { if (ChartDropdown.FieldNumber.Equals(field.FieldNumber)) ChartDropdown.FieldValue = field.FieldValue; } } if (isCallFromOptionLoad) { ChartTextField.Enabled = "0"; ChartTextField.FieldValue = getChartLocation(ChartDropdown.FieldValue) + " - " + optionObject.EntityID; } else { ChartTextField.FieldValue = getChartLocation(ChartDropdown.FieldValue) + " - " + optionObject.EntityID; } var fields = new FieldObject[1]; var forms = new FormObject[1]; var formObject = new FormObject(); var currentRow = new RowObject(); fields[0] = ChartTextField; currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; formObject.FormId = "14";//510 for admission screen formObject.CurrentRow = currentRow; forms[0] = formObject; //returnOptionObject.ErrorCode = 3; //returnOptionObject.ErrorMesg = ChartTextField.FieldValue; returnOptionObject.Forms = forms; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.SystemCode = optionObject.SystemCode; return returnOptionObject; }
private OptionObject DefaultPractitioner(OptionObject optionObject, Boolean isCheckIn) { OptionObject returnOptionObject = new OptionObject(); int numOfFields = 0; var Staff = new FieldObject(); Boolean StaffChanged = false; var Date = new FieldObject(); Boolean DateChanged = false; var Time = new FieldObject(); Boolean TimeChanged = false; if (isCheckIn) { Staff.FieldNumber = "130.71"; Date.FieldNumber = "130.49"; Time.FieldNumber = "130.68"; } else { Staff.FieldNumber = "130.74"; Date.FieldNumber = "130.5"; Time.FieldNumber = "130.69"; } foreach (var field in optionObject.Forms[2].CurrentRow.Fields) { if (field.FieldNumber.Equals(Staff.FieldNumber)) Staff.FieldValue = field.FieldValue; if (field.FieldNumber.Equals(Date.FieldNumber)) Date.FieldValue = field.FieldValue; if (field.FieldNumber.Equals(Staff.FieldNumber)) Time.FieldValue = field.FieldValue; } if (Staff.FieldValue.Equals(String.Empty)) { Staff.FieldValue = optionObject.OptionStaffId; StaffChanged = true; numOfFields++; } if (Date.FieldValue.Equals(String.Empty)) { Date.FieldValue = DateTime.Now.ToString("MM/dd/yyyy"); DateChanged = true; numOfFields++; } if (Time.FieldValue.Equals(String.Empty)) { Time.FieldValue = DateTime.Now.ToString("HHmm"); TimeChanged = true; numOfFields++; } var fields = new FieldObject[numOfFields]; int pointer = 0; if (StaffChanged) fields[pointer++] = Staff; if (DateChanged) fields[pointer++] = Date; if (TimeChanged) fields[pointer++] = Time; var forms = new FormObject[1]; var formObject = new FormObject(); var currentRow = new RowObject(); currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[2].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[2].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; #region OnlyMultiIteration //int i = 0; //if (optionObject.Forms[2].OtherRows != null) //{ // var otherRows = new RowObject[optionObject.Forms[2].OtherRows.Length]; // foreach (var row in optionObject.Forms[2].OtherRows) // { // var tempFields = new FieldObject[1]; // var tempField = new FieldObject(); // tempField.FieldNumber = "130.71"; // tempField.FieldValue = optionObject.OptionStaffId; // tempFields[0] = tempField; // var tempRow = new RowObject(); // tempRow.Fields = tempFields; // tempRow.RowId = row.RowId; // tempRow.ParentRowId = row.ParentRowId; // tempRow.RowAction = "EDIT"; // otherRows[i++] = tempRow; // } // formObject.OtherRows = otherRows; //} #endregion formObject.CurrentRow = currentRow; formObject.FormId = "951"; formObject.MultipleIteration = true; forms[0] = formObject; returnOptionObject.Forms = forms; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.SystemCode = optionObject.SystemCode; return returnOptionObject; }
public OptionObject2015 Execute() { string[] temp = _parameter.Split(','); var returnOptionObject = new OptionObject2015(); var formObject = new FormObject(); var verifyDataField = new FieldObject(); string holdValidChars = temp[3]; string fieldDesc = temp[4]; string holdValidsAddr = "^[a-zA-Z0-9 ]*$"; string holdValidsName = "^[a-zA-Z0-9, ]*$"; string holdValids; //RegexStringValidator re = new RegexStringValidator(holdValidChars); if (holdValidChars == "N") // valid characters for a name field { holdValids = holdValidsName; } else // valid characters for an address field { holdValids = holdValidsAddr; } RegexStringValidator re = new RegexStringValidator(holdValids); string returnMessage = ""; try { formObject.FormId = temp[1]; verifyDataField.FieldNumber = temp[2]; foreach (var form in _optionObject2015.Forms) { foreach (var field in form.CurrentRow.Fields) { if (field.FieldNumber == verifyDataField.FieldNumber) { verifyDataField.FieldValue = field.FieldValue; formObject.MultipleIteration = form.MultipleIteration; } } } // allow regular characters re.Validate(verifyDataField.FieldValue); //var fields = new FieldObject[1]; //fields[0] = verifyDataField; var currentRow = new RowObject { Fields = new List <FieldObject> { verifyDataField } }; foreach (var form in _optionObject2015.Forms) { if (form.FormId == formObject.FormId) { currentRow.RowId = form.CurrentRow.RowId; currentRow.ParentRowId = form.CurrentRow.ParentRowId; } } } catch (ArgumentException eo) { returnMessage = "There are one or more special characters in the '" + fieldDesc + "' field"; returnOptionObject.ErrorCode = 1; logger.Error(eo, returnMessage); } catch (Exception e) { returnMessage = e.Message + " -Validate Character Field- \n\n" + e.GetType().ToString() + "\n" + e.StackTrace; returnOptionObject.ErrorCode = 3; logger.Error(e, "An error occurred. Error: {errorMessage}.", e.Message); } returnOptionObject.ErrorMesg = returnMessage; returnOptionObject.EntityID = _optionObject2015.EntityID; returnOptionObject.EpisodeNumber = _optionObject2015.EpisodeNumber; returnOptionObject.Facility = _optionObject2015.Facility; returnOptionObject.NamespaceName = _optionObject2015.NamespaceName; returnOptionObject.OptionId = _optionObject2015.OptionId; returnOptionObject.OptionStaffId = _optionObject2015.OptionStaffId; returnOptionObject.OptionUserId = _optionObject2015.OptionUserId; returnOptionObject.ParentNamespace = _optionObject2015.ParentNamespace; returnOptionObject.ServerName = _optionObject2015.ServerName; returnOptionObject.SystemCode = _optionObject2015.SystemCode; returnOptionObject.SessionToken = _optionObject2015.SessionToken; return(returnOptionObject); }
private OptionObject DefaultPsychosocial(OptionObject optionObject) { var returnOptionObject = new OptionObject { EntityID = optionObject.EntityID, OptionId = optionObject.OptionId, SystemCode = optionObject.SystemCode, Facility = optionObject.Facility }; var clinician = new FieldObject { FieldNumber = "126.56" }; var status = new FieldObject { FieldNumber = "141", FieldValue = "F" }; var aDate = new FieldObject { FieldNumber = "126.55" }; var aTime = new FieldObject { FieldNumber = "134.7", FieldValue = DateTime.Now.ToString("hh:mm tt") }; var fields = new FieldObject[1]; fields[0] = aTime; var currentRow = new RowObject(); currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; var formObject = new FormObject { FormId = "129" }; formObject.CurrentRow = currentRow; var forms = new FormObject[2]; forms[0] = formObject; var fields1 = new FieldObject[1]; fields1[0] = status; var currentRow1 = new RowObject(); currentRow1.Fields = fields1; currentRow1.RowId = optionObject.Forms[4].CurrentRow.RowId; currentRow1.ParentRowId = optionObject.Forms[4].CurrentRow.ParentRowId; currentRow1.RowAction = "EDIT"; var formObject1 = new FormObject { FormId = "133" }; formObject1.CurrentRow = currentRow1; forms[1] = formObject1; returnOptionObject.Forms = forms; return returnOptionObject; }
public static FormObject noHomelessZip(OptionObject optionobject, string scriptname) { //if zipCode is empty do not initialize to previous values //else prevZip = zip //Find the rows to be changed var formSelected = optionobject.Forms.FirstOrDefault(f => f.FormId == "523"); var row = formSelected.CurrentRow; var ZipField = row.Fields.FirstOrDefault(f => f.FieldNumber == "94"); var countyField = row.Fields.FirstOrDefault(f => f.FieldNumber == "93"); var formselect2 = optionobject.Forms.FirstOrDefault(f => f.FormId == ""); FormObject fo = new FormObject(); RowObject ro = new RowObject(); FieldObject fio = new FieldObject(); FieldObject fio2 = new FieldObject(); fio.FieldNumber = ZipField.FieldNumber; fio2.FieldNumber = countyField.FieldNumber; fio.FieldValue = ZipField.FieldValue; fio2.FieldValue = countyField.FieldValue; fio.Enabled = "1"; fio2.Enabled = "1"; var fieldList = new List<FieldObject>(); fieldList.Add(fio); fieldList.Add(fio2); ro.Fields = fieldList.ToArray(); ro.ParentRowId = row.ParentRowId; ro.RowId = row.RowId; ro.RowAction = "EDIT"; fo.CurrentRow = ro; fo.FormId = formSelected.FormId; fo.MultipleIteration = formSelected.MultipleIteration; return fo; }
private void list_jf() { string responseError = "{success: false}"; string sql1 = string.Format("select * from sq8szxlx.zpgl where id='{0}'", Request.Params["id"]); RowObject zpgl = DBHelper.GetRow(sql1); if (zpgl == null) { Response.Write(responseError); Response.End(); return; } // 本月消费总表 sql1 = string.Format("select * from sq8szxlx.user_sf_zb where 单据编号='{0}_{1}'", zpgl["编码"], Request.Params["xh"]); RowObject user_sf_zb = DBHelper.GetRow(sql1); // 消费类型列表 sql1 = string.Format("select * from sq8szxlx.zpgl_lx_lb where 合同编号='{0}' order by id asc", zpgl["编码"]); ResultObject zpgl_lx_lb = DBHelper.GetResult(sql1); int xh = int.Parse(Request.Params["xh"]); for (int i = 0; i < zpgl_lx_lb.Count; i++) { RowObject row = zpgl_lx_lb[i]; row["编号"] = i + 1; row["收费项目"] = row["消费项目"]; row["收费类型"] = row["消费类型"]; row["损耗"] = row["消费类型"].ToString() == "动态" ? row["损耗"] : "-"; // 查询收费列表 string sql_lb = string.Format(@"select * from sq8szxlx.user_sf_lb where 单据编号='{0}_{1}' and 收费项目='{2}'", zpgl["编码"], xh, row["消费项目"]); RowObject user_sf_lb = DBHelper.GetRow(sql_lb); if (user_sf_lb == null) { continue; // 没有收费该项目 } // 查询上月收费项目 string sql_pre_lb = string.Format(@"select * from sq8szxlx.user_sf_lb where 单据编号='{0}_{1}' and 收费项目='{2}'", zpgl["编码"], xh - 1, row["消费项目"]); RowObject r2 = DBHelper.GetRow(sql_pre_lb); row["上月读数"] = (row["消费类型"].ToString() == "动态" && r2 != null)? r2["读数"] : "-"; row["读数"] = (row["消费类型"].ToString() == "动态" || row["消费类型"].ToString() == "单价") ? user_sf_lb["读数"] : "-"; row["费用"] = user_sf_lb["费用"]; } double zfy = Convert.ToDouble(user_sf_zb["总费用"]); double ye = Convert.ToDouble(user_sf_zb["余额"]); //JObject jo = new JObject(new JProperty("success","true"), // new JProperty("data",zpgl_lx_lb), // new JProperty("总金额",Math.Round(Convert.ToDecimal(user_sf_zb["总费用"]), 1)), // new JProperty("上次结余",user_sf_zb["余额"]), // new JProperty("需要交费金额",Math.Round((zfy - ye), 1))); //JSONObject result = new JSONObject(); //result.Add("success", "true"); //result.Add("data", zpgl_lx_lb); //result.Add("总金额", Math.Round(Convert.ToDecimal(user_sf_zb["总费用"]), 1)); //result.Add("上次结余", user_sf_zb["余额"]); //result.Add("需要交费金额", Math.Round((zfy - ye), 1)); //Response.Write(JSONConvert.SerializeObject(result)); StringBuilder sb = new StringBuilder(); sb.Append("{"); sb.AppendFormat("success: true,"); sb.AppendFormat("data:{0},", zpgl_lx_lb.ToJson()); sb.AppendFormat("总金额:{0},", Math.Round(Convert.ToDecimal(user_sf_zb["总费用"]), 0)); sb.AppendFormat("上次结余:{0},", user_sf_zb["余额"]); sb.AppendFormat("需要交费金额:{0}", Math.Round((zfy - ye), 0)); sb.Append("}"); Response.Write(sb.ToString()); }
private void list_lr() { string responseError = "{success: false}"; string sql1 = string.Format("select * from sq8szxlx.zpgl where id='{0}'", Request.Params["id"]); RowObject zpgl = DBHelper.GetRow(sql1); if (zpgl == null) { Response.Write(responseError); Response.End(); return; } string sql = string.Format("select * from sq8szxlx.zpgl_lx_lb where 合同编号='{0}' order by id asc", zpgl["编码"]); ResultObject zpgl_lx_lb = DBHelper.GetResult(sql); int xh = int.Parse(Request.Params["xh"]); for (int i = 0; i < zpgl_lx_lb.Count; i++) { JSONObject jo = new JSONObject(); RowObject row = zpgl_lx_lb[i]; row["编号"] = i + 1; if (row["消费类型"].ToString() != "动态") { row["损耗"] = "-"; } // 查询收费列表 string sql_lb = string.Format(@"select * from sq8szxlx.user_sf_lb where 单据编号='{0}_{1}' and 收费项目='{2}'", zpgl["编码"], xh, row["消费项目"]); RowObject user_sf_lb = DBHelper.GetRow(sql_lb); // 查询上月消费总表 string sql_pre_zb = string.Format("select * from sq8szxlx.user_sf_zb where 单据编号='{0}_{1}'", zpgl["编码"], xh - 1); RowObject pre_user_sf_zb = DBHelper.GetRow(sql_pre_zb); // 查询上月收费列表 string pre_sql_lb = string.Format(@"select * from sq8szxlx.user_sf_lb where 单据编号='{0}_{1}' and 收费项目='{2}'", zpgl["编码"], xh - 1, row["消费项目"]); RowObject pre_user_sf_lb = DBHelper.GetRow(pre_sql_lb); if (pre_user_sf_lb == null) // 没有上月读数信息,读取序号为1的单据(前期读数) { pre_sql_lb = string.Format(@"select * from sq8szxlx.user_sf_lb where 单据编号='{0}_{1}' and 收费项目='{2}'", zpgl["编码"], 1, row["消费项目"]); pre_user_sf_lb = DBHelper.GetRow(pre_sql_lb); } if (pre_user_sf_zb["缴费状态"].ToString() == "已缴费" || pre_user_sf_zb["缴费状态"].ToString() == "不要交费") { row["滞纳金"] = 0; } row["上月读数"] = (pre_user_sf_lb != null && row["消费类型"].ToString() == "动态") ? pre_user_sf_lb["读数"] : "-"; if (row["消费类型"].ToString() == "动态" || row["消费类型"].ToString() == "单价") { if (user_sf_lb != null) { row["读数"] = user_sf_lb["读数"]; } else { row["读数"] = ""; } } else { row["读数"] = "-"; } row["读数输入"] = (user_sf_lb != null && user_sf_lb["录入状态"].ToString() == "已录入") ? "√" : "×"; } Response.Write(zpgl_lx_lb.ToJson()); }
private void list_lb() { JSONArray ja = new JSONArray(); // 根据单据编号查询收费项目列表 string sql_lb = string.Format(@"select u.*,z.说明 from sq8szxlx.user_sf_lb u left join sq8szxlx.zpgl_lx_lb z on (u.合同编号=z.合同编号 and z.消费项目=u.收费项目 and z.消费类型=u.收费类型) where u.单据编号='{0}' and not (u.收费项目 is null)", Request.Params["djbh"]); ResultObject r = DBHelper.GetResult(sql_lb); // 本月消费总表 string sql1 = string.Format("select * from sq8szxlx.user_sf_zb where 单据编号='{0}'", Request.Params["djbh"]); RowObject user_sf_zb = DBHelper.GetRow(sql1); int preNo = int.Parse(Request.Params["djbh"].Split('_')[1]) - 1; // 合同信息 sql1 = string.Format("select * from sq8szxlx.zpgl where 编码='{0}'", user_sf_zb["合同编号"]); RowObject zpgl = DBHelper.GetRow(sql1); for (int i = 0; i < r.Count; i++) { RowObject row = r[i]; // 查询上月收费项目 string pre_sql_lb = string.Format(@"select * from sq8szxlx.user_sf_lb where 单据编号='{0}_{1}' and 收费项目='{2}'", row["合同编号"], preNo, row["收费项目"]); RowObject pre_user_sf_lb = DBHelper.GetRow(pre_sql_lb); if (pre_user_sf_lb == null) // 没有上月读数信息,读取序号为1的单据(前期读数) { pre_sql_lb = string.Format(@"select * from sq8szxlx.user_sf_lb where 单据编号='{0}_{1}' and 收费项目='{2}'", row["合同编号"], 1, row["收费项目"]); pre_user_sf_lb = DBHelper.GetRow(pre_sql_lb); } double syds = -1; if (pre_user_sf_lb != null) { syds = Convert.ToDouble(pre_user_sf_lb["读数"]); } JSONObject jo = new JSONObject(); jo.Add("序号", i + 1); string sflx = row["收费类型"].ToString(); double sh = Convert.ToDouble(row["损耗"]); double bl = Convert.ToDouble(row["倍率"]); double byds = Convert.ToDouble(row["读数"]); jo.Add("收费项目", row["收费项目"]); if (sflx == "动态" && syds > -1) { jo.Add("上月读数", syds); } else { jo.Add("上月读数", "-"); } if (sflx == "动态" || sflx == "单价") { jo.Add("本月读数", byds); } else { jo.Add("本月读数", "-"); } jo.Add("倍率", bl); //损耗 if (sflx == "动态") { jo.Add("损耗", string.Format("%{0}", sh)); } else { jo.Add("损耗", "-"); } //总量 string zl = "-"; if (bl == 0) { if (sflx == "动态" && syds > -1) { double dsc = byds - syds; zl = (dsc * (1 + sh / 100)).ToString(); } else if (sflx == "单价") { zl = byds.ToString(); } } else { if (sflx == "动态" && syds > -1) { double dsc = byds - syds; zl = (dsc * (1 + sh / 100) * bl).ToString(); } else if (sflx == "单价") { zl = (byds * bl).ToString(); } } jo.Add("总量", zl); jo.Add("值", row["值"]); jo.Add("滞纳金", row["滞纳金"]); jo.Add("费用", row["费用"]); jo.Add("说明", row["说明"].ToString()); ja.Add(jo); } JSONObject result = new JSONObject(); double zfy = Convert.ToDouble(user_sf_zb["总费用"]); double ye = Convert.ToDouble(user_sf_zb["余额"]); result.Add("success", "true"); result.Add("data", ja); // 合同信息 result.Add("合同编号", user_sf_zb["合同编号"]); result.Add("客户编码", zpgl["客户编码"]); result.Add("客户名称", zpgl["客户名称"]); result.Add("所属工业园", zpgl["所属工业园"]); result.Add("房产类型", zpgl["房产类型"]); result.Add("所属房产", zpgl["所属房产"]); // 收费信息 result.Add("总金额", Math.Round(Convert.ToDecimal(user_sf_zb["总费用"]), 0)); result.Add("上次结余", user_sf_zb["余额"]); result.Add("需要交费金额", Math.Round((zfy - ye), 0)); Response.Write(JSONConvert.SerializeObject(result)); }
private OptionObject SetFieldValue(OptionObject optionObject, string parameter) { OptionObject returnOptionObject = new OptionObject(); List <FormObject> forms = new List <FormObject>(); foreach (var form in optionObject.Forms) { List <FieldObject> fields = new List <FieldObject>(); foreach (var currentField in form.CurrentRow.Fields) { switch (currentField.FieldNumber) { case "123": if (string.IsNullOrEmpty(currentField.FieldValue)) { FieldObject fieldObject = new FieldObject() { Enabled = currentField.Enabled, FieldNumber = currentField.FieldNumber, FieldValue = "I have set the FieldValue.", Lock = currentField.Lock, Required = currentField.Required }; fields.Add(fieldObject); } else { FieldObject fieldObject = new FieldObject() { Enabled = currentField.Enabled, FieldNumber = currentField.FieldNumber, FieldValue = currentField.FieldValue + " (I have appended the FieldValue.)", Lock = currentField.Lock, Required = currentField.Required }; fields.Add(fieldObject); } break; default: break; } } if (fields.Count > 0) { RowObject rowObject = new RowObject() { Fields = fields, ParentRowId = form.CurrentRow.ParentRowId, RowAction = "EDIT", RowId = form.CurrentRow.RowId, }; FormObject formObject = new FormObject() { CurrentRow = rowObject, FormId = form.FormId, MultipleIteration = form.MultipleIteration }; forms.Add(formObject); } } returnOptionObject.Forms = forms; returnOptionObject.ErrorCode = 0; returnOptionObject.ErrorMesg = "If FieldNumber 123 is found in OptionObject, then it should be the only FieldObject returned. Otherwise, no Forms should be returned."; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.EpisodeNumber = optionObject.EpisodeNumber; returnOptionObject.Facility = optionObject.Facility; //returnOptionObject.NamespaceName = optionObject.NamespaceName; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.OptionStaffId = optionObject.OptionStaffId; returnOptionObject.OptionUserId = optionObject.OptionUserId; //returnOptionObject.ParentNamespace = optionObject.ParentNamespace; //returnOptionObject.ServerName = optionObject.ServerName; returnOptionObject.SystemCode = optionObject.SystemCode; //returnOptionObject.SessionToken = optionObject.SessionToken; return(returnOptionObject); }
private OptionObject LoadDisclaimers(OptionObject optionObject) { OptionObject returnOptionObject = new OptionObject(); #region General Disclaimer FieldObject GeneralDisclaimer = new FieldObject(); GeneralDisclaimer.FieldNumber = "130.62"; GeneralDisclaimer.Lock = "1"; GeneralDisclaimer.Enabled = "0"; GeneralDisclaimer.Required = "0"; GeneralDisclaimer.FieldValue = "Personal property will be held no longer than 7 days after discharge date. " + "At that time, HBH personnel will dispose of any property not retrieved, " + "at their discretion. Above is a correct listing of my personal effects and belongings, " + "which HBH will not be held responsible for and hereby I take full responsibility for keeping in my possession."; #endregion #region CSU Disclaimer Retain FieldObject CSUDisclaimerRetain = new FieldObject(); CSUDisclaimerRetain.FieldNumber = "130.65"; CSUDisclaimerRetain.Lock = "1"; CSUDisclaimerRetain.Enabled = "0"; CSUDisclaimerRetain.Required = "0"; CSUDisclaimerRetain.FieldValue = "All valuables such as wallets, money, jewelry, etc. will be logged separately to ensure safekeeping. " + "(Shoe laces, articles of clothing with strings, belts, duffel-type bags, perfumes, etc. " + "are to be secured in the property room according to Bed #). " + "These items will be retrieved upon Discharge from Unit.\r\n\r\n" + "Above is a correct listing of my personal effects and belongings, which I hereby place in custody of HBH. " + "By signing below, I hereby relieve HBH and its employees for any loss or damage."; #endregion #region CSU Disclaimer Return FieldObject CSUDisclaimerReturn = new FieldObject(); CSUDisclaimerReturn.FieldNumber = "130.66"; CSUDisclaimerReturn.Lock = "1"; CSUDisclaimerReturn.Enabled = "0"; CSUDisclaimerReturn.Required = "0"; CSUDisclaimerReturn.FieldValue = "I hereby acknowledge that all personal property deposited at HBH has been returned to me."; #endregion var fieldsDisclaimerForm = new FieldObject[1]; fieldsDisclaimerForm[0] = GeneralDisclaimer; var fieldsCSUForm = new FieldObject[2]; fieldsCSUForm[0] = CSUDisclaimerRetain; fieldsCSUForm[1] = CSUDisclaimerReturn; var forms = new FormObject[2]; #region Disclaimer Form / 1st Tab var DisclaimerForm = new FormObject(); var DisclaimerCurrentRow = new RowObject(); DisclaimerCurrentRow.Fields = fieldsDisclaimerForm; DisclaimerCurrentRow.RowId = optionObject.Forms[0].CurrentRow.RowId; DisclaimerCurrentRow.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; DisclaimerCurrentRow.RowAction = "EDIT"; DisclaimerForm.CurrentRow = DisclaimerCurrentRow; DisclaimerForm.FormId = "949"; forms[0] = DisclaimerForm; #endregion #region CSU Form / 2nd Tab var CSUForm = new FormObject(); var CSUCurrentRow = new RowObject(); CSUCurrentRow.Fields = fieldsCSUForm; CSUCurrentRow.RowId = optionObject.Forms[1].CurrentRow.RowId; CSUCurrentRow.ParentRowId = optionObject.Forms[1].CurrentRow.ParentRowId; CSUCurrentRow.RowAction = "EDIT"; CSUForm.CurrentRow = CSUCurrentRow; CSUForm.FormId = "953"; forms[1] = CSUForm; #endregion returnOptionObject.Forms = forms; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.Facility = optionObject.Facility; returnOptionObject.SystemCode = optionObject.SystemCode; return returnOptionObject; }
/** * <summary>Ends the content row.</summary> * <param name="broken">Indicates whether this is the end of a paragraph.</param> */ private void EndRow( bool broken ) { if (rowEnded) { return; } rowEnded = true; double[] objectXOffsets = new double[currentRow.Objects.Count]; // Horizontal object displacements. double wordSpace = 0; // Exceeding space among words. double rowXOffset = 0; // Horizontal row offset. List <RowObject> objects = currentRow.Objects; // Horizontal alignment. XAlignmentEnum xAlignment = this.xAlignment; switch (xAlignment) { case XAlignmentEnum.Left: break; case XAlignmentEnum.Right: rowXOffset = frame.Width - currentRow.Width; break; case XAlignmentEnum.Center: rowXOffset = (frame.Width - currentRow.Width) / 2; break; case XAlignmentEnum.Justify: // Are there NO spaces? if (currentRow.SpaceCount == 0 || broken) // NO spaces. { /* NOTE: This situation equals a simple left alignment. */ xAlignment = XAlignmentEnum.Left; } else // Spaces exist. { // Calculate the exceeding spacing among the words! wordSpace = (frame.Width - currentRow.Width) / currentRow.SpaceCount; // Define the horizontal offsets for justified alignment. for ( int index = 1, count = objects.Count; index < count; index++ ) { /* * NOTE: The offset represents the horizontal justification gap inserted * at the left side of each object. */ objectXOffsets[index] = objectXOffsets[index - 1] + objects[index - 1].SpaceCount * wordSpace; } } break; } SetWordSpace wordSpaceOperation = new SetWordSpace(wordSpace); // Vertical alignment and translation. for ( int index = objects.Count - 1; index >= 0; index-- ) { RowObject obj = objects[index]; // Vertical alignment. double objectYOffset = 0; { LineAlignmentEnum lineAlignment; double lineRise; { object objectLineAlignment = obj.LineAlignment; if (objectLineAlignment is Double) { lineAlignment = LineAlignmentEnum.BaseLine; lineRise = (double)objectLineAlignment; } else { lineAlignment = (LineAlignmentEnum)objectLineAlignment; lineRise = 0; } } switch (lineAlignment) { case LineAlignmentEnum.Top: /* NOOP */ break; case LineAlignmentEnum.Middle: objectYOffset = -(currentRow.Height - obj.Height) / 2; break; case LineAlignmentEnum.BaseLine: objectYOffset = -(currentRow.BaseLine - obj.BaseLine - lineRise); break; case LineAlignmentEnum.Bottom: objectYOffset = -(currentRow.Height - obj.Height); break; default: throw new NotImplementedException("Line alignment " + lineAlignment + " unknown."); } } IList <ContentObject> containedGraphics = obj.Container.Objects; // Word spacing. containedGraphics.Insert(0, wordSpaceOperation); // Translation. containedGraphics.Insert( 0, new ModifyCTM( 1, 0, 0, 1, objectXOffsets[index] + rowXOffset, // Horizontal alignment. objectYOffset // Vertical alignment. ) ); } // Update the actual block height! boundBox.Height = (float)(currentRow.Y + currentRow.Height); // Update the actual block vertical location! double yOffset; switch (yAlignment) { case YAlignmentEnum.Bottom: yOffset = frame.Height - boundBox.Height; break; case YAlignmentEnum.Middle: yOffset = (frame.Height - boundBox.Height) / 2; break; case YAlignmentEnum.Top: default: yOffset = 0; break; } boundBox.Y = (float)(frame.Y + yOffset); // Discard the current row! currentRow = null; }
private OptionObject MakeEpisodeRequired(OptionObject optionObject) { var returnOptionObject = new OptionObject(); var episode = new FieldObject { FieldNumber = "12001", Required = "1" }; var fields = new FieldObject[1]; fields[0] = episode; var currentRow = new RowObject(); currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; var formObject = new FormObject { FormId = "12001" }; formObject.CurrentRow = currentRow; var forms = new FormObject[1]; forms[0] = formObject; returnOptionObject.Forms = forms; returnOptionObject.EntityID = optionObject.EntityID; returnOptionObject.OptionId = optionObject.OptionId; returnOptionObject.SystemCode = optionObject.SystemCode; returnOptionObject.Facility = optionObject.Facility; return returnOptionObject; }
private OptionObject DefaultSubstanceAbuse(OptionObject optionObject) { var returnOptionObject = new OptionObject { EntityID = optionObject.EntityID, OptionId = optionObject.OptionId, SystemCode = optionObject.SystemCode, Facility = optionObject.Facility }; var clinician = new FieldObject { FieldNumber = "5.14" }; var status = new FieldObject { FieldNumber = "141.36", FieldValue = "F" }; var aDate = new FieldObject { FieldNumber = "5.13" }; var aTime = new FieldObject { FieldNumber = "5.18" }; foreach (var field in optionObject.Forms[0].CurrentRow.Fields) { if (field.FieldNumber.Equals(aDate.FieldNumber)) aDate.FieldValue = field.FieldValue; if (field.FieldNumber.Equals(aTime.FieldNumber)) aTime.FieldValue = field.FieldValue; } if (!aDate.FieldValue.Equals(String.Empty) && !aTime.FieldValue.Equals(String.Empty)) { var connectionString = ConfigurationManager.ConnectionStrings["CacheODBCCWS"].ConnectionString; const string commandText = "SELECT t.staff_member_id " + "FROM SYSTEM.Substance_Abuse_Assessment tempTbl " + "INNER JOIN SYSTEM.RADplus_users t " + "ON tempTbl.Data_Entry_User_Id = t.USERID " + "AND tempTbl.FACILITY = t.FACILITY " + "WHERE tempTbl.PATID=? " + "AND tempTbl.EPISODE_NUMBER=? " + "AND tempTbl.Assessing_Date=? " + "AND tempTbl.Assessment_Time=? "; using (var connection = new OdbcConnection(connectionString)) { connection.Open(); using (var dbcommand = new OdbcCommand(commandText, connection)) { var dbparameter1 = new OdbcParameter("PATID", optionObject.EntityID); dbcommand.Parameters.Add(dbparameter1); var dbparameter2 = new OdbcParameter("EPISODE_NUMBER", optionObject.EpisodeNumber); dbcommand.Parameters.Add(dbparameter2); var dbparameter3 = new OdbcParameter("Assessment_Date", DateTime.Parse(aDate.FieldValue).ToString("yyyy-MM-dd")); dbcommand.Parameters.Add(dbparameter3); var dbparameter4 = new OdbcParameter("Assessment_Time", aTime.FieldValue); dbcommand.Parameters.Add(dbparameter4); using (var reader = dbcommand.ExecuteReader()) { if (reader.Read()) { clinician.FieldValue = reader["staff_member_id"].ToString(); } } } connection.Close(); } var fields = new FieldObject[2]; fields[0] = clinician; fields[1] = status; var currentRow = new RowObject(); currentRow.Fields = fields; currentRow.RowId = optionObject.Forms[0].CurrentRow.RowId; currentRow.ParentRowId = optionObject.Forms[0].CurrentRow.ParentRowId; currentRow.RowAction = "EDIT"; var formObject = new FormObject { FormId = "17" }; formObject.CurrentRow = currentRow; var forms = new FormObject[1]; forms[0] = formObject; returnOptionObject.Forms = forms; } return returnOptionObject; }
public void AddFieldObject_ToRowObject_NullFieldObject() { RowObject rowObject = new RowObject(); rowObject = (RowObject)OptionObjectHelpers.AddFieldObject(rowObject, null); Assert.AreNotEqual(rowObject, null); }
protected OptionObject clearZipCodeIfAllNines(OptionObject optionObject, string scriptName) { var formSelected = optionObject.Forms.FirstOrDefault(f => f.FormId == "510"); var rowSelected = formSelected.CurrentRow; var fieldSelected = rowSelected.Fields.FirstOrDefault(f => f.FieldNumber == "6"); OptionObject oo = new OptionObject(); FormObject fo = new FormObject(); RowObject ro = new RowObject(); FieldObject ssn = rowSelected.Fields.FirstOrDefault(f => f.FieldNumber == "6"); ro.RowId = rowSelected.RowId; ro.ParentRowId = rowSelected.ParentRowId; ro.RowAction = "EDIT"; fo.FormId = formSelected.FormId; fo.MultipleIteration = formSelected.MultipleIteration; if (fieldSelected.FieldValue == "999-99-9999") { oo.ErrorCode = 1; oo.ErrorMesg = "<h3><font color='red'> Error </font></h3> <br>"+ "<b>Invalid Social Security Number.<br>"+ "Social Security Number can't be <u>999-99-9999</u></b> <br><br>"+ "<u><b>Note:</b></u> If you do not know the individual's ssn please " + "use all 8's (i.e 888-88-8888) which will automatically convert to the pseudo # required for state reporting."; oo.EntityID = optionObject.EntityID; oo.OptionId = optionObject.OptionId; oo.SystemCode = optionObject.SystemCode; oo.Facility = optionObject.Facility; } oo.EntityID = optionObject.EntityID; oo.OptionId = optionObject.OptionId; oo.SystemCode = optionObject.SystemCode; oo.Facility = optionObject.Facility; fo.CurrentRow = ro; List<FormObject> formsList = new List<FormObject>(); formsList.Add(fo); oo.Forms = formsList.ToArray(); return oo; }
private void list_zb() { //取得合同开始结束时间 RowObject r = DBHelper.GetRow(string.Format(@"select * from sq8szxlx.zpgl where 编码='{0}'", Request.Params["htbh"])); if (r == null) { Response.Write("success:false"); Response.End(); return; } int year1 = Int32.Parse(r["合同开始时间_年"].ToString()); int year2 = Int32.Parse(r["合同结束时间_年"].ToString()); int month1 = Int32.Parse(r["合同开始时间_月"].ToString()); int month2 = Int32.Parse(r["合同结束时间_月"].ToString()); int no = 1; JSONArray ja = new JSONArray(); for (int i = year1; i <= year2; i++) { int j = 1; if (i == year1) { j = month1; } int j_max = 12; if (i == year2) { j_max = month2; } for (; j <= j_max; j++) { JSONObject jo = new JSONObject(); jo.Add("序号", no); no++; // 读取总表数据 string sql = string.Format(@"select * from sq8szxlx.user_sf_zb where 合同编号='{0}' and 日期年='{1}' and 日期月='{2}' order by id desc", Request.Params["htbh"], i, j); r = DBHelper.GetRow(sql); jo.Add("年份月份", string.Format("{0}/{1}", i, j)); if (r != null) { jo.Add("id", r["id"]); jo.Add("单据编号", r["单据编号"]); jo.Add("总费用", (r["总费用"] is DBNull)?0: Math.Round(Convert.ToDecimal(r["总费用"]), 0)); jo.Add("缴费金额", r["缴费金额"]); jo.Add("余额", r["余额"]); jo.Add("录入状态", r["录入状态"]); jo.Add("缴费状态", r["缴费状态"]); } else { jo.Add("单据编号", "-"); jo.Add("总费用", "-"); jo.Add("缴费金额", "-"); jo.Add("余额", "-"); if (i == DateTime.Now.Year && j == DateTime.Now.Month) { jo.Add("录入状态", "未录入"); jo.Add("缴费状态", "未缴费"); } else if (i > DateTime.Now.Year || (i == DateTime.Now.Year && j > DateTime.Now.Month)) { jo.Add("录入状态", "不能录入"); jo.Add("缴费状态", "不能缴费"); } else { jo.Add("录入状态", "未录入"); jo.Add("缴费状态", "未缴费"); } } ja.Add(jo); } } string ret = JSONConvert.SerializeArray(ja); Response.Write(ret); }