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);
}