internal Weixin_template GetWeixinTmpl(int comid, string infotype) { string sql = @"SELECT [id] ,[comid] ,[infotype] ,[template_id] ,[template_name] ,[first_DATA] ,[remark_DATA] FROM [EtownDB].[dbo].[weixin_template] where comid=@comid and infotype=@infotype"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@comid", comid); cmd.AddParam("@infotype", infotype); using (var reader = cmd.ExecuteReader()) { Weixin_template m = null; if (reader.Read()) { m = new Weixin_template { Id = reader.GetValue <int>("id"), Comid = reader.GetValue <int>("comid"), Infotype = reader.GetValue <string>("infotype"), Template_id = reader.GetValue <string>("template_id"), Template_name = reader.GetValue <string>("template_name"), First_DATA = reader.GetValue <string>("first_data"), Remark_DATA = reader.GetValue <string>("remark_data") }; } return(m); } }
internal Weixin_template Templatemodelinfo(int id) { string sql = @"SELECT * FROM [weixin_template_model] where id=@id"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@id", id); using (var reader = cmd.ExecuteReader()) { Weixin_template m = null; if (reader.Read()) { m = new Weixin_template { Id = reader.GetValue <int>("id"), Template_id = reader.GetValue <string>("Template_id"), First_DATA = reader.GetValue <string>("First_DATA"), Remark_DATA = reader.GetValue <string>("Remark_DATA"), Infotype = reader.GetValue <string>("Infotype"), Template_name = reader.GetValue <string>("Template_name") }; } return(m); } }