public ContentResult Update()
{
ResultData <string> rt = new ResultData <string>();
SColumn u = GetUpdate <SColumn>();
uService.UpdateColumn(u);
return(ReturnResult(rt));
}
public ContentResult Add()
{
ResultData <string> rt = new ResultData <string>();
SColumn u = GetAdd <SColumn>();
uService.AddColumn(u);
return(ReturnResult(rt));
}
public ContentResult Delete()
{
ResultData <string> rt = new ResultData <string>();
//获取前台传会的删除ID
SColumn column = GetDelete <SColumn>();
uService.RemoveColumn(column);
return(ReturnResult(rt));
}
public SDatabase Install(SColumn c, long p)
{
var obs = objects;
if (c.uid >= STransaction._uid)
{
obs += (c.uid, c);
}
var tb = ((STable)obs[c.table]) + c;
return(New(obs + (c.table, tb), names + (tb.name, tb), p));
}
int IComparable.CompareTo(object obj)
{
if (obj == null)
{
throw new ArgumentNullException("obj");
}
SColumn sc = obj as SColumn;
if (sc == null)
{
throw new InvalidOperationException("obj must be of type SColumn.");
}
return(string.Compare(sc.name, name, StringComparison.Ordinal));
}
public SDatabase Install(SAlter a, long c)
{
var obs = objects;
if (a.uid >= STransaction._uid)
{
obs += (a.uid, a);
}
if (a.parent == 0)
{
var ot = (STable)obs[a.defpos];
var nt = new STable(ot, a.name);
return(New(obs + (a.defpos, nt), names - ot.name + (a.name, nt), c));
}
else
{
var ot = (STable)objects[a.parent];
var oc = (SColumn)ot.cols[a.defpos];
var nc = new SColumn(oc, a.name, a.dataType);
var nt = ot + nc;
return(New(obs + (a.defpos, nt), names + (a.name, nt), c));
}
}
/// <summary>
/// 更新列
/// </summary>
/// <param name="scolumn"></param>
/// <returns></returns>
public bool UpdateColumn(SColumn scolumn)
{
return(cRepository.Update(scolumn));
}
/// <summary>
/// 删除列
/// </summary>
/// <param name="scolumn"></param>
/// <returns></returns>
public bool RemoveColumn(SColumn scolumn)
{
return(cRepository.Delete(scolumn));
}
/// <summary>
/// 插入新列
/// </summary>
/// <param name="scolumn"></param>
/// <returns></returns>
public int AddColumn(SColumn scolumn)
{
object result = cRepository.Insert(scolumn);
return(Convert.ToInt32(result));
}
