public static BaoJingRen GetById(string id)
{
DataTable dt = SqlHelper.Adapter("select * from T_报警人信息 where 案件编号=@案件编号 and isdel=0",
new SqlParameter("@案件编号", id));
return(ToBaoJingRen(dt.Rows[0]));
}
public static CaseInfo GetById(string id)
{
DataTable dt = SqlHelper.Adapter("select * from T_案件基本信息 where 案件编号=@案件编号 and isDel=0",
new SqlParameter("@案件编号", id));
return(ToCaseInfo(dt.Rows[0]));
}
private DataTable LoadAllProcNames()
{
String sql = "select name from sys.objects where type='P' and name like 'usp_report%'";
var dt = SqlHelper.Adapter(sql);
return(dt);
}
public static CaseInfo[] GetAll()
{
DataTable dt = SqlHelper.Adapter("select * from T_案件基本信息 where isDel=0");
CaseInfo[] cases = new CaseInfo[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
cases[i] = ToCaseInfo(dt.Rows[i]);
}
return(cases);
}
private String Export(String name)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("if exists(select 1 from sys.objects where type='P' and name='{0}'){1}", name, Environment.NewLine);
sb.AppendFormat("drop proc {0}{1}", name, Environment.NewLine);
sb.AppendFormat("go{0}", Environment.NewLine);
var text = SqlHelper.Adapter("sp_helptext " + name);
text.AsEnumerable().ToList().ForEach(dr =>
{
sb.Append(dr.Field <String>(0));
});
sb.AppendFormat("{0}go{0}", Environment.NewLine);
return(sb.ToString());
}