private string GetBasicData(decimal objectId, string fieldId, string conCode, string buildingCode, string houseCode, string unitCode, string objectType) { var formView = new FormLogic().GetFormDataByObjectId(Convert.ToInt32(objectId), 1); List <Redas.Entities.Ompd.FormLabelDTO> lstLabel = formView.LABLELIST.ToList(); string value = ""; using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("i_object_id", objectId); dic.Add("i_unit_code", unitCode); dic.Add("i_house_code", houseCode); dic.Add("i_building_code", buildingCode); dic.Add("i_construction_code", conCode); dic.Add("i_new_purpose_id", objectType); dic.Add("i_field_id", fieldId); value = dbHelper.ExecuteScalarProc("pkg_object.sp_redas_basicData_get", dic).ToString(); } catch { } } return(value); //StringBuilder strSql = new StringBuilder(); //strSql.Append("select f.fsq_field as FIELDNAME,t.fsq_table as TABLENAME from t_redas_db_field f "); //strSql.Append(" inner join t_redas_db_table t on f.db_table_id=t.db_table_id "); //strSql.Append(" where f.fsq_field_id=:i_fieldId and t.is_virutal=0"); //Dictionary<string, object> parameters = new Dictionary<string, object>(); //parameters["i_fieldId"] = fieldId; //var obj = new RedasDBHelper().ExecuteList<STRINGMODEL>(strSql.ToString(), parameters); //if (obj.Count > 0) //{ // strSql = new StringBuilder(); // strSql.Append("select " + obj[0].FIELDNAME + " from " + obj[0].TABLENAME + ""); //} //else //{ //} }
//获得补齐资料的值 private string GetAddInfoItemValue(decimal objectId, string tableId, string fieldId) { using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("i_object_id", objectId); dic.Add("i_table_id", tableId); dic.Add("i_field_id", fieldId); var obj = dbHelper.ExecuteScalarProc("pkg_object.sp_AddInfoItemValue_get", dic); return(obj == null ? string.Empty : obj.ToString()); } catch { } } return(string.Empty); }
// /// <summary> /// 获得询价信息中的多个表单的信息 /// </summary> /// <param name="objectId"></param> /// <param name="type">1:询价 2:查勘</param> /// <returns></returns> public JArray GetDynamicFormData(decimal objectId, int type) { JArray jArray = new JArray(); using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary<string, object> dic = new Dictionary<string, object>(); dic.Add("i_object_id", objectId); dic.Add("i_type", type); var obj = dbHelper.ExecuteScalarProc("pkg_object.sp_redas_formData_get", dic); if (obj != null) { jArray = JArray.Parse(obj.ToString()); } } catch { throw; } } return jArray; }
private string GetBasicData(decimal objectId, string fieldId, string conCode, string buildingCode, string houseCode, string unitCode, string objectType) { string value = ""; using (BaseDB dbHelper = new RedasDBHelper()) { try { Dictionary<string, object> dic = new Dictionary<string, object>(); dic.Add("i_object_id", objectId); dic.Add("i_unit_code", unitCode); dic.Add("i_house_code", houseCode); dic.Add("i_building_code", buildingCode); dic.Add("i_construction_code", conCode); dic.Add("i_new_purpose_id", objectType); dic.Add("i_field_id", fieldId); value = dbHelper.ExecuteScalarProc("pkg_object.sp_redas_basicData_get", dic).ToString(); } catch { } } return value; }