public bool Update(Model.Camera model)
{
int rowsAffected;
IDataParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 8),
new SqlParameter("@DevId", SqlDbType.Int, 4),
new SqlParameter("@DnsAddr", SqlDbType.VarChar, 50),
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@PassWord", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.DevId;
parameters[2].Value = model.DnsAddr;
parameters[3].Value = model.UserName;
parameters[4].Value = model.PassWord;
DbHelperSQL.RunProcedure("T_Camera_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
public Model.Camera DataRowToModel(DataRow row)
{
Model.Camera model = new Model.Camera();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.ID = int.Parse(row["Id"].ToString());
}
if (row["DevId"] != null && row["DevId"].ToString() != "")
{
model.DevId = int.Parse(row["DevId"].ToString());
}
if (row["DnsAddr"] != null && row["DnsAddr"].ToString() != "")
{
model.DnsAddr = row["DnsAddr"].ToString();
}
if (row["UserName"] != null && row["UserName"].ToString() != "")
{
model.UserName = row["UserName"].ToString();
}
if (row["PassWord"] != null && row["PassWord"].ToString() != "")
{
model.PassWord = row["PassWord"].ToString();
}
}
return(model);
}
public int Add(Model.Camera model)
{
int rowsAffected;
IDataParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 8),
new SqlParameter("@DevId", SqlDbType.Int, 4),
new SqlParameter("@DnsAddr", SqlDbType.VarChar, 50),
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@PassWord", SqlDbType.VarChar, 50)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.DevId;
parameters[2].Value = model.DnsAddr;
parameters[3].Value = model.UserName;
parameters[4].Value = model.PassWord;
DbHelperSQL.RunProcedure("T_Camera_ADD", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
public CameraControllerViewModel()
{
Camera = new Model.Camera();
CameraController = new Model.CameraController(Camera);
}
/// <summary>
/// 修改一条记录
/// </summary>
public bool Update(Model.Camera model)
{
return(_dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Camera model)
{
return(_dal.Add(model));
}
public DebugState(Model.Vec2Int windowSize, Model.Vec2Float mousePosWindow, Model.Vec2Float mousePosWorld, string[] pressedKeys, Model.Camera camera, int playerIndex)
{
this.WindowSize = windowSize;
this.MousePosWindow = mousePosWindow;
this.MousePosWorld = mousePosWorld;
this.PressedKeys = pressedKeys;
this.Camera = camera;
this.PlayerIndex = playerIndex;
}
