//для nar.dbo.sp_test_read
public static string executeProcSelect(SqlConnection connection, StoreProc proc)
{
string sqlExpression = proc.sp_name;
StringBuilder sb = new StringBuilder();
SqlCommand command = new SqlCommand(sqlExpression, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Clear();
DataTable dt = new DataTable();
if (proc.prms != null)
{
foreach (SpParam param in proc.prms)
{
command.Parameters.Add(new SqlParameter(param.param_name, param.prop_name));
}
}
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
da.Fill(dt);
using (var parser = new ChoJSONWriter(sb))
parser.Write(dt);
}
return(sb.ToString());
}
protected void DisplayMetaTags()
{
StoreProc _obj = new StoreProc();
DataTable dt = new DataTable();
dt = _obj.GetStaticPages(Convert.ToInt32(Request["id"]));
if (dt.Rows.Count > 0)
{
((HtmlMeta)Master.FindControl("_metaKeywords")).Attributes.Add("Content", dt.Rows[0]["MetaKeywords"].ToString());
((HtmlMeta)Master.FindControl("_metaDescription")).Attributes.Add("Content", dt.Rows[0]["MetaDesc"].ToString());
}
}
protected void DisplayMetaTags()
{
StoreProc _obj = new StoreProc();
DataTable dt = new DataTable();
dt = _obj.GetStaticPages(Convert.ToInt32(Request["id"]));
if (dt.Rows.Count > 0)
{
litPageHeading.Text = Convert.ToString(dt.Rows[0]["PageTitle"]);
litPageDesc.Text = Convert.ToString(dt.Rows[0]["pagedesc"]);
a = litPageHeading.Text;
((HtmlTitle)Master.FindControl("_metaTitle")).Text = dt.Rows[0]["metatitle"].ToString();
((HtmlMeta)Master.FindControl("_metaKeywords")).Attributes.Add("Content", dt.Rows[0]["metakeywords"].ToString());
((HtmlMeta)Master.FindControl("_metaDescription")).Attributes.Add("Content", dt.Rows[0]["metadesc"].ToString());
}
}
// для nar.dbo.sp_test_ins
public static void executeProcIns(SqlConnection connection, StoreProc proc, ModelExchange mE)
{
string sqlExpression = proc.sp_name;
using (SqlCommand command = new SqlCommand(sqlExpression, connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
/*foreach (var track in music.Tracks)
* {
* command.Parameters.Clear();
* command.Parameters.Add(new SqlParameter("@album", track.Album));
* command.Parameters.Add(new SqlParameter("@artist", track.Artist));
* command.Parameters.Add(new SqlParameter("@title", track.Title));
* command.Parameters.Add(new SqlParameter("@year", track.Year));
* var result = command.ExecuteNonQuery();
* }
*/
}
}
