public static Hashtable Insert(Model.NConfigDictionary model, Hashtable MyHs) { StringBuilder strSql = new StringBuilder(); string guid = Guid.NewGuid().ToString(); strSql.Append("insert into NConfigDictionary("); strSql.Append("NDTpye,DKey,StartLevel,EndLevel,StartRec,EndRec,DValue,Remark)"); strSql.Append(" values ("); strSql.Append("@NDTpye,@DKey,@StartLevel,@EndLevel,@StartRec,@EndRec,@DValue,@Remark)"); SqlParameter[] parameters = { new SqlParameter("@NDTpye", SqlDbType.VarChar, 50), new SqlParameter("@DKey", SqlDbType.VarChar, 10), new SqlParameter("@StartLevel", SqlDbType.Int, 4), new SqlParameter("@EndLevel", SqlDbType.Int, 4), new SqlParameter("@StartRec", SqlDbType.Int, 4), new SqlParameter("@EndRec", SqlDbType.Int, 4), new SqlParameter("@DValue", SqlDbType.VarChar, 10), new SqlParameter("@Remark", SqlDbType.VarChar, 100) }; parameters[0].Value = model.NDTpye; parameters[1].Value = model.DKey; parameters[2].Value = model.StartLevel; parameters[3].Value = model.EndLevel; parameters[4].Value = model.StartRec; parameters[5].Value = model.EndRec; parameters[6].Value = model.DValue; parameters[7].Value = model.Remark; strSql.AppendFormat("; select '{0}';", guid); MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 转换数据实体 /// </summary> /// <param name="table"></param> /// <returns></returns> private static Model.NConfigDictionary TranEntity(DataRow row) { Model.NConfigDictionary model = new Model.NConfigDictionary(); if (row != null) { if (row["NDTpye"] != null) { model.NDTpye = row["NDTpye"].ToString(); } if (row["DKey"] != null) { model.DKey = row["DKey"].ToString(); } if (row["StartLevel"] != null && row["StartLevel"].ToString() != "") { model.StartLevel = int.Parse(row["StartLevel"].ToString()); } if (row["EndLevel"] != null && row["EndLevel"].ToString() != "") { model.EndLevel = int.Parse(row["EndLevel"].ToString()); } if (row["StartRec"] != null && row["StartRec"].ToString() != "") { model.StartRec = int.Parse(row["StartRec"].ToString()); } if (row["EndRec"] != null && row["EndRec"].ToString() != "") { model.EndRec = int.Parse(row["EndRec"].ToString()); } if (row["DValue"] != null) { model.DValue = row["DValue"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return(model); }