/// <summary> /// 插入数据,返回自增列ID /// </summary> /// <returns></returns> public static bool Add(Trans.Db.Model.NBlock_Task NBlock_Task_obj, out Int64 ID) { ID = 0; SqlCommand cmd = new SqlCommand(); StringBuilder cols = new StringBuilder(); StringBuilder parameters = new StringBuilder(); string sql = "INSERT INTO NBlock_Task({0}) values({1});SELECT @@IDENTITY;"; if (cols.Length > 0) { cols.Append(","); parameters.Append(","); } cols.Append("[BlockCode]"); parameters.Append("@BlockCode"); if (!string.IsNullOrEmpty(NBlock_Task_obj.BlockCode)) { cmd.Parameters.AddWithValue("@BlockCode", NBlock_Task_obj.BlockCode); } else { cmd.Parameters.AddWithValue("@BlockCode", ""); } if (cols.Length > 0) { cols.Append(","); parameters.Append(","); } cols.Append("[FilePath]"); parameters.Append("@FilePath"); if (!string.IsNullOrEmpty(NBlock_Task_obj.FilePath)) { cmd.Parameters.AddWithValue("@FilePath", NBlock_Task_obj.FilePath); } else { cmd.Parameters.AddWithValue("@FilePath", ""); } if (cols.Length > 0) { cols.Append(","); parameters.Append(","); } cols.Append("[Status]"); parameters.Append("@Status"); cmd.Parameters.AddWithValue("@Status", NBlock_Task_obj.Status); if (cols.Length > 0) { cols.Append(","); parameters.Append(","); } cols.Append("[UploadLog]"); parameters.Append("@UploadLog"); if (!string.IsNullOrEmpty(NBlock_Task_obj.UploadLog)) { cmd.Parameters.AddWithValue("@UploadLog", NBlock_Task_obj.UploadLog); } else { cmd.Parameters.AddWithValue("@UploadLog", ""); } if (cols.Length > 0) { cols.Append(","); parameters.Append(","); } cols.Append("[CoverStatus]"); parameters.Append("@CoverStatus"); if (!string.IsNullOrEmpty(NBlock_Task_obj.CoverStatus)) { cmd.Parameters.AddWithValue("@CoverStatus", NBlock_Task_obj.CoverStatus); } else { cmd.Parameters.AddWithValue("@CoverStatus", ""); } if (cols.Length > 0) { cols.Append(","); parameters.Append(","); } cols.Append("[ErrorServer]"); parameters.Append("@ErrorServer"); if (!string.IsNullOrEmpty(NBlock_Task_obj.ErrorServer)) { cmd.Parameters.AddWithValue("@ErrorServer", NBlock_Task_obj.ErrorServer); } else { cmd.Parameters.AddWithValue("@ErrorServer", ""); } if (cols.Length > 0) { cols.Append(","); parameters.Append(","); } cols.Append("[IsDel]"); parameters.Append("@IsDel"); cmd.Parameters.AddWithValue("@IsDel", NBlock_Task_obj.IsDel); if (cols.Length > 0) { cols.Append(","); parameters.Append(","); } cols.Append("[CreateTime]"); parameters.Append("@CreateTime"); if (NBlock_Task_obj.CreateTime == null || NBlock_Task_obj.CreateTime == DateTime.MinValue) { cmd.Parameters.AddWithValue("@CreateTime", DateTime.Now); } else { cmd.Parameters.AddWithValue("@CreateTime", NBlock_Task_obj.CreateTime); } sql = string.Format(sql, cols.ToString(), parameters.ToString()); cmd.CommandText = sql; bool b = true; try { object idobj = new Trans.Db.DBUtility.DBHelper(false).ExecScalar(cmd); ID = Convert.ToInt64(idobj); if (ID == 0) { b = false; } } catch { b = false; } return(b); }
/// <summary> /// 更新数据,行级数据锁定 /// 返回:操作影响记录数,-1表示没有需要更新的列 /// </summary> /// <param name="NBlock_Task_obj"></param> /// <param name="IsRowLock">是否锁行</param> /// <returns></returns> public static int Update(Trans.Db.Model.NBlock_Task NBlock_Task_obj, bool IsRowLock) { if (NBlock_Task_obj.ModifiedColumns.Count <= 0) { return(-1); } StringBuilder sqlSet = new StringBuilder(); StringBuilder sqlWhere = new StringBuilder(); string sql = string.Empty; if (IsRowLock) { sql = "UPDATE NBlock_Task WITH(ROWLOCK) SET {0} WHERE {1}"; } else { sql = "UPDATE NBlock_Task SET {0} WHERE {1}"; } SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue("@ID", NBlock_Task_obj.ID); cmd.Parameters["@ID"].SqlDbType = System.Data.SqlDbType.BigInt; if (sqlWhere.Length > 0) { sqlWhere.Append(" AND "); } sqlWhere.Append("[ID]=@ID"); if (NBlock_Task_obj.ModifiedColumns.Contains("[BlockCode]")) { if (string.IsNullOrEmpty(NBlock_Task_obj.BlockCode)) { NBlock_Task_obj.BlockCode = ""; } if (sqlSet.Length > 0) { sqlSet.Append(","); } sqlSet.Append("[BlockCode]=@BlockCode"); cmd.Parameters.AddWithValue("@BlockCode", NBlock_Task_obj.BlockCode); cmd.Parameters["@BlockCode"].SqlDbType = System.Data.SqlDbType.NVarChar; } if (NBlock_Task_obj.ModifiedColumns.Contains("[FilePath]")) { if (string.IsNullOrEmpty(NBlock_Task_obj.FilePath)) { NBlock_Task_obj.FilePath = ""; } if (sqlSet.Length > 0) { sqlSet.Append(","); } sqlSet.Append("[FilePath]=@FilePath"); cmd.Parameters.AddWithValue("@FilePath", NBlock_Task_obj.FilePath); cmd.Parameters["@FilePath"].SqlDbType = System.Data.SqlDbType.NVarChar; } if (NBlock_Task_obj.ModifiedColumns.Contains("[Status]")) { if (sqlSet.Length > 0) { sqlSet.Append(","); } sqlSet.Append("[Status]=@Status"); cmd.Parameters.AddWithValue("@Status", NBlock_Task_obj.Status); cmd.Parameters["@Status"].SqlDbType = System.Data.SqlDbType.Int; } if (NBlock_Task_obj.ModifiedColumns.Contains("[UploadLog]")) { if (string.IsNullOrEmpty(NBlock_Task_obj.UploadLog)) { NBlock_Task_obj.UploadLog = ""; } if (sqlSet.Length > 0) { sqlSet.Append(","); } sqlSet.Append("[UploadLog]=@UploadLog"); cmd.Parameters.AddWithValue("@UploadLog", NBlock_Task_obj.UploadLog); cmd.Parameters["@UploadLog"].SqlDbType = System.Data.SqlDbType.NVarChar; } if (NBlock_Task_obj.ModifiedColumns.Contains("[CoverStatus]")) { if (string.IsNullOrEmpty(NBlock_Task_obj.CoverStatus)) { NBlock_Task_obj.CoverStatus = ""; } if (sqlSet.Length > 0) { sqlSet.Append(","); } sqlSet.Append("[CoverStatus]=@CoverStatus"); cmd.Parameters.AddWithValue("@CoverStatus", NBlock_Task_obj.CoverStatus); cmd.Parameters["@CoverStatus"].SqlDbType = System.Data.SqlDbType.NVarChar; } if (NBlock_Task_obj.ModifiedColumns.Contains("[ErrorServer]")) { if (string.IsNullOrEmpty(NBlock_Task_obj.ErrorServer)) { NBlock_Task_obj.ErrorServer = ""; } if (sqlSet.Length > 0) { sqlSet.Append(","); } sqlSet.Append("[ErrorServer]=@ErrorServer"); cmd.Parameters.AddWithValue("@ErrorServer", NBlock_Task_obj.ErrorServer); cmd.Parameters["@ErrorServer"].SqlDbType = System.Data.SqlDbType.NVarChar; } if (NBlock_Task_obj.ModifiedColumns.Contains("[IsDel]")) { if (sqlSet.Length > 0) { sqlSet.Append(","); } sqlSet.Append("[IsDel]=@IsDel"); cmd.Parameters.AddWithValue("@IsDel", NBlock_Task_obj.IsDel); cmd.Parameters["@IsDel"].SqlDbType = System.Data.SqlDbType.Int; } if (NBlock_Task_obj.CreateTime != null && NBlock_Task_obj.CreateTime > DateTime.MinValue && NBlock_Task_obj.ModifiedColumns.Contains("[CreateTime]")) { if (sqlSet.Length > 0) { sqlSet.Append(","); } sqlSet.Append("[CreateTime]=@CreateTime"); cmd.Parameters.AddWithValue("@CreateTime", NBlock_Task_obj.CreateTime); cmd.Parameters["@CreateTime"].SqlDbType = System.Data.SqlDbType.DateTime2; } sql = string.Format(sql, sqlSet.ToString(), sqlWhere.ToString()); cmd.CommandText = sql; try { return(new Trans.Db.DBUtility.DBHelper(false).ExecNonQuery(cmd)); } catch { return(-1); } }