public static int UpdateServiceTag(SqlDbHelper dbhelper, ServiceTagModel model)
{
using (var cmd = new SqlCommand(@"UPDATE Configuration.[dbo].[tbl_ProductServiceTag] SET ServiceTag=@ServiceTag,ServiceDescribe=@ServiceDescribe,ProductTag=@ProductTag,ProductDescribe=@ProductDescribe WHERE PKID=@PKID"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@PKID", model.PKID);
cmd.Parameters.AddWithValue("@ServiceTag", model.ServiceTag);
cmd.Parameters.AddWithValue("@ServiceDescribe", model.ServiceDescribe);
// cmd.Parameters.AddWithValue("@ProductTag", model.ProductTag.Trim()??null);
// cmd.Parameters.AddWithValue("@ProductDescribe", model.ProductDescribe.Trim()??null);
if (!string.IsNullOrWhiteSpace(model.ProductTag))
{
cmd.Parameters.AddWithValue("@ProductTag", model.ProductTag.Trim());
}
else
{
cmd.Parameters.AddWithValue("@ProductTag", null);
}
if (!string.IsNullOrWhiteSpace(model.ProductDescribe))
{
cmd.Parameters.AddWithValue("@ProductDescribe", model.ProductDescribe.Trim());
}
else
{
cmd.Parameters.AddWithValue("@ProductDescribe", DBNull.Value);
}
return(dbhelper.ExecuteNonQuery(cmd));
}
}
public static int InsertServiceTag(SqlDbHelper dbhelper, ServiceTagModel model)
{
using (var cmd = new SqlCommand("Configuration..ServiceTag_InsertServiceTag"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Type", model.Type);
cmd.Parameters.AddWithValue("@ServiceTag", model.ServiceTag);
cmd.Parameters.AddWithValue("@ServiceDescribe", model.ServiceDescribe);
if (!string.IsNullOrWhiteSpace(model.ProductTag))
{
cmd.Parameters.AddWithValue("@ProductTag", model.ProductTag.Trim());
}
else
{
cmd.Parameters.AddWithValue("@ProductTag", null);
}
if (!string.IsNullOrWhiteSpace(model.ProductDescribe))
{
cmd.Parameters.AddWithValue("@ProductDescribe", model.ProductDescribe.Trim());
}
else
{
cmd.Parameters.AddWithValue("@ProductDescribe", null);
}
cmd.Parameters.Add("@Result", SqlDbType.Int).Direction = ParameterDirection.Output;
dbhelper.ExecuteNonQuery(cmd);
return(Convert.ToInt32(cmd.Parameters["@Result"].Value));
}
}
public static IEnumerable <ServiceTagModel> SelectServiceTag()
{
List <ServiceTagModel> list = new List <ServiceTagModel>();
var dt = DALServiceTag.SelectServiceTag();
if (dt == null || dt.Rows.Count == 0)
{
return(new ServiceTagModel[0]);
}
var dic = dt.Rows.Cast <DataRow>().Select(row => new ServiceTagModel(row)).GroupBy(c => c.PKID).ToDictionary(r => r.Key, r => r.ToList());
foreach (var value in dic.Values)
{
var model = new ServiceTagModel()
{
PKID = value.FirstOrDefault().PKID,
Type = value.FirstOrDefault().Type,
ServiceTag = value.FirstOrDefault().ServiceTag,
ServiceDescribe = value.FirstOrDefault().ServiceDescribe,
ProductTag = value.FirstOrDefault().ProductTag,
ProductDescribe = value.FirstOrDefault().ProductDescribe,
ServiceDescribeTID = value.FirstOrDefault().ServiceDescribeTID,
ServiceIDs = new List <string>(),
DisplayNames = new List <string>()
};
foreach (var item in value)
{
if (item.PID != "" && item.PID != null)
{
model.ServiceIDs.Add(item.PID);
}
else if (item.Category != "" && item.Category != null)
{
model.ServiceIDs.Add(item.Category);
model.DisplayNames.Add(item.DisplayName);
}
else
{
}
}
if (model.ServiceIDs.Count() > 0)
{
model.StrServiceIDs = string.Join(";", model.ServiceIDs);
model.StrDisplayNames = string.Join(";", model.DisplayNames);
}
list.Add(model);
}
return(list);
}