public async Task <IActionResult> PutCollumn(int id, Collumn collumn) { if (id != collumn.CollumnId) { return(BadRequest()); } _context.Entry(collumn).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CollumnExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <Collumn> > PostCollumn(Collumn collumn) { _context.Collumn.Add(collumn); await _context.SaveChangesAsync(); return(CreatedAtAction("GetCollumn", new { id = collumn.CollumnId }, collumn)); }
public static void UpdateColumn(Collumn collumn) { int ResultAdd = -1; try { using (SqlConnection conn = new SqlConnection(conexao)) { using (SqlCommand command = new SqlCommand("dbo.UpdateColumn", conn) { CommandType = System.Data.CommandType.StoredProcedure }) { command.Parameters.Add("@pName", System.Data.SqlDbType.NVarChar).Value = collumn.Name; command.Parameters.Add("@pIdSprint", System.Data.SqlDbType.Int).Value = collumn.IdSprint; ResultAdd = Convert.ToInt32(command.Parameters["@ResultAdd"].Value); conn.Open(); command.ExecuteNonQuery(); } } } catch (Exception ex) { throw new Exception("Failed: the Sprint was not update.", ex); } }
/// <summary> /// 加入欄位 /// </summary> /// <param name="_TitleName">欄位的字</param> /// <param name="_SourceName">SQL的資料行</param> /// <param name="_Align">LEFT, CENTER, RIGHT</param> /// <param name="_Width">寬度 ex:20%, 100px, 不指定長度請給""</param> public void AddCol(string _TitleName, string _SourceName, string _Align, string _Width) { Collumn my_Collumn = new Collumn(); my_Collumn.TitleName = _TitleName.Trim(); my_Collumn.SourceName = _SourceName.Trim(); my_Collumn.Align = _Align.Trim(); my_Collumn.Width = _Width.Trim(); ListViewCollumns.Add(my_Collumn); }
public IActionResult UpdateColumn([FromBody] Collumn collumn) { try { CollumnBSS.UpdateColumn(collumn); return(Ok("Board created.")); } catch (Exception ex) { return(StatusCode(500, ex)); } }
public IActionResult addColumn([FromBody] Collumn collumn) { try { CollumnBSS.addCollumn(collumn); return(Ok()); } catch (Exception ex) { return(StatusCode(500, ex)); } }
private void DrawCollumnToggle(Collumn colType, string label, float width) { bool isVisible = IsCollumnVisible(colType); bool nowVisible = GUILayout.Toggle(isVisible, label, GUILayout.Width(width)); if (nowVisible) { visibleCollumns |= colType; } else { visibleCollumns &= ~colType; } }
/// <summary> /// 加入欄位 /// </summary> /// <param name="_TitleName">欄位的字</param> /// <param name="_SourceName">SQL的資料行</param> /// <param name="_Align">LEFT, CENTER, RIGHT</param> /// <param name="_Width">寬度 ex:20%, 100px, 不指定長度請給""</param> /// <param name="_FormulaDefine"> /// 格式:被取代的值1::取代成1^^被取代的值2::取代成2 ex: 0::XX^^1::YY, 當值為0時取代成XX, 當值為1時取代成YY /// </param> public void AddCol(string _TitleName, string _SourceName, string _Align, string _Width, string _FormulaDefine) { Collumn my_Collumn = new Collumn(); my_Collumn.TitleName = _TitleName.Trim(); my_Collumn.SourceName = _SourceName.Trim(); my_Collumn.Align = _Align.Trim(); my_Collumn.Width = _Width.Trim(); if (!string.IsNullOrEmpty(_FormulaDefine)) { string[] arrFormulaDefine = _FormulaDefine.Split(new string[] { "^^" }, StringSplitOptions.RemoveEmptyEntries); string[,] tmp = new string[arrFormulaDefine.Length, 2]; for (int i = 0; i < arrFormulaDefine.Length; i++) { tmp[i, 0] = arrFormulaDefine[i].Split(new string[] { "::" }, StringSplitOptions.RemoveEmptyEntries)[0]; tmp[i, 1] = arrFormulaDefine[i].Split(new string[] { "::" }, StringSplitOptions.RemoveEmptyEntries)[1]; } my_Collumn.FormulaDefine = tmp; } ListViewCollumns.Add(my_Collumn); }
public static void UpdateColumn(Collumn collumn) { CollumnDD.UpdateColumn(collumn); }
public static void addCollumn(Collumn collumn) { CollumnDD.addCollumn(collumn); }
private bool IsCollumnVisible(Collumn col) { return((visibleCollumns & col) > 0); }