/// <summary> /// 通过操作编码获取 /// </summary> /// <param name="actionCode"></param> /// <returns></returns> public Model.FileLogModel GetModel(string actionCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from " + databaseprefix + "FileLog "); strSql.Append(" where actionCode=@actionCode"); SqlParameter[] parameters = { new SqlParameter("@actionCode", SqlDbType.NVarChar) }; parameters[0].Value = actionCode; Model.FileLogModel model = new Model.FileLogModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model = GetModelByDataRow(ds.Tables[0].Rows[0]); return(model); } else { return(null); } }
/// <summary> /// 转化为model /// </summary> /// <param name="item"></param> /// <returns></returns> private Model.FileLogModel GetModelByDataRow(DataRow item) { Model.FileLogModel model = new Model.FileLogModel(); //[UserID],[UserName],[UserRealName],[ActionType],[Remark],[Ip],[ProjectID],[ProjectName],[ProjectPath],[ClientPath],[AddTime] if (item["id"].ToString() != "") { model.ID = int.Parse(item["id"].ToString()); } if (item["UserID"].ToString() != "") { model.UserID = int.Parse(item["UserID"].ToString()); } if (item["UserName"].ToString() != "") { model.UserName = item["UserName"].ToString(); } model.ActionType = item["ActionType"].ToString(); model.Remark = item["Remark"].ToString(); model.Ip = item["Ip"].ToString(); model.FileID = int.Parse(item["FileID"].ToString()); model.FileName = item["FileName"].ToString(); model.FileVerID = int.Parse(item["FileVerID"].ToString()); model.FileVer = int.Parse(item["FileVer"].ToString()); model.ActionName = item["ActionName"].ToString(); model.UserRealName = item["UserRealName"].ToString(); model.FileType = int.Parse(item["FileType"].ToString()); model.ProjectID = int.Parse(item["ProjectID"].ToString()); model.ProjectName = item["ProjectName"].ToString(); model.ProjectPath = item["ProjectPath"].ToString(); model.ClientPath = item["ClientPath"].ToString(); model.ParentForderId = int.Parse(item["ParentForderId"].ToString()); if (item["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(item["AddTime"].ToString()); } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.FileLogModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "FileLog("); strSql.Append("[UserID],[UserName],[UserRealName],[ActionType],ActionName,[Remark],[Ip],[ProjectID],[ProjectName],[ProjectPath],[ClientPath],[FileId],[FileName],[FileVerID],[FileVer],[FileType],[ParentForderId],[ActionCode],[AddTime])"); strSql.Append(" values ("); strSql.Append("@UserID,@UserName,@UserRealName,@ActionType,@ActionName,@Remark,@Ip,@ProjectID,@ProjectName,@ProjectPath,@ClientPath,@FileId,@FileName,@FileVerID,@FileVer,@FileType,@ParentForderId,@ActionCode,@AddTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar, 100), new SqlParameter("@UserRealName", SqlDbType.NVarChar, 100), new SqlParameter("@ActionType", SqlDbType.NVarChar, 100), new SqlParameter("@ActionName", SqlDbType.NVarChar, 100), new SqlParameter("@Remark", SqlDbType.NVarChar, 1000), new SqlParameter("@Ip", SqlDbType.NVarChar, 200), new SqlParameter("@ProjectID", SqlDbType.Int, 4), new SqlParameter("@ProjectName", SqlDbType.NVarChar, 100), new SqlParameter("@ProjectPath", SqlDbType.NVarChar, 2000), new SqlParameter("@ClientPath", SqlDbType.NVarChar, 2000), new SqlParameter("@FileID", SqlDbType.Int, 4), new SqlParameter("@FileName", SqlDbType.NVarChar, 200), new SqlParameter("@FileVerID", SqlDbType.Int, 4), new SqlParameter("@FileVer", SqlDbType.Int, 4), new SqlParameter("@FileType", SqlDbType.Int, 4), new SqlParameter("@ParentForderId", SqlDbType.Int, 4), new SqlParameter("@ActionCode", SqlDbType.NVarChar), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@ReturnValue", SqlDbType.Int) }; parameters[0].Value = model.UserID; parameters[1].Value = model.UserName; parameters[2].Value = model.UserRealName; parameters[3].Value = model.ActionType; parameters[4].Value = model.ActionName; parameters[5].Value = model.Remark; parameters[6].Value = model.Ip; parameters[7].Value = model.ProjectID; parameters[8].Value = model.ProjectName; parameters[9].Value = model.ProjectPath; parameters[10].Value = model.ClientPath; parameters[11].Value = model.FileID; parameters[12].Value = model.FileName; parameters[13].Value = model.FileVerID; parameters[14].Value = model.FileVer; parameters[15].Value = model.FileType; parameters[16].Value = model.ParentForderId; parameters[17].Value = model.ActionCode; parameters[18].Value = model.AddTime; parameters[19].Value = ParameterDirection.Output; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); int obj = (int)parameters[19].Value; if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.FileLogModel model) { return(dal.Add(model)); }