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;
}