/// <summary> /// 增加一条数据 /// </summary> public int Add(TF.RunSafty.Model.Tab_Config_LED_Class_Order model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Tab_Config_LED_Class_Order("); strSql.Append("strCheJianGUID,strCheJianNickName,strJiaoLuGUID,strJiaoLuNickName,strTitle,strKeHuDuanGUID)"); strSql.Append(" values ("); strSql.Append("@strCheJianGUID,@strCheJianNickName,@strJiaoLuGUID,@strJiaoLuNickName,@strTitle,@strKeHuDuanGUID)"); SqlParameter[] parameters = { new SqlParameter("@strCheJianGUID", SqlDbType.VarChar, 50), new SqlParameter("@strCheJianNickName", SqlDbType.VarChar, 50), new SqlParameter("@strJiaoLuGUID", SqlDbType.VarChar, 50), new SqlParameter("@strJiaoLuNickName", SqlDbType.VarChar, 50), new SqlParameter("@strTitle", SqlDbType.VarChar, 50), new SqlParameter("@strKeHuDuanGUID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.strCheJianGUID; parameters[1].Value = model.strCheJianNickName; parameters[2].Value = model.strJiaoLuGUID; parameters[3].Value = model.strJiaoLuNickName; parameters[4].Value = model.strTitle; parameters[5].Value = model.strKeHuDuanGUID; int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(1); } else { return(0); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.Tab_Config_LED_Class_Order DataRowToModel(DataRow row) { TF.RunSafty.Model.Tab_Config_LED_Class_Order model = new TF.RunSafty.Model.Tab_Config_LED_Class_Order(); if (row != null) { if (row["nid"] != null && row["nid"].ToString() != "") { model.nid = int.Parse(row["nid"].ToString()); } if (row["strCheJianGUID"] != null) { model.strCheJianGUID = row["strCheJianGUID"].ToString(); } if (row["strCheJianName"] != null) { model.strCheJianName = row["strCheJianName"].ToString(); } if (row["strCheJianNickName"] != null) { model.strCheJianNickName = row["strCheJianNickName"].ToString(); } if (row["strJiaoLuGUID"] != null) { model.strJiaoLuGUID = row["strJiaoLuGUID"].ToString(); } if (row["strJiaoLuName"] != null) { model.strJiaoLuName = row["strJiaoLuName"].ToString(); } if (row["strJiaoLuNickName"] != null) { model.strJiaoLuNickName = row["strJiaoLuNickName"].ToString(); } if (row["strTitle"] != null) { model.strTitle = row["strTitle"].ToString(); } } return(model); }
public List <TF.RunSafty.Model.Tab_Config_LED_Class_Order> GetPlaceList(List <TF.RunSafty.Model.Tab_Config_LED_Class_Order> placeList) { if (placeList != null) { List <TF.RunSafty.Model.Tab_Config_LED_Class_Order> resultList = new List <TF.RunSafty.Model.Tab_Config_LED_Class_Order>(); foreach (TF.RunSafty.Model.Tab_Config_LED_Class_Order place in placeList) { TF.RunSafty.Model.Tab_Config_LED_Class_Order model = new TF.RunSafty.Model.Tab_Config_LED_Class_Order(); model.strCheJianGUID = place.strCheJianGUID; model.strCheJianName = place.strCheJianName.ToString(); model.strCheJianNickName = place.strCheJianNickName; model.strJiaoLuGUID = place.strJiaoLuGUID; model.strJiaoLuName = place.strJiaoLuName; model.strJiaoLuNickName = place.strJiaoLuNickName; model.strTitle = place.strTitle; resultList.Add(model); } return(resultList); } return(null); }