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;
        }
Ejemplo n.º 4
0
        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;
        }
Ejemplo n.º 6
0
        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;
        }
Ejemplo n.º 11
0
        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;
                }
            }
        }
Ejemplo n.º 12
0
 private FormObject GetFormContainingRow(RowObject row)
 {
     FormObject form = optionObject.Forms.FirstOrDefault(f => f.CurrentRow.Equals(row));
     return form;
 }
Ejemplo n.º 13
0
    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;
        }
Ejemplo n.º 15
0
        /**
          <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;}
        }
Ejemplo n.º 16
0
    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();
    }
Ejemplo n.º 17
0
        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)
                    }
                }));
            }
        }
Ejemplo n.º 18
0
 public bool IsMultiValuedField(RowObject rowObject)
 {
     return(rowObject.Value == mMultipleValues ||
            rowObject.Value == mMultipleProtectedValues);
 }
Ejemplo n.º 19
0
    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;
        }
Ejemplo n.º 21
0
 /// <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;
 }
Ejemplo n.º 23
0
 /// <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;
Ejemplo n.º 24
0
    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));
    }
Ejemplo n.º 25
0
        /**
         * <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;
        }
Ejemplo n.º 26
0
    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);
        }
Ejemplo n.º 28
0
        /**
         * <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);
        }
Ejemplo n.º 29
0
 protected virtual CustomRowObject TransformRow(RowObject row)
 {
     return(new RowObjectTransform().TransformToCustomRowObject(row));
 }
Ejemplo n.º 30
0
    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();
    }
Ejemplo n.º 31
0
    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;
        }
Ejemplo n.º 33
0
        /// <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;
 }
Ejemplo n.º 44
0
        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;
        }
Ejemplo n.º 47
0
    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());
    }
Ejemplo n.º 48
0
    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());
    }
Ejemplo n.º 49
0
    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));
    }
Ejemplo n.º 50
0
        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;
        }
Ejemplo n.º 52
0
        /**
         * <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;
 }
Ejemplo n.º 55
0
 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&#39s ssn please " +
                                "use all 8&#39s (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;
        }
Ejemplo n.º 57
0
    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);
    }